Making+a+mail+merge+-+labels,+letters,+etc.

In the older days, you were expected to type in all the addresses onto letters and envelopes. Now with the use of Excel and Word, you are able to take an excel spreadsheet, import the information in Word and the addresses will be added instintly.

The following will be instructions on how to make a mail merge:

1. Type in all the address information that is needed into an excel spreadsheet (ie: Name, Address, etc.). You may type in headers/categories for your spreadsheet, but it is not necessary.



2. Save the excel spreadsheet.

3. Open Word and open a document that you would like to perform the mail merge on.



4. Click on the Mailings tab, select the Start Mail Merge button and select Letters.



5. Select Select Recipients -.> Use Existing List -> and open up the excel spreadsheet that you saved. Another window will pop up - click ok.

6. Place your cursor one space under the address. Select Insert Merge Field and select Full Name. <> should pop up on the screen after you select it.



7. Continue with the rest of the merge fields.



8. Select Preview Results to see how your mail merge will look. If acceptable, select Finish & Merge and print documents. Save the documents.



9. The same steps can be used for making envelopes. Select Start Mail Merge -> select Envelope Size -> click OK.

10. On the top-left corner of the envelope, place the return address.

11. Place the cursor in the center of the envelope (a blue dotted box should appear). Select Select Recipients -.> Use Existing List -> and open up the excel spreadsheet that you saved. Another window will pop up - click ok. Insert the appropriate Merge Fields, preview and print envelopes.



Hopefully that has helped you be able to make letters and envelopes using the mail merge function.

Marianna Schardien INFO 270-13