Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Consilidation of Mail Merge Recipients
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. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Consilidation of Mail Merge Recipients
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.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 wrote in message oups.com... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
mail merge recipients | Mailmerge | |||
Mail Merge Recipients box does not work | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |