When you save the mail merge envelope document, it stays connected to your mailing list so that you can use it for your next bulk mailing.
Step 7: Save your mail merge envelope document Tip: To go to the start of the list, choose the First record button, and to go to the end of the list, choose the Last record button. Repeat as necessary.ĭo a final check before you print the envelopes.Ĭhoose Preview Results, and then choose the Next or Previous record button to make sure the names and addresses on all the envelopes look right. If (not matched) appears in a field name that you expected to match a column heading in your data source, choose the drop-down arrow, and then choose the field name in your mailing list data source. If the field names shown match column headings you used for records in your mailing list data source, do nothing. Verify that the field names that appear on the left side match the names of column headings for records in your mailing list so Word can put the correct data in the correct place on your envelope. The column on the right lets you match up fields in your data source to those field names. In the Match Fields dialog box, the column on the left are the field names that Word uses in an Address Block. On the Mailings tab, in the Write & Insert Fields group, choose Match Fields. Make sure Word puts the names and addresses from your mailing list in the right places on your envelope. Note: Under Preview, choose the Next or Previous record button to move through records in your data source and view how an address will appear on the envelope.Ĭhoose File > Save to save your merge document before proceeding. For more information on filtering your data see Sort and filter the data for a mail merge.
Create mail merge from excel code#
If you want to print envelopes for people on your list who live, for example, within 20 miles of an event you're hosting, then use a filter like a ZIP Code or a postal code to narrow the list. If you're printing envelopes for everyone on your list, go to Step 5: Add the address block to the envelope. If you're using your Outlook contacts, choose Choose from Outlook Contacts. Then browse to your list and choose Open. If your mailing list is in an Excel spreadsheet, an Access database, or another type of data file, choose Use an Existing List. If you don't have a mailing list, choose Type a New List and create one. On the Mailings tab, in the Start Mail Merge group, choose Select Recipients, and then choose an option. Now you're ready to open the data source for your mailing list. Step 4: Link your mailing list to your main document If you'd like to add a return address, or logo, to your envelope now is a good time to add that. Note: Word creates a document that's sized to the envelope dimensions and shows where the return address appears on the envelope.
It's always a good practice to run a small test batch of envelopes before you do a real mail merge. If you want to use your Outlook contacts, make sure Outlook is your default email program.Ī preliminary step in the mail merge process is to set up the envelope for the merge.
For more information see Format mail merge numbers, dates, and other values in Excel If you're using an Excel spreadsheet, make sure the column for ZIP Codes or postal codes is formatted as text so that you don't lose any zeros. Before you start the mail merge process, collect all of your address lists, and add them to your data source. If you don't have a mailing list, you can create one during mail merge. It contains the records Word pulls information from to build the addresses to be printed on the envelopes. It can be an Excel spreadsheet, a directory of Outlook contacts, an Access database, or an Office address list. When you combine those two documents using the steps below you'll have your addressed envelopes. This document contains the addresses to be printed on the envelopes. The return address on the envelope is an example of identical content. This document contains text and graphics (a logo or an image, for example) that are identical for each version of the merged envelope. These are the documents involved in creating and printing envelopes using the mail merge process: Or, if you want to create and send email using mail merge see, Use mail merge to send bulk email messages Or, if you're looking to create letters using mail merge, see Use mail merge to personalize letters for bulk mailings
Create mail merge from excel how to#
If you're looking for how to create and print labels with mail merge, see Create and print labels using mail merge
0 kommentar(er)
