• Quest Computer Skills

How to Mail Merge

From Microsoft office training Johannesburg:


Task A – Type the following in Excel

Name Amount Date

John 100 '10 July

Sally 1000 '20 July

Mary 50 '10 Aug

Alex 5000 '22 July


- Save as: your name table

- Close


Task B – Type the following in LETTER in Microsoft Word


DEAR

YOU WILL RECEIVE A BONUS OF R …….. ON ……..

THANK YOU

MANAGEMENT

Using Mail Merge

- Click on Mailings Tab

- Click on the down arrow under Start Mail Merge

- Click on letter

- Click on Select Recipients

- Click on Use an Existing List

- On the left side Click on Desktop

- On the right side look for file “your name table”

- Click on Open

- Click on OK


- Click after “DEAR” make a space.

- Click on Insert Merge Field

- Click on Name


- Click after the "R", make a space

- Click on Insert Merge Field

- Click on Amount


- Click after the "ON", make a space

- Click on Insert Merge Field

- Click on Date


- Click on Finish & Merge

- Edit Individual Documents

- Click on All

- Click on OK


Also see Excel Training Johannesburg

5 views0 comments

Recent Posts

See All

JOB TIPS >> How to reset your password on INTERNET JOB SITES: 1) Open the job site 2) Click on log in 3) Type in your e-mail address 4) Then it will allow you to type in your password 5) Click on for

ABOUT JOBS What is an aptitude test? A lot of companies ask candidates to write an aptitude test, when they are applying for a new position. The test lasts from 10 minutes to an hour. The company is t