Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / New Perspectives Word 2016 | Module 6: SAM Project 1a Camille’s Classic Cars PERFORMING A MAIL MERGE GETTING STARTED   Open the file NP_WD16_6a_ FirstLastName _1

New Perspectives Word 2016 | Module 6: SAM Project 1a Camille’s Classic Cars PERFORMING A MAIL MERGE GETTING STARTED   Open the file NP_WD16_6a_ FirstLastName _1

MS Word

New Perspectives Word 2016 | Module 6: SAM Project 1a

Camille’s Classic Cars

PERFORMING A MAIL MERGE

GETTING STARTED

 

Open the file

NP_WD16_6a_

FirstLastName

_1.docx

, available for download

from the SAM website.

 

Save the file as

NP_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

NP_WD16_6a_

FirstLastName

_2.docx

still open, ensure that your

first and last name are 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 creating a form letter to send to people who requested more information

about Camille’s Classic Cars at a recent car show. Begin formatting the

document by selecting the list of technicians and their specialties on page 1

(beginning “Glenna Warner” and ending “Engine modifications”), and then set a

left tab stop at

3"

using the

2.......

dotted line leader option.

2

On page 2, convert the four paragraphs describing the services (“Total

restoration”, “Upgrades”, “Mechanical disassembly”, and “Interior restoration”)

to a table with three columns by separating the text at each tab.

1.

Insert a new row at the beginning of the table, and then enter the text shown in

bold in Table 1 below.

Table 1: Header Row

Service

Hourly Rate

Description

2.

Insert a column to the right of the “Hourly Rate” column, and then enter the

text shown in bold in Table 2 on the next page.

Table 2: New Column

Header row

Average Hours

Row 2

400 to 600

Row 3

30 to 100

Row 4

100 to 300

Row 5

30 to 200

3.

Format the header row using

bold

and

Teal, Accent 6, Lighter 60%

(10

th

column, 3

rd

row of the Theme Colors palette) shading.

4.

Start a mail merge, and then select

Letters

as the type of main document.

Next, type a new recipient list as follows:

a.

Customize the columns by deleting the

Company Name

,

Country or

Region

, and

Work Phone

fields.

b.

After the

Email Address

field, add a new field using

Car Model

as the

name.

c.

Enter the recipient information shown in bold in Table 3 below.

d.

Save the data source using a name of your choice.

Table 3: Recipient Information

Title

Mr.

First Name

Adam

Last Name

Ludgate

Address Line 1

5744 Park Circle

Address Line 2

Apartment 4B

City

Chicago

State

IL

ZIP Code

60604

Home Phone

(773) 555-0102

Email Address

ludgate@tech.cengage.com

Car Model

Camaro

5.

At the beginning of the letter, delete “[INSERT INSIDE ADDRESS]”, but not the

paragraph mark, and then insert the eight merge fields shown in Figure 1 below.

Include the paragraph marks, punctuation, and spaces between the merge

fields as shown.

Figure 1: Merge Fields for the Inside Address

6.

In the greeting line, delete “[INSERT TITLE]”, and then insert the Title merge

field. Next, delete “[INSERT LAST NAME]”, and then insert the Last_Name merge

field.

7.

In the paragraph after the greeting line, delete “[INSERT CAR MODEL]”, and

then insert the Car_Model merge field.

8.

In the paragraph that begins “Please call me...”, delete “[INSERT EMAIL

ADDRESS]”, and then insert the Email_Address merge field.

9.

Complete the mail merge as instructed in the lettered steps below. You will

merge to a new document and then copy the contents of the merged file to the

bottom of your original document, so that all of your assignment appears in the

same file.

a.

Finish and merge all records to a new document.

b.

In the new document

Letters1.docx

, which contains the merged form

letter, press

CTRL+A

to select all contents in the document, and then

copy the merged form letter to the Office Clipboard.

c.

In the file

NP_WD16_6a_

FirstLastName

_2.docx

, move the insertion

point to the blank paragraph at the end of the document, insert a Page

Break, and then paste the merged form letter into the main document.

d.

To remove the extra blank page at the end of your main document, delete

the Section Break and all but one of the blank paragraph marks. Verify

that the pasted merged form letter appears on pages 3 and 4 of the file

NP_WD16_6a_

FirstLastName

_2.docx

, and then turn off the preview of

the mail merge results.

Close the new, merged document without saving it.

Your document

NP_WD16_6a_FirstLastName_2.docx

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.

Note: When opening your 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.

 

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE