![](/rp/kFAqShRrnkQMbH6NYLBYoJ3lq9s.png)
Mail merge using an Excel spreadsheet - Microsoft Support
How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.
Prepare your Excel data source for a Word mail merge - Microsoft …
If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge. But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a mail merge. Step 1: Set up your data source in Excel
How to use the Mail Merge feature in Word to create and to print …
This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to …
Use mail merge to send bulk email messages - Microsoft Support
Create and send personalized email messages to everyone on your address list with mail merge.
Mail merge with envelopes - Microsoft Support
If you don’t have a mailing list, you can create one during mail merge. Collect all of your address lists, and add them to your data source. If you're using an Excel spreadsheet, format the ZIP Codes or postal codes column as text to preserve any zeros.
Use mail merge for bulk email, letters, labels, and envelopes
Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work.
Video: Take mail merge to the next level - Microsoft Support
In Introduction to Mail Merge you learned the basics: how to set up mail merge with the wizard, create a list of recipients, add basic mail merge fields, and print envelopes. But there is a lot more you can do.
Data sources you can use for a mail merge - Microsoft Support
Here are few examples of data sources you can use for mail merge in Word. Excel spreadsheet. An Excel spreadsheet works well as a data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. For more information, see Prepare your Excel data source for mail merge.
Video: Mail merge - Microsoft Support
Mail merge using an Excel spreadsheet. Insert mail merge fields. Create and print mailing labels for an address list in Excel. Use Word mail merge for email
Create an Address List for mail merge - Microsoft Support
Use Mail Merge to automatically add mailing addresses or other personalized information to your publications. On the Mailings tab, click Mail Merge > Step-by-Step Mail Merge Wizard.