View Single Post
  #2   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 increment invoice number within mail merge

Unless you already have the information that will be the data source for the
merge already in some application, you would be better off using a userform
into which you enter that data.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and the following pages of fellow MVP Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

and also

the last in the following series of articles:

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
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
"Nick_F" wrote in message
...
I use an autonew macro at present to find a text file, collect a number,
launch a new bill document from a template and print the "next" bill
number
on the bill - the number in the text file then increments by one.
I am experimenting with generating a mail-merge fillable bill template and
want to be able to pick up a new number for each bill in a bill run so
each
printed copy gets a unique number. My other users will, however, need to
be
able to go on accessing the autonew macro in the non-mergeable template to
deal with individual bills. I may also make mistakes in running the mail
merge and want to be able to have an option to reset the starting number
back
to whatever it began at if I abandon the mail merge. Any (really simple as
I
am a techno-clot) solutions spring to mind?