How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

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 …

Select And or Or, and then add another condition to your filter if you want. For example, select Or, choose City in the Field list, select Equal to, and then type the name of the second city. Now you're …

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 …

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.

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.

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.

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.

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.

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 …