- How to mail merge in office 2016 for envelopes how to#
- How to mail merge in office 2016 for envelopes code#
How to mail merge in office 2016 for envelopes 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
How to mail merge in office 2016 for envelopes 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)
