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) file, you …
How to use the Mail Merge feature in Word to create and to print form ...
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.
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 if …
Print labels for your mailing list - Microsoft Support
Training: Watch and learn how to print mailing labels with an Excel address list, from your Outlook contacts, or from a new list you’ve created.
Use mail merge in Word to send bulk email messages
If you don't have a mailing list, you can create one during mail merge. If you're using an Excel spreadsheet, format the ZIP/postal codes column as text to avoid auto deletion of leading zeroes. …
Create and print mailing labels for an address list in Excel
If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel worksheet, you can use a Microsoft Word mail merge. The mail merge process creates a sheet of mailing labels …
Mail merge with envelopes - Microsoft Support
If you're using an Excel spreadsheet, format the ZIP Codes or postal codes column as text to preserve any zeros. For more info see Format mail merge numbers, dates, and other values in Excel.
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 document.
Use mail merge to personalize letters - Microsoft Support
Mail merge lets you create a batch of personalized letters where each letter is identical in layout, formatting, text, and graphics, except for personalized parts like the salutation.