![]() |
|
#1
|
|||
|
|||
|
I have an excel spreadsheet:
family first name last name product in my excel spread sheet i can have the same family name more than once, with different product.: row 1 Mr. and Mrs. Smith Sam Smith ABC row2 Mr. and Mrs. Smith Sam Smith GHI row 3 Mr. and Mrs. Smith Sam Smith xyz in my mail merge letter i want: Dear (family_name) (body of the letter) list of (product) abc ghi xyz sincerely, Acme Group I started the mail merge using Mailing -> Start Mail Merge -> Directory Select Receipiants -> chose my spread sheet and made sure its sorted by Family_Name inserted all my merge fields how do i check when the family_name changes in the excel spread sheet and i have a new letter for the next family?? |
| Tags |
| mailmerge field, many to one mail merge |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How do I mail merge records into table columns with more than one merge field?
|
tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
| Multiple Records Mail Merge using Email | Skybluekid | Mail Merge | 1 | 03-28-2016 02:33 PM |
| Mail merge--skipping records | 623bookends | Mail Merge | 2 | 01-12-2014 06:02 AM |
Mail Merge - Many Records for Each Addressee
|
awalker1970 | Mail Merge | 1 | 12-31-2010 11:52 AM |
Combine Records when Mail Merge from Access
|
Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |