To reuse your envelope mail merge document, open the document and choose Yes when Word prompts you to keep the connection.
If you’d like to add a return address, or logo, to your envelope now is a good time to add that. When you save the mail merge envelope document, it stays connected to your mailing list for future use. In the Envelope Options dialog box, check your options, and then choose OK.
For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge. How to create a mail merge envelopes Go to Mailings > Start Mail Merge > Envelopes. Connect and edit the mailing listĬonnect to your data source. Click to select the Confirm file format conversion on open check box, and then click OK. On the Advanced tab, go to the General section. In Word 2010/2013, click File, and then click Options.
In Word 2007, click the Office Button, and then click Word Options. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. Start Word, and then open a new blank document. Excel will be used to create the database of names and addresses, while msword will be used to format the printing of the labels or envelopes. Source: Learn how to mail merge to create envelopes using microsoft word and excel. Choose the appropriate field you want to merge and choose Insert. print envelopes on the mailings tab click start mail merge envelopes. On the Mailings tab, choose the ‘Insert Merge Field’ button, a list of the column headers on your saved excel document will drop down (i.e. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. On your Word document, highlight the field you want to populate with the data from Excel. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge.
Here are some tips to prepare your Excel spreadsheet for a mail merge.