If you run a company, school, or any other business and often create and send a letter to the address list you have in the big amount, you can do it with the help of mail merge.
Mail merge is the system of mixing data list (from excel file) to the costume letter (in doc file). The mixing result is one file (doc), in which each letter containing individual information from the data list.
Every student/client then will receive a personal letter with the name, address, or any other data that you want to insert in the letter
So they will receive a personal, friendly and professional letter, not a mass mailing letter which would normally be discarded by the recipient. Mail merge can apply not only to individual letter but to any other form like Student Certificate, Addressed Envelopes, Name Tags for Events, etc
Mail Merge makes your Corresponding need look professional and feel effortless for you.
For anyone who does not master the mail merge, we provide the mail merge service for you.
Just email me
The Main Letter (doc), like this(example)
the data list (excel file)
I’ll then merge the main letter with the data list file and email the result file to you.
You just open it, and click File - Print. You may print it directly (all data), or choose which one.
Every Student’s or client’s letter in the result file will be in the separate page,
for example, if your excel data consist of 100 data lists, then the file doc is in the 100 pages, 1 page for every client.
Example Result File (doc)
Page 1 of letter ( consist of data list no 1)
Page 2 of letter ( consist of data list no 2)
For envelope Mail merge
Email me the Format envelope (doc)
And Data list (excel)
And the Result file is like this:
The result file that I send to you is free of error since I check the print out preview manually one by one (all the 100 pages letter or envelope) to make sure that no error in the print out process
If you are interested, you may test it first. Email me to victoria_mailservice@yahoo.com the main letter format (doc) and the data list (excel). I will do the merge process and email you the example result.
If you find that the result is ok, you can make the payment
Another Sample Mail Merge
Recommendation Letter for Student, see here
Announcement College Letter , see here
This article is not complete, I will finish it soon