- #HOW TO COMBINE PAGES IN WORD USING MAILINGS HOW TO#
- #HOW TO COMBINE PAGES IN WORD USING MAILINGS ZIP#
Once the source data spreadsheet is set and reviewed, you are ready to run the mail merge. Here's an example of an Excel sheet that can be used for a mail merge:
#HOW TO COMBINE PAGES IN WORD USING MAILINGS HOW TO#
If you plan to use your Outlook contacts, the following article may be helpful: How to export Outlook contacts to Excel.txt file, this tutorial will help you do that right: Importing CSV files into Excel. If you create an Excel spreadsheet by importing information from a.
#HOW TO COMBINE PAGES IN WORD USING MAILINGS ZIP#
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.
Prepare Excel spreadsheet for Mail MergeĪ mail merge may look like a daunting task, but in fact the process is pretty simple.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 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.