How Do You Mail Merge Addresses In Envelopes Using Excel And Word?
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. 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. 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. 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 b
