Word 7

Mail Merge

Start the Mail Merge in Word.

Use the appropriate fields, rename Address 1 to Street and delete fields not to be used. (If you are using Excel program for the data source then create the data source and save as shown.)

Key the variables below for the data source file.

Title	FirstName	LastName	Street	City	State	ZIPCode	Month
Mr.	John	Collins	76 Stewart Avenue	Grove City	PA	16127	January
Mrs.	Rebecca	Hoff	151 Henry Street	Springfield	OH	45503	November
Ms.	Patricia	Strayer	479 Oak Avenue	Hamilton	OH	45011	February
Mrs.	Mary Jane	Turner	505 Elmwood Street	Morgantown	WV	26101	October
Ms.	Nancy	Martin	231 Fifth Avenue	Clarksburg	WV	25701	April
Mr.	James	Clawson	93 Old Perry Highway	Erie	PA	16509	December
Ms.	Valerie	Gove	613 Buffalo Street	Franklin	PA	16323	May
Mr.	David	Morgan	978 Harbor Street	New Castle	PA	16105	March
Mrs.	Doris	Harmon	3225 Mayflower Drive	Pittsburgh	PA	15227	May

Save the data source file as DAT-MERGE-EXAM. (Be sure to save to the appropriate drive and not to the Desktop.)

To begin the document, the spacing before and after paragraph command must be set at 0” and spacing to Single. The font is Times New Roman and the font size is 12.

Key the Main Document Form in the appropriate Block Style Letter format with mixed punctuation. Begin at 2.1” from the top.

Insert Merge Fields to create the Address Block and Salutation. Insert the Merge Fields in the letter as indicated by the <<placeholders>>.

Close the letter with sincerely and the letter is from Donna Decker.

The following paragraphs are the body of the letter.

Thanks for visiting Decker’s Dairy recently. We hope you enjoyed your purchase, <<First_Name>>, and appreciate your registering to receive our newsletters and joining our birthday club membership.

As a token of our appreciation, we have included a coupon to be applied toward your next ice cream or gift purchase in <<Month>>. Please take advantage of this special offer.

<<First_Name>>, the next time you visit Decker’s Dairy, tell us you are visiting from <<City>>, <<State>>. You will receive 20% off your total order.

Save the Form Letter as FRM-MERGE-EXAM (Be sure to save to the appropriate folder and drive and not to the Desktop.)

· Merge the Data Source and Form Letter.

· Save the Merged Documents as MRG-MERGE-EXAM. (Be sure to save to the appropriate folder and drive and not to the Desktop.

· Close the Merged documents.

· Edit the Data Source to add a new entry. Mr. William Brown, 89 Birch Street, Dayton, OH, 45433, October.

· Filter the Data Source to display the records for the months of October or May.

· Merge to a New Document.

Save the filtered Merge document as MRG-FILTER-EXAM. (Be sure to save to the appropriate folder and drive and not to the Desktop.)