Prepare your Excel data source for a Word mail merge - Microsoft …
Use mail merge to create and send bulk mail, labels, and envelopes. Mail merge - A free, 10 minute, video training. If you've built a contact list in an Excel spreadsheet, it's important to format any zip codes or postal codes as text to avoid losing data.
Use mail merge for bulk email, letters, labels, and envelopes
Mail merge using an Excel spreadsheet. Use Outlook contacts as a data source for a mail merge. Document types. Word provides tools for incorporating your data into the following kinds of documents. Follow the links for details about each type: Letters that include a personalized greeting. Each letter prints on a separate sheet of paper.
Use mail merge to send bulk email messages - Microsoft Support
To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send created and open in Microsoft Word.
Data sources you can use for a mail merge - Microsoft Support
You can retrieve contact information directly from your Outlook contact list in Word. To use this as your data source, choose Choose from Outlook Contacts. For more information, see Use Outlook contacts as a data source for a mail merge. Choose a new or existing data source to use in your mail merge document.
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.
Insert mail merge fields - Microsoft Support
Add individual merge fields. 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.
Create and print labels - Microsoft Support
To create labels with a mailing list, see Print labels for your mailing list. To create labels using a template, see Microsoft label templates. Learn how to make labels in Word. You can create and print a full page of address labels or nametags. Get started on how to print labels from Word.
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. If you want to use your Outlook contacts, make sure Outlook is your default email program.
Set the rules for a mail merge - Microsoft Support
Set the rules for a mail merge. When you're sending letters to your mailing list you can customize the message. For example, include the words "Past due" for some recipients based on values in certain fields of the data source. The customization is …
Get help from Microsoft Support Services
Go to the Access Help Center. At the bottom of the page, click Contact Us. Learn how to contact product support for your Office applications.
Create a sheet of nametags or address labels - Microsoft Support
Windows macOS Web. Create and print a page of different labels. Go to Mailings > Labels. Select the label type and size in Options. If you don’t see your product number, select New Label and configure a custom label. Select New Document. Word opens a new document that contains a table with dimensions that match the label product.