WORD WEEK SIX

 

1. Open and print the “Week 6 Assignment”.

2. The assignment has four parts: A, B, C, and D.
(Part A has been created for use of the Access program where the data source recipients are to be created. However, if you do not have the Access program then you will need to create the data source recipients with the Excel program before you begin keying the letters for the mail merge. Also, If you are using Excel then be certain to create the label headers in each column with the data source recipient information beneath the headers. Whether you use Access or Excel you MUST save the data source in the Week 6 folder in which you will upload. If you do not save the data source recipients in the folder then I am not able to grade your assignment.)

3. Create a folder:  [your last name]-Week6 (be sure to save to a disk device/hard drive NOT the desktop area.)

5. Complete the assignment as instructed and Save all work in [your last name]-Week6 folder.

6. Zip the folder and upload in the Week 6 Assignment Upload. DO NOT ATTACH THE FOLDER TO EMAIL, IT WILL NOT BE ACCEPTED. I will review the assignment and send you comments about the graded work.

PART A

Create a folder to save the assignment for week 6.
Your last name-Week-6

Use mail merge to create a data source from the following three pages.
Remove the following fields:

Country
HomePhone
WorkPhone
Email

Add a new field named Seminar
Add a new field named Job Title (you may wish to move up / down fields in order of data
entry)

Enter the records as shown on the three pages.

Save the data source as dat-Seminar

Title

FirstName

Lastfjiame
JobTitle
Company
Addressi
Address2-u .
City
State, ,
PostalCode
Seminar ‘

Mr.
Jeffrey

Levine
Manager •Si ‘ <

W’

Forstythe Clothiers
2902 Karen Rd.
Suite 61 East
San Francisco
CA
94109
Business on the Web

Title

LastName
JobTitle
Company
Addre,ss1
Address2
City
State
PostalCodg-
Seminar

Ms.
Liz
Mohoney
Director
Beehive Properties i i f

7865 Stuart Dr.

Salt Lake City
UT
84122
Internet Commerce

,^^/’..•’

T i | | f e – ; T – : : Ms.
FirstName

JobTftle ^

Melanie FirstName

JobTftle ^
Jackson

FirstName

JobTftle ^ Assistant Manager

Add’rfssl ^
Brooklyn Design

Add’rfssl ^ 89 Beaumont Ave.
Address2 .
Ciiyy” ^ Brooklyn
State NY

11235
Sefninar Business on the Web

}

mmm

Title ” ‘

FirstName • .
LastN^me*,’^
JobTitle
Company
Addressi I
Address2 i

Mr.
Alex
Daniels
Manager
Long Island Gardens
592 Roosevelt Parkway
Suite 21A

Title ‘ Mr.
FirstName Suhail
LastName Nakahmi
JobTitle ^ Manager
Company Applewood Bookstore
Addressi 73 Applewood Lane
Adar§ ‘̂̂ 2V- .
C i t y \ – Cambridge
Stat^ MA
Pos^lfeode – I
Seminar

02129 Pos^lfeode – I
Seminar Internet Commerce

P A R T E

Instructions: Key the form letter shown below in modified block style with mixed punctuation
and indented paragraphs. Be certain to use the proper line spacing.

Insert fields shown with « » .

Save the letter as frm. Seminar

« A d d r e s s B l o c k »

Dear « T i t l e » « L a s t N a m e »

This letter is to confirm receipt of your registration for the « S e m i n a r »
seminar scheduled for February, in Phoenix, Arizona. The event promises to
be chock fiiU of interesting and innovative information for your company,
« C o m p a n y » . We hope you are as excited about the event as we are!

Please note, « T i t l e » « L a s t N a m e » , the updated schedule included on
the following page. We w i l l continue to notify you i f additional changes are
made; however, we believe this schedule w i l l remain intact.

I look forward to seeing you in February for the « S e m i n a r » seminar.

Sincerely

Steven Godere
Event Coordinator

X X

STATE-OF-THE-ART-SOLUTIONS ^
P.O. Box 6743211
Brentwood CA 90049

P A R T C

Merge the data source and the fonn letter to a new document.

Save the merged documents as mrg-Seminar
(Be sure the documents are saved in the Week-6 folder)

P A R T D

Close the merged documents.
Edit the recipient list
Delete the entire record for Jeffrey Levine.
Create a filter. You want only recipients who have a Job Title of Manager or who live in the
State of Utah.
Now continue to merge the data source and the form letter to a new document.
Save the merged documents as filter-Seminar
(Be sure the documents are saved in the Week-6 folder)

Check to make sure the data source, dat-Seminar; the form letter, frm-Seminar; the merged
documents, mrg-Seminar; and the filtered data with merged document, filter-Seminar; are saved
in the Week-6 folder.

Zip the folder then upload the zipped folder.