1.

You volunteer as the development coordinator for the Friends of Cannon River, and you are writing a form letter to encourage members to donate to an event sponsored by the organization. To use the standard format for letters, change the page orientation to Portrait.

Change the page orientation.

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 0.75" below the Page.

Position a shape using absolute values.

3.

At the bottom of page 1 and continuing on page 2, convert the 11 paragraphs of text starting with "Name…" and ending with "…Cannon River Summit" to a table with three columns to make the information easier to read.

Convert text to a table.

4.

To improve the appearance of the new table, format it as follows: a. Apply the List Table 3 – Accent 5 style to the table. b. Use the AutoFit Contents feature to resize the entire table to fit its contents.

Apply a table style.

Format a table using AutoFit.

5.

Because the table exceeds the length of page 1, repeat the table header rows across pages.

Repeat a table header row.

6.

To clarify the contents of the table, sort the table contents in ascending order, first by Event and then by Amount.

Sort a table.

7.

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 Phone as the new field name. c. Add a new field to the end of the address list using Amount as the field name.

Customize a recipient list.

8.

Enter the address information for the two recipients shown in bold in Table 1 in the Instructions file, and then save the data source using a name of your choice.

Enter a recipient address.

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 June 21, 2020.

Select a date using the Date Picker content control.

10.

Insert the inside address as follows: a. Select the placeholder text "INSERT INSIDE ADDRESS", and then insert an AddressBlock merge field using the Mr. Joshua Randall Jr. format. b. Delete the placeholder text.

Insert an AddressBlock merge field.

11.

Insert the greeting line as follows: a. Select the placeholder text "INSERT GREETING LINE", and then insert a GreetingLine merge field using the Dear Joshua: format. b. Delete the placeholder text.

Insert a GreetingLine merge field.

12.

In the paragraph above the table, select the "[DONATION AMOUNT]" placeholder text, and then insert a merge field for Amount to include the previous donation amount for each recipient.

Insert a merge field.

13.

To include a personalized postscript, add an IF field as follows: a. In the blank paragraph at the bottom of page 2, insert an If…Then…Else... rule. b. Compare whether the City field is equal to Northfield. c. Use the following as the true text: P.S. Stop by our booth at the Cannon Riverfest this year. d. Use the following as the false text: P.S. When you are in Northfield, please call me for a tour of the riverfront.

Insert an IF field.

14.

Continue to Step 5 of the Mail Merge wizard, and then edit the recipient list to sort the data records in ascending order by ZIP code in preparation for bulk mailing.

Enter a recipient address.

15.

Complete the mail merge as follows in the lettered steps below. You will merge to a new document and then copy the contents of the merged file to the end of your original document, so that all of your assignment appears in the same file. a. Continue to Step 6 of the Mail Merge wizard, and then merge all records to a new document. b. In the new document containing the merged form letters, press CTRL+A to select all contents in the document, and then copy the selected text to the Office Clipboard. c. In the document SC_WD16_6b_FirstLastName_2.docx, move the insertion point to the blank paragraph at the top of page 3, and then paste the merged form letter into the main document. d. Verify that the pasted merged form letters appear only on pages 3–6 of the document SC_WD16_6b_FirstLastName_2.docx. e. Delete the page break and the Next Page section break at the bottom of page 6 to make the document six pages long. f. Turn off the preview of the mail merge results. Close the new, merged document without saving it.

Copy and paste a merged letter into your SAM Project file.