Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from Excel Data, multiple lines on same letter
I'm trying to do a mail merge of one letter per customer, letting them know
what they were paid for. Problem: Each line designates who was paid and the amount. Some people were paid more than once. I don't want to create one letter per payment. How do I tell the mail merge "If the customer name is the same as the line before, then put the next payment on a second line on the same letter. If the customer name isn't the same, move onto the next letter"? Also, can I make it look like a table? For example: Joe Smith was paid $2.00 on 1/2/08 $3.00 on 2/3/08 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from Excel Data, multiple lines on same letter
you are trying to perform a "multiple items per condition (=key
field)" mailmerge which, "out of the box", 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 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "LuxAeterna" wrote in message ... I'm trying to do a mail merge of one letter per customer, letting them know what they were paid for. Problem: Each line designates who was paid and the amount. Some people were paid more than once. I don't want to create one letter per payment. How do I tell the mail merge "If the customer name is the same as the line before, then put the next payment on a second line on the same letter. If the customer name isn't the same, move onto the next letter"? Also, can I make it look like a table? For example: Joe Smith was paid $2.00 on 1/2/08 $3.00 on 2/3/08 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from Excel Data, multiple lines on same letter
Thank you for your reply, Doug.
After posting my question, I looked through the other threads for similar answers and have referenced the links you listed. I've been trying to follow both sites, but am not having much luck... I've managed to get a few singular merge fields to work, but can't get the rest functioning properly. I neglected to mention that I'm using Office 2007. Are there any resources (besides articles) you know of that can help me to finish this mail merge? Consultants, etc? Thanks again for your time. Much appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple excel lines on one letter on mail merge. | Mailmerge | |||
Merge Excel Data into Word but NOT as a letter format? | Mailmerge | |||
How do I stop 0's taking up lines in letter when no data in s/shee | Mailmerge | |||
Mail Merge letter with Excel Data incorporated | Mailmerge | |||
Mail merge option with multiple data source records in one letter. | Mailmerge |