Lesson 3.2 Steps Mail Merge Letter.pdf

Using Mail Merge on a Document

1. Create your own folder in Documents
Make an Excel File, list of Contacts - Contacts.xls

Field Name/ Label are as follows:

2. Mail Merge

Mail Merge is a useful tool that allows

-d a Word d Ely
start with an existing one or Create a
new one) and a recipient list, which
is typically an Excel workbook

3. » To use Mail Merge:

« Open an existing Word document, or create
a new one.

» From the Mailings tab, click the Start Mail
Merge command and select Step by Step Mail
Merge Wizard from the drop-down menu.

4. HOME

=

Envelopes Labels

Create
E

INSERT

rt Mail

z#

7] & [I à O D ©

DESIGN PAGE LAYOUT REFERENCES MAILINGS

gel

Li
Select i

erger Recipients ~ t Bl

Write & Insert Fields

L 2 3

5. a Mail Merge y *
* Choose the type of document

Select document type

you want to create.

Step 1 of 6

> Next: Starting document

6. Mail Merge RS

Step 2: Select starting document

Start from existing document

Use the current document

Start from the docu

and u:

7. Start Mail merge - Letters
Select Recipients - Use Existing List

1 ra D1 ory- OK

Insert Merge Field - Choose the Database
Fields/ Label that is needed in the letter
i.e. Salutation, LName

5. Preview Results, Click Preview Results,

Click Next Record to navigate the results
6. Finish and Merge

7. Finish and Merge, choose if you will
Edit Document, Print all Docs, or Send Email Messages

8. George Gilhooley - RECIPIENT/ COMPANY (Create at least 5 Contacts in Excel)
Times Union

87 Delaware Road

Hatfield, CA 08065

Dear Mr. Gilhooley,

lam writing to apply for the programmer position advertised in the Times Union. As
requested, | enclose a completed job application, my certification, my resume and
three references.

The role is very appealing to me, and | believe that my strong technical experience and
education make me a highly competitive candidate for this position. My key strengths
that would support my success in this position include:

9. With a BS degree in Computer Programming, | have a comprehensive
understanding of the full lifecycle for software development projects. |
also have experience in learning and applying new technologies as
appropriate. Please see my resume for additional information on my
experience.

| can be reached anytime via email at
[email protected] or by cell phone, 909-555-5555.

Thank you for your time and consideration. | look forward to speaking
with you about this employment opportunity.

Sincerely,

John Donaldson