Search results
Results from the 24/7 Vacations Content Network
How to use mail merge in Word to create custom documents, envelopes, email, and labels.
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, Word merges a main document with a recipient list to generate a set of output documents:
How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.
Mail merge using an Excel spreadsheet. Insert mail merge fields. Create and print mailing labels for an address list in Excel. Use Word mail merge for email. How to use mail merge to print a set of labels, emails, letters, or envelopes that are addressed to the people on your mailing list.
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.
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.
A mailing list can be created within Word for sending bulk mail during mail merge process. On the File tab, select New and choose New Document . On the Mailings tab, choose Select Recipients and select Create a New List .
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 first need to import the data into Excel, and then prepare it for a mail merge.
Once your mailing addresses are set up in an Excel spreadsheet (see the previous video to learn how), it's a snap to get Word to create mailing labels from them. Create your address labels. In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.