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.
It may help to get the insight, if you think of the mail merge process in terms of 3 documents. This tutorial provides an overview of the main features and explains how to do a mail merge from Excel step-by-step. It lets you quickly create custom letters, emails or mailing labels in Word by merging the information you already have in your Excel spreadsheet. Mail Merge from Excel to Word can be a real time-saver when it comes to sending large mailings.