Consilidation of Mail Merge Recipients

[JHolt2006]

My situation is this. I am trying to send email reminder invoices out
to multiple clients via a mail merge using Excel as the database of
choice. I currently have each invoice on a separate row with all of
the information provided.

The problem I run into is that for clients with multiple invoices, I
will send them an email for each invoice because of the line by line
setup of my Excel database. Is there a way to counteract this and
consolidate all of the data on one document for each email address I
send to? Thanks.

 

[Doug Robbins - Word MVP]

You are wanting to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303


http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.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