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/microsoft.public.word.numbering/browse_thread/thre
ad/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 - 30 Jul 2007 11:01 GMT
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

Signature
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
> Hi there
>
[quoted text clipped - 16 lines]
> MHO
> Spain
mariaholbaek@hotmail.com - 30 Jul 2007 12:31 GMT
> Hi there
>
[quoted text clipped - 15 lines]
> MHO
> Spain
I will try what you have send. Many thanks.
MHO