Mail Merge Data

One of the more powerful uses of Excel is the Mail Merge. We are able to take data from a spreadsheet and create personalized copies of a form letter.

To work with the mail merge data you need to create a new spreadsheet that contains the names and addresses of 25 people.

Your data should contain the following columns:

1. Last Name
2. Hand Phone
   
3. House/Block Number
   
4. First Name
5. Work Number
6. Phone Number
7. Street
8. Postal Code
9. City
10. Country
11. Percentage
12. Letter Grade
13. Tuition Owed
    

Place the columns in an order that makes sense!

Use the same names as you did for the gradebook, we will be including some values from the gradebook spreadsheet.

For the different numerical data columns you should create a random function to get the values.

We will look at a way to connect the Percentage and Letter Grade columns to the gradebook sheet you have created already.