Mail Merge
Today's assignment is dealing with Mail Merge. You will be using Excel and Word to create this.
Please see below for your mail merge assignment.
What is a mail merge?
Facility provided by most word processing program whereby a form-letter can be sent to many recipients, each letterpersonalized for each recipient. The program takes each recipients name and address (from a mailing list) and enters it in its usual place on the letter, and also prints out mailing labels.
(taken from http://www.businessdictionary.com/definition/mailmerge.html )
Mail Merge Assignment-Envelopes
1. Open up a New Excel File, Save it as yourname_addressbook
2. Enter the information as follows in Row 1
Last name First Name Street Address City/Town State Zip code
3. Complete it with 10 of your family or friends information, making sure to format your zip code column
4. Save
5. Open up Word
6. Click on "tools" on the menu bar
7. choose Mail merge Manager, a toolbox/window will appear with steps on it
7. Click on create new> choose envelope
8. Add your your own address in the bottom envelope of the box, where it says return address.
9. Click ok
10. Click on "get list" > Open data source >choose file > open
you should see this screen, click ok
11. You should now see items in your placeholders appear. These should be the categories you listed in row 1.
12. Now you will drag the placeholders into your envelope as follows:
First Name Last name
Street Address
City, State zip code
Your document should look like this
13. You are going to skip 4 and 5 on your box and move right to 6. Complete Merge. Click on the second button from the left "Merge to new Document"
14. After clicking, this a new document should appear with your envelopes addressed.
15. Save this file as completed merge_yourname
16. Add your file to the class folder on your dock.
