#1
|
|||
|
|||
Many records to One Mail Merge Document
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 |