Excel module 6 sam project

Shelly Cashman Word 2016 | Module 6: SAM Project 1a Aspen Centers PERFORM A MAIL MERGE GETTING STARTED • Open the file SC_WD16_6a_FirstLastName_1.docx, available for download from the SAM website. • Save the file as SC_WD16_6a_FirstLastName_2.docx by changing the “1” to a “2”. o • If you do not see the .docx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file SC_WD16_6a_FirstLastName_2.docx still open, ensure that your first and last name (Joshua Walker) is displayed in the footer. o If the footer does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. You are the volunteer fundraising coordinator for the Aspen Centers, and you are writing a form letter to encourage past donors to support the centers again. To use the standard format for letters, change the page orientation to Portrait. 2. To increase the amount of space at the top of the first page, specify the Absolute Vertical position of the shape containing the letterhead as 1" below the Page. 3. At the bottom of page 1 and continuing on page 2, convert the 11 paragraphs of text starting with “Name…” and ending with “…South Bend” to a table with three columns to make the information easier to read. 4. To improve the appearance of the new table, format it as follows: a. Apply the Grid Table 4 – Accent 5 style to the table. b. Use the AutoFit Contents feature to resize the entire table to fit its contents. 5. Because the table exceeds the length of page 1, repeat the table header rows across pages. 6. To clarify the contents of the table, sort the table contents in ascending order, first by Type of Contribution and then by Center Location. Shelly Cashman Word 2016 | Module 6: SAM Project 1a 7. 8. To set up the document as a form letter, start the Step-by-Step Mail Merge Wizard, accept Letters as the document type, and then choose to use the current document as the starting document. Choose to create a new recipient list, and then customize the columns in the recipient list as follows: a. Customize the columns by deleting the Company Name, Country or Region, Work Phone, and E-mail Address fields. b. Rename the Home Phone field using Mobile Phone as the new field name. c. Add a new field to the end of the address list using Amount as the field name. Enter the address information for the two recipients shown in bold in Table 1 below, and then save the data source using a name of your choice. Table 1: Recipient Addresses Field Record 1 Record 2 Title Mr. Ms. First Name George Jean Last Name Montoya Williams Address 1 1351 E. Payne St. 45 N. Center Dr. Address 2 Apt. 901 City Bloomington South Bend State IN IN ZIP Code 47405 46624 Mobile Phone (812) 555-3375 (574) 555-1289 Amount $50.00 $25.00 9. Continue to Step 4 in the Mail Merge wizard, and then use the Date content control with the “CLICK HERE TO SELECT A DATE” placeholder text to select the date April 6, 2020. 10. Insert the inside address as follows: 11. a. Select the placeholder text “INSERT INSIDE ADDRESS”, and then insert an AddressBlock merge field using the Mr.