How to Mail Merge Addresses in Envelopes Using Excel and Word

By Contributing Writer

Do you have a large mailing list in Excel or Word? Creating a mail merge between Excel and Word can be an intimidating task but it is worth doing.This process really saves time if you are creating a mass mailing list, with many different addresses. It beats addressing all the letters individually by hand or by computer.

Things You'll Need

  • Computer with a printer
  • Microsoft office suite
  • Workbook in excel
  • Business letter idea

Step 1

Create a excel workbook with the data as needed for your mailing list. Suggested headings are first name, last name, street address, state, and zip code. Make certain you use the list format for the cells in your excel workbook as it makes the merge process much simpler. Save the file and close it.

Step 2

Open Microsoft word to continue with the mail merge. Select the tools menu; go to letters and mailings options and on to document type. This opens a new document in which your master letter will be typed.

Step 3

Choose your recipients, then click browse and select the excel workbook which contains the names and addresses you wish to use. Open this workbook, and in the select table box click the list you created for this purpose.

Step 4

Select the column labels of the information you wish to use in your mass mailing. This is why it is important to make sure in step one that you have easily identified columns. You can either use this list entirely or edit the list to include some of those people on the list.

Step 5

Create your letter by typing what you need to share with the selected people. Remember to do a spell check and a grammar check all documents before printing. Preview the letter, add a background, or otherwise personalize it as needed.

Tips & Warnings

  • Mail merge also can email a document to several people, and address several envelopes for your mass mailings.