Invoice with mail merge AND macros

[mariaholbaek]

Hi there

Im trying to make an invoice using mail merge (costumers name and
adresses from access) AND at the same time using macros to make an
invoicenumber that increments. But this is not easy. The problem seems
to be making the macro increment the number when ever I change
recipent in my mail merge document. Also I cannot seem to get the
macro to start by number 7000 in stead of 0 even though I have change
the The default starting number. iDefault = 7000 (Im using the macro
explained by John McGhie here
http://groups.google.dk/group/micro...ead/thread/620df0cb92c1137c/6d8d1537d298d60d?
lnk=st&q=Microsoft+Word+make+invoice+with+automatic
+number&rnum=1&hl=da#6d8d1537d298d60d

Is there any way to solve this or am I trying to do the impossible?
Any help would be apreciated.

Thanks.
MHO
Spain

 

[Doug Robbins - Word MVP]

Why don't you use a report in Access? That is what I would do.

That is not to say that it cannot be done with Word, but Access is a more
suitable application for it.

See the article "Creating sequentially numbered documents (such as
invoices)" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm

See the article "Sequentially numbering multiple copies of single document
using a macro" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm

See the article "Sequentially numbering multiple copies of single document
using a mailmerge" at:

http://www.word.mvps.org/FAQs/MailMerge/NumberCopiesOfDocMMerge.htm




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

 

[mariaholbaek]

Hi there

Im trying to make aninvoiceusingmailmerge(costumers name and
adresses from access) AND at the same time usingmacrosto make an
invoicenumber that increments. But this is not easy. The problem seems
to be making the macro increment the number when ever I change
recipent in mymailmergedocument. Also I cannot seem to get the
macro to start by number 7000 in stead of 0 even though I have change
the The default starting number. iDefault = 7000 (Im using the macro
explained by John McGhie herehttp://groups.google.dk/group/microsoft.public.word.numbering/browse_...
lnk=st&q=Microsoft+Word+make+invoice+with+automatic
+number&rnum=1&hl=da#6d8d1537d298d60d

Is there any way to solve this or am I trying to do the impossible?
Any help would be apreciated.

Thanks.
MHO
Spain

I will try what you have send. Many thanks.
MHO