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
|