losavenue.blogg.se

Preparing 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 personalized letters, emails, labels, or envelopes.

Word document with codes for the personalized fields.Excel source file with information about the recipients such as names, addresses, emails, etc.To get a grasp of the basics, you can think of it in terms of 3 documents. A mail merge may look like a daunting task, but in fact the process is pretty simple.