add 1 to a pre set number in mail merge

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

Try Graham Mayor's page at

http://www.gmayor.com/automatic_numbering_documents.htm


Peter Jamieson

http://tips.pjmsn.me.uk

On 24/02/2010 15:21, Pete_Free wrote:
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

You could use the following field construction

{ = ### + { MERGEREC } }

where ### is a number one less than the first number that you want to be
used. You must use Ctrl+F9 to insert each pair of field delimiters { } and
Alt+F9 to toggle off their display.

--
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, originally posted via msnews.microsoft.com

"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

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