If you want to add more contacts or other information, you'd better make the changes or additions in your Excel sheet now before running the mail merge. So, before starting the merge in Word, make sure your Excel file has all the information you want to include such as first names, last names, salutations, zip codes, addresses, etc. When you run a mail merge, your Excel file will get connected to your Word mail merge document, and Microsoft Word will be pulling the recipients' names, addresses and other details directly from your Excel worksheet. Preparing the Excel spreadsheet for Mail Merge The goal of the mail merge is to combine the data in File 1 and File 2 to create File 3. The final Word document with the personalized letters, emails, envelops etc.
Excel mail merge source file with information about the recipients, one row for each recipient.Word mail merge document with codes for the personalized fields.
It may help to get the insight, if you think of the mail merge process in terms of 3 documents. Mail merge with dates, currencies and other numbersĭoing a mail merge may look like a daunting task, but in fact the process is pretty simple.
#MAIL MERGE WITH EXCEL FOR MAC HOW TO#
0 kommentar(er)
