Link to home
Start Free TrialLog in
Avatar of contrain
contrainFlag for United States of America

asked on

Mail merge doc to many people

I have an xl 2016 sheet with 300 people I want to mail merge a word doc to this list and send each person their own separate doc in an email
Avatar of Karen Falandays
Karen Falandays
Flag of United States of America image

Yes, that will be easy. Make sure you have column headings/field names in your Excel SS.
Open Word, and create your doc.
Choose Mailing>Start MailMerge
Select email message
Select recipients>use existing list
Make sure to preview list before doing the merge.

You can only have on Subject Line for all
Avatar of contrain

ASKER

Does one of my xl sheet fields have to be the email address for each person? I want them each to get their own email and not see the other people's names.
ASKER CERTIFIED SOLUTION
Avatar of Karen Falandays
Karen Falandays
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This solution worked perfectly.