Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Number Format Scott Mailmerge 1 March 12th 09 03:21 PM
Formatting A Number In Mail Merge George Microsoft Word Help 1 August 23rd 06 05:42 PM
Mail merge number formatting Lindie Mailmerge 1 October 5th 05 09:32 PM
sort mail merge by merge record number nathan Mailmerge 1 August 10th 05 07:09 AM
Using mail merge and fax to different fax number Jimmy Mailmerge 1 March 22nd 05 10:36 PM


All times are GMT +1. The time now is 08:12 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"