Excel to Word Mail Merge Question

[kiki443]

I have an Excel spreadsheet with data laid out for a mail merge. I have no problem with the general mail merge in Word.

The problem is that I am trying to prepopulate a form to notify customers of what is still outstanding. Each record creates a new invoice. How can I put all of the data pertaining to 1 customer on the same form?

KiKi

 

[Macropod]

Hi KiKi,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://lounge.windowssecrets.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

 

[kiki443]

Thank you very much. I will try this out and let you know how it goes.