Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge Number Format | Mailmerge | |||
Formatting A Number In Mail Merge | Microsoft Word Help | |||
Mail merge number formatting | Mailmerge | |||
sort mail merge by merge record number | Mailmerge | |||
Using mail merge and fax to different fax number | Mailmerge |