If you intend to sort the contacts by state or city, verify that you have a separate State or City column. For instance, if you wish to address the recipients by their first name, be sure to create separate columns for the first and last names. The columns in the spreadsheet match the fields you want to use in a mail merge.Your Excel sheet has one row for each recipient.If you want to add more details, you'd better do this before starting the merge.
When you run a mail merge, your Excel file will get connected to your Word document, and Microsoft Word will be pulling the recipient details directly from the connected worksheet.īefore running a mail merge in Word, make sure your Excel file has all the information you want to include such as first name, last name, salutation, zip codes, addresses, etc. 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.
Mail Merge can be a real time-saver when it comes to sending mass mailings. This end-to-end tutorial will teach you how to effectively mail merge in Word using an Excel sheet as the data source.