Search results
Results from the WOW.Com Content Network
How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.
If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet contains an address from the list.
Print labels for your mailing list. 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. We will use a wizard menu to print your labels.
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.
Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.
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.
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:
Training: This video tutorial shows you how to use mail merge to create and print address labels for a bunch of recipients.
Training: Go beyond the mail merge basics. Import lists from Excel, and use Excel's data and number tools. Customize your mail merge with personalized messages.
Data sources you can use for a mail merge. Recipients of a mail merge usually come from a list of names and data in an existing list, like an Excel spreadsheet, or your Outlook contacts list. The existing list could also be any database that you can connect to.