Excel address book template for mail merge

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback?

Submit feedback. Thank you for your feedback! If you want to use your Outlook contacts, make sure Outlook is your default email program. If necessary, run a test on a small test batch of envelopes before you do a real mail merge.

Type your address in the Return address box. If you'd like to add a return address, or logo, to your envelope now is a good time to add that. Place your cursor were you want the address block to go. Choose OK. Do a final check before you print the envelopes. Choose OK to close the Envelope dialog box. On the Mailings tab, choose Select Recipients. Step 1: Prepare your main document The mailing list is your data source. In the Return address box, type your address. Choose OK when finished. Under 3.

Insert Placeholders , choose Contacts. Drag a field name from the Contacts list to the envelope's address box. Repeat Step 4 for all the fields that you want to appear on your envelopes. To finish creating your envelopes, do one of the following: To print immediately, in Mail Merge Manager , under 6. Need more help? Expand your skills. Get new features first. Was this information helpful? On the Home tab, in the Format box, choose Text.

Now, you can use this data for a mail merge. Step 1: Set up your data source in Excel If you're using an Excel spreadsheet as your data source for a mail merge in Word, skip this step. After you successfully import a. Open Excel. Choose the. In the preview window, select Transform Data. Select Replace current. Repeat steps 5 - 7 as needed. Notes: The available formats are General , Text , and Date.

Step 1: Set up your data source in Excel If you're already using an Excel spreadsheet as your data source for a mail merge in Word, go to Step 2 in this topic. Open Excel, and on the Data tab, choose From Text. In the Text Import Wizard , choose Next. Note: Save your spreadsheet with a new file name. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help.

Can you help us improve? You can reuse the mail merge document for your next bulk mailing. Open the mail merge document and choose Yes when Word prompts you to keep the connection. Use mail merge to create and send bulk mail, labels, and envelopes. Mail merge - A free, 10 minute, video training.

Discover more Word training at LinkedIn Learning. For more info, see Mail merge: Edit recipients. For more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.

Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge. All data to be merged is present in the first sheet of your spreadsheet. The Excel spreadsheet to be used in the mail merge is stored on your local machine. Notes: You can import information from your Excel spreadsheet by importing information from a comma-separated value.

Choose OK. Use mail merge to create and send bulk mail, labels, and envelopes Mail merge - A free, 10 minute, video training Discover more Word training at LinkedIn Learning.