WORD WEEK SIX

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.