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

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 …

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 …

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, …

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.

Create and send personalized email messages to everyone on your address list with mail merge.

Use mail merge to print envelopes that are addressed to the people on your mailing list.

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.

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.

Use Address Block, Greeting Line, and other merge fields to create a mail merge file from your mailing list.