Mail Merge Holiday Project

Friday, November 17th

You need to create a database with the following fields:

• ID (Autonumber)
• Prefix
• First Name
• Last Name
• Address
• City
• State
• ZIP
• Phone
• Relationship (How do you know this person?)
• Sibling (brother or sister)

Then you are to fill in this information for 10 people. DO NOT use the exact same information that you compiled yesterday. For relationship, put cousin, friend, or however you know that person. For sibling, put the name of one of this person's brothers or sisters (if they do not have any, make up one).

Close this database, saving it if asked.

Open a Word document.

Create a Holiday themed letterhead with the following:

- Your name

- Your address

- Your e-mail address

- A graphic

- A textbox

- A bottom border

(The Holiday can be any holiday you want: (Halloween, Thanksgiving, etc...)

The picture is an example of a letterhead. Click on it to get a better view. A letterhead should be no bigger than about 1.5 inches tall. And should include your name, address, email address, etc as shown in the example.

After you finish the letterhead, you must write a full-block personal business letter.

-You do not need a return address since you have it in the letterhead.

- For the letter address and salutation, just type the following:

First Name Last Name

Address

City, State Zip Code

Dear First Name,

-The body of the letter should have the following:

-Paragraph 1: (2 sentences) Say hello to the person you are writing and ask them how they are. Ask them how their sibling is (by name). Ask them if their phone number is still how you have it (you will put the phone number in the letter).

-Paragraph 2: (3 Sentences) Describe you experience this year in school so far (your classes, your extracurricular events, etc...).

-Paragraph 3: (3 Sentences) Tell about your plans for the holidays.

-Paragraph 4: (3 Sentences) Mention how your family is doing.

While the document is open, go to Tools -> Letters and Mailing -> Mail Merge.

Select Document Type: -> Choose “Letter”

How do you want to set up your letters? -> Choose “Use the current document.”

Go through the rest of the steps of the Mail Merge Wizard.

After you have inserted all of the merge fields, click on “Preview your letters.” Use the Mail Merge toolbar to go back and forth from record to record to ensure you inserted the appropriate fields.

Select “Complete the merge.”

Click on “Edit individual letters...” --> Select “All” under Merge Records. This will create a new document called “Letters1.doc”

Select “Save As” --> Save the file to folder and name it:

HolidayLetterMerge.doc