Shelly Cashman Word 2019 | Module 6: End of Module Project 1 #shellycashman #module6 #eomproject1
If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,
Whatsapp Contact Link:
wa.me/message/PPXGSJS2TLWUA1
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
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.
Change the orientation.
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.
Convert text to a table.
Resize table columns.
Apply a table style.
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.
Select the document type for a mail merge.
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.
Enter a recipient address.
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.
Use a Date content control.
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.
Insert the AddressBlock merge field.
7. Replace the placeholder text "INSERT GREETING LINE" with a GreetingLine merge field using the Dear Mr. Randall: format.
Insert the GreetingLine merge field.
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.
Insert the Organization_Name merge field.
Insert the Specialty merge field.
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.
Insert an IF field.
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.
Sort a recipient list.
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.
Copy and paste merged letters into your SAM Project file.
shelly cashman excel 2019 | module 1: sam project 1b,#shelly cashman excel 2019 | module 1: sam project 1b,shelly cashman excel 2019 | module 5: sam project 1a,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 module 1 sam project 1a,new perspectives word 2019 | module 10: sam project 1a,excel module 8 sam end of module project 1,new perspectives excel 2019 | module 2: sam project 1a