New Perspectives Word 2019 | Module 6: End of Module Project 2 E&I Community Bank
CREATING MAILING LABELS
· Excel Projects Help
GETTING STARTED
1. Open the file NP_WD19_EOM6-2_FirstLastName_1.docx, available for download from the SAM website.
2. Save the file as NP_WD19_EOM6-2_FirstLastName_2.docx by changing the “1” to a “2”.
a. 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.
3. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
Support_WD19_EOM6-2_Clients.mdb
4. With the file NP_WD19_EOM6-2_FirstLastName_2.docx still open, ensure that your first and last name is displayed in the footer.
a. If the footer does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. You work in the Estate Planning Department at the E&I Community Bank in Scottsdale, Arizona. To keep your clients informed about financial workshops the bank provides, you often send them postcards with workshop details. You are creating mailing labels to add your clients' names and addresses to the postcards. Start a mail merge, and then select Labels as the type of main document. Select Avery US Letter 5162 Address Labels to add a table structure of two columns for 4-inch labels to the document.
2. Use Support_WD19_EOM6-2_Clients.mdb as the recipient list. Edit the data source to customize the columns in the recipient list by deleting the Company Name field and the Country or Region field, which do not contain any data. Add the two recipients shown in Table 1 to the data source.
Table 1: Recipient Addresses
Field | New Record 1 | New Record 2 Title | Ms. | Mr. First Name | Anna | Ted Last Name | Garcia | Perry Address 1 | 773 W. Glendale St. | 2126 N. School Rd. Address 2 | | City | Scottsdale | Scottsdale State | AZ | AZ Postal Code | 85258 | 85255
3. Sort the recipient list in ascending order by Postal Code to organize the mailing labels for a bulk mailing.
4. On the first mailing label, insert an AddressBlock merge field in the Mr. Joshua Randall Jr. format. Update the labels. (Hint: Turn the formatting marks on. If the paragraph mark appears on the second page, click the box in the bottom right corner of the table containing the labels and drag the bottom border of the table up until they all appear on the first page of the document.)
5. Finish and merge all records to a new document. In the new document containing the merged mailing labels, click the Table Selection icon shown in Figure 1 to select the table, and then copy the selected table to the Office Clipboard. In the original main document, insert a page break at the end of the document, and then paste the merged mailing labels in the blank paragraph at the end of the document so that all of your assignment appears in the same file. (If there is an extra blank page at the end of the document, delete the final paragraph marker to remove it.) Turn off the preview of the mail merge results (if necessary), and save the original main document. Close the new, merged mailing labels document without saving it.
Figure 1: Selecting the Mailing Labels Table
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.
Final Figure