View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default add 1 to a pre set number in mail merge

Hi Peter,

You could use a MERGEREC field in conjunction with your starting number for the numbering.

For example, the values returned by those fields can be added to a constant, eg:
{QUOTE{={MERGEREC}+1000}}
Alternatively, can enhance the field code with an ASK field to solicit the starting #, eg:
{QUOTE{ASK Offset "What is the starting Invoice #?" \o}{SET Val {MERGEREC}}{=Offset+Val}}

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.


--
Cheers
macropod
[Microsoft MVP - Word]


"Pete_Free" wrote in message ...
I am doing a mail merge of invoices and want to have an invoice number that
increases by one for each invoice but the numbers must start from a
predefined starting point (say for example 243). So the invoices would be
numbered 243, 244, 245 etc etc.

Any help would be appreciated.

Regards