View Single Post
 
Old 05-08-2017, 01:09 PM
CONFUSEDOPSMANAGER CONFUSEDOPSMANAGER is offline Windows 10 Office 2016
Novice
 
Join Date: May 2017
Posts: 1
CONFUSEDOPSMANAGER is on a distinguished road
Default 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??
Reply With Quote