Mail Merge, Making Letter is Easy and Simple
When we type a letter with many recipient, we usually use
mail merge to do it. If we create the recipient list from mail merge (word’s
application), we will type recipients in the application and the database is
saved in microsoft acces. Now I will introduce to you more simple and easy way
in mail merge. I use excel as a database.
Step by step mail merge with excel database as follows (for
Windows 2007 or above):
1.
Type your recipient list in excel, it’s called
data source
2.
Type your letter
3.
Go to mailing, select recipient, use existing list…
4.
Select the location your data source that you type in excel, and
than open
5.
Choose the sheet
when you type recipient list, name of
mine is mailing. Mark first row of data
6.
Back to your
letter, take the cursor to the name of recipient’s place, klick insert merge field, klick name. Do the same way for address and
city, take the cursor in it’s place and then insert merge field
7.
Yup your work is
finish, this is the result.
8.
Klick preview
result to view the result
9.
If you want to
print your work, choose finish and merge, print document,
In the end, it’s all about
mail merge using excel database, its more easy and faster to create and to edit. Happy
tray it!! You can adjust it based on your needs.
