EC

Cloud Computing

· You need to see the attached Tutorial before you start this assignment

· You need a google account for this assignment. You can use your personal google account OR create a new account for this assignment.

· Read ond follow the instructions carefully.

Assume that you are a sales representative for a company and you want to take a 2-week vacation and want to inform your clients about this vacation. You keep your customers’ data in a spreadsheet that contains their LastName, FirstName, City, Email among other data.

1. Go to your gmail account , and create the following message template to import the lastname and city from a google spreadsheet.

2. Go to Google drive and create a google spreadsheet like this

a. Name the spreadsheet YourLastNameCustomers

b. Insert the isntructor’s name and email address ( [email protected] ) as the first customer (as given above); don’t use my UT email for this assignment.

c. Insert your name and your email address in the second row

d. Insert 2 additional names of your friends and their emails

3. Get the “Yet Another Mail Merge” from the Add-Ons menu in the spreadsheet you created.

4. Start the mail merge using the message you created above.

Note: Here it is how it will look like in my email when everything is done correctly and it will show that it was sent thru through YAMM (Yet Another Mail Merge).

5. Create a MS Word document and insert screen shots of your email message template; the spreadsheet that contains your customers, and the message you received from the mail merge upload your document to BB.

6. Your document should look like the attached the Screenshots below: