Independent Practice: Mail Merge Student Activity

Student Name: Period: Date:

Independent Practice: Mail Merge

Activity 1 Instructions

Use the Mail Merge Wizard to create the Main Document and Data Source shown below. Two fields will need to be added when creating the new data list (dollar and number). The underlines throughout the letter are the placeholders. Also, create mailing labels. Correct all spelling, keying, and formatting errors.

(Current Date)

(Address Block)

Dear (first name)

Your registration fee of $(dollar) for (number) entry(s) has been received for the “Race for the Arts” 5K Fun Run. The adult 5K race starts at 8:00 am, and the children’s race starts at 9:00 am. There will be snacks and drinks provided for everyone. Prizes for achievement will be given to individuals in each of the various age groups.

Please arrive early to get your “Race for the Arts” t-shirt and entry number. Again, (first name), thank you for supporting the Arts.

Sincerely

Veronica Powell

5K Race Director

xx

Data Source

Shawn Cooper
6219 Maple Crest St.
Morgan Hill, CA 95037
$40.00
two entries / Ricardo Suarez
5440 Braeswood Ave.
Morgan Hill, CA 95037
$20.00
one entry / Eddie Copeland
7622 Bankside St.
Morgan Hill, CA 95037
$20.00
one entry / Irene Larison
1106 Fallen Oaks Ln.
Morgan Hill, CA 95037
$60.00
three entries

Mail Merge Activity 10

Answer Key

Activity 2 Instructions

Use the Mail Merge Wizard to create the Main Document and Data Source shown below. Three fields will need to be added when creating the new data list (lecture, date, time). The underlines throughout the letter are the placeholders. Also, create envelopes. Correct all spelling, keying, and formatting errors.

(Current Date)

(Address Block)

(Greeting)

The Museum of Natural Science is hosting a new lecture series featuring three well-known guest speakers. These distinguished speakers are outstanding leaders in their respective disciplines. This is a wonderful opportunity for Museum patrons to meet leaders in the scientific community.

You are enrolled in the (lecture) series on (date) at (time). The admission fee includes dessert and coffee and a chance to talk with the guest lecturer. We look forward to your visit.

Sincerely

Janice Matthews

Museum Curator

xx

Data Source

Mr. Sam Goode
7733 Cayton Dr.
Columbus, OH 43220
Mysteries of the Universe
September 12
7:00 pm / Ms. Olivia Humphreys
4114 Merrimac Dr.
Columbus, OH 43220
Search for the Whales
September 13
4:00 pm / Mrs. Claire Moore
5807 Hewitt Ave.
Columbus, OH 43220
Search for the Whales
September 13
4:00 pm / Mr. & Mrs. Phillip Myers
1988 Beck Street
Columbus, OH 43220
Mysteries of the Universe
September 21
7:00 pm