Mail Merge Number Sequencing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alison - 28 Apr 2006 10:39 GMT

Is it possible to force the merge sequencing to start at a number different
from 1? For example for various memos we do at work, they begin with 1 at
the beginning of the year, and each note gets the next number. So if I want
to merge a bunch of notes to various offices, I'd like to start with the next
number in our note system, which could be 21, for example. Is there a way to
tell the merge to start at 21, for example? So far I've only been able to
get mergerec to start at 1. Thanks for your advice.

Alison Lewis

Reply to this Message

Peter Jamieson - 28 Apr 2006 11:38 GMT

If the number isn't in the data source then your best bet is probably to
nest your MERGEREC field inside a formula (=) field that adds in a number
that you could supply in various ways, e.g. using a FILLIN/ASK field, one of
the built-in property fields which are easy to update using File|Properties.
You would have to know which number you wanted to start with.

e.g. { ={ MERGEREC }+{ FILLIN "Enter the first record number" \o } }

Where all the {} are the special field braces you cn insert using ctrl-F9

Peter Jamieson

> Is it possible to force the merge sequencing to start at a number
> different
[quoted text clipped - 9 lines]
>
> Alison Lewis

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2006 11:52 GMT

Maybe you should be using the technique in the article "Creating
sequentially numbered documents (such as invoices)" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is it possible to force the merge sequencing to start at a number
> different
[quoted text clipped - 9 lines]
>
> Alison Lewis

Reply to this Message

Alison - 28 Apr 2006 12:36 GMT

I've never used macros before, so I can't follow the article regarding
creating sequentially numbered documents. I tried to just paste in the
AutoNew template that the article gives into a Macro (after I clicked Create
under Macros), but I got an error. Do you have any insight on how to work
with macros?

Alison

"Doug Robbins - Word MVP" ha scritto:

> Maybe you should be using the technique in the article "Creating
> sequentially numbered documents (such as invoices)" at:
[quoted text clipped - 14 lines]
> >
> > Alison Lewis

Reply to this Message

Alison - 28 Apr 2006 13:03 GMT

I figured out a fix based on your article on the mailmerge. I just basically
merge the doc twice, saving it each time and using different sources each
time. Works...

Thanks,

Alison

"Doug Robbins - Word MVP" ha scritto:

> Maybe you should be using the technique in the article "Creating
> sequentially numbered documents (such as invoices)" at:
[quoted text clipped - 14 lines]
> >
> > Alison Lewis

Reply to this Message