Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Numbering / July 2007

Tip: Looking for answers? Try searching our database.

Invoice with mail merge AND macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mariaholbaek@hotmail.com - 29 Jul 2007 19:13 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.