Homework answers / question archive / Shelly Cashman Word 2019 | Module 6: End of Module Project 1 HISTORIC PLANNING COMMISSION Performing a Mail Merge with a New Recipient List GETTING STARTED Open the file SC_WD19_EOM6-1_FirstLastName_1

Shelly Cashman Word 2019 | Module 6: End of Module Project 1 HISTORIC PLANNING COMMISSION Performing a Mail Merge with a New Recipient List GETTING STARTED Open the file SC_WD19_EOM6-1_FirstLastName_1

MS Word

Share With

---

Shelly Cashman Word 2019 | Module 6: End of Module Project 1

HISTORIC PLANNING COMMISSION

Performing a Mail Merge with a New Recipient List

• GETTING STARTED

• Open the file SC_WD19_EOM6-1_FirstLastName_1.docx, available for download from the SAM website.
• Save the file as SC_WD19_EOM6-1_FirstLastName_2.docx by changing the “1” to a “2”.
  • 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_WD19_EOM6-1_FirstLastName_2.docx still open, ensure that your first and last name is displayed in the footer.
  • If the footer does not display your name, delete the file and download a new copy from the SAM website.

• PROJECT STEPS

1. As an administrative assistant for the Historic Planning Commission in Alexandria, Virginia, you are preparing a form letter to send to consultants and contractors that specialize in restoring historic properties.
   Change the page orientation to Portrait to use the standard format for letters.
2. Convert the five paragraphs in the middle of the letter beginning "Restoration Project…" and ending "…$127,000" into a table using tabs to separate the columns and a fixed column width. Apply the custom Letterhead Table style to the table.
3. 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 by deleting the fields shown in Table 1. Use Organization Name to rename the Company Name field. If necessary, use Postal Code to rename the ZIP Code field. Add a new field to the end of the recipient list using Specialty as the field name.

 

Country or Region

Home Phone

Work Phone

E-mail Address

 

4. Enter the address information for two recipients as shown in Table 2, and then save the data source using a name of your choice.

 

Field	Record 1	Record 2
Title	Ms.	Mr.
First Name	Linda	Jamal
Last Name	Lopez	Khan
Organization Name	Historic Designs	Khan Construction
Address Line 1	1170 Charles St.	352 Bay Rd.
Address Line 2	Suite 200
City	Baltimore	Alexandria
State	MD	VA
Postal Code	21202	22302
Specialty	historic architecture	site planning

 

5. 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 March 12, 2021.
6. Replace the placeholder text "INSERT INSIDE ADDRESS" with an AddressBlock merge field using the Mr. Joshua Randall Jr. format. Match the Company field to the Organization Name field so that the organization name appears in the inside address.
7. Replace the placeholder text "INSERT GREETING LINE" with a GreetingLine merge field using the Dear Mr. Randall: format.
8. In the first paragraph in the body of the letter, replace the "[ORGANIZATION NAME]" placeholder text with the "Organization_Name" merge field to include the name of each organization. In the last paragraph in the body of the letter, replace the "[SPECIALTY]" placeholder text with the "Specialty" merge field to include the restoration specialty of each organization.
9. At the end of the last paragraph in the body of the letter, insert an If…Then…Else rule that compares whether the State field is equal to VA. If it is, insert the following sentence:
   Because your business is located in Virginia, you can also apply for a state expansion grant.
   Otherwise, do not insert any additional text.
10. Continue to Step 5 of the Mail Merge wizard, and then edit the recipient list to sort the data records in ascending order by Last Name to generate the letters in alphabetic order by the recipient's last name.
11. Continue to Step 6 of the Mail Merge wizard, and then merge all records to a new document. 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.
    In the original form letter document, paste the merged form letters in the blank paragraph at the top of Page 2 so that all your assignment appears in the same file. Delete the page break and the Next Page section break at the bottom of Page 3 to make the document three pages long. Turn off the preview of the mail merge results, and save the original form letter document. Close the new, merged document without saving it.
    Note: When opening your file or the Graded Summary report for this Project, you may be prompted to Select From "Office Address List". Select No in the dialog box to view your report.

Your document should look like the Final Figure on the following pages. Save your changes, close the document, and then exit Word. Follow the directions on the SAM website to submit your completed project.