How to use the Mail Merge feature in Word to create and to print …
Describes how to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet.
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
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) …
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 you can use for a mail merge - Microsoft Support
Choose the type of data source you want to use for the mail merge, and then select Next. Follow the prompts in the Data Connection Wizard to complete the data connection to the merge …
Print labels for your mailing list - Microsoft Support
With your address list set up in an Excel spreadsheet you can use mail merge in Word to create mailing labels. Make sure your data is mistake free and uniformly formatted.
Use mail merge in Word to send bulk email messages
If you don't have a mailing list, you will be able to create one during mail merge. If you are using an Excel spreadsheet as your data source, format the ZIP/postal codes as text to avoid auto …
Use a table or query as a mail-merge data source
For example, you can export the table or query from Access to an ODBC database, a Microsoft Excel file, a text file, or any other file format that is compatible with Word, and then link to the …
Insert mail merge fields - Microsoft Support
To include data like phone numbers or email addresses, you insert those merge fields specifically. Also, a merge field like First Name doesn't have to be part of an Address Block or Greeting Line.
Common mail merge issues - Microsoft Support
In the Mail Merge Recipients dialog box, click the name of the data source and then click Edit. In the Edit Data Source box you can edit or delete existing addresses, or add new entrys.