Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pete_Free Pete_Free is offline
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default add 1 to a pre set number in mail merge

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default add 1 to a pre set number in mail merge

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   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


Reply
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 04: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 11:36 PM


All times are GMT +1. The time now is 02:28 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"