HOW TO USE MAIL MERGE | cocoline
cocoline
MAIL MERGE
How do we use Mail Merge?
When you are performing Mail
Merge, you will need a Word document(letter) and Excel workbook (receipient
list).
Steps to start Mail Merge :
1. Open Microsoft Word on your windows, make new letter or use existing letter . example:
123 Elm Ave.
Treesville, ON M1N 2P3
November 7, 2016
Treesville, ON M1N 2P3
November 7, 2016
456 Maple Lane
Forest, ON 7W8 9Y0
Forest, ON 7W8 9Y0
Dear Mr. Leaf:
Let me begin by thanking you
for your past contributions to our Little League baseball team. Your
sponsorship aided in the purchase of ten full uniforms and several pieces of
baseball equipment for last year's season.
Next month, our company is
planning an employee appreciation pancake breakfast honoring retired employees
for their past years of service and present employees for their loyalty and
dedication in spite of the current difficult economic conditions.
We would like to place an
order with your company for 25 pounds of pancake mix and five gallons of maple
syrup. We hope you will be able to provide these products in the bulk quantities
we require.
As you are a committed
corporate sponsor and long-time associate, we hope that you will be able to
join us for breakfast on December 12, 2016.
Respectfully yours,
Derek Jeter
2. Open
Microsoft Excel , list the recipient you wanted to invite. For example :
If you wanted to make border
on it , it will be the same as if there is no border .
3. Save
the recipient list .Locate it in your document.
4. Open
your letter in Microsoft Word , and click MAILINGS.
5. Then,
click SELECT RECIPIENTS and then click USE EXISTING LIST.
6. After click use
existing list , find the list of recipients that you want to invite
8. After
that click INSERT MERGE FIELD on the recipient name on your letter and click
PREVIEW RESULT.
9. At last, you can
click the next and previous button for the preview result.
Comments
Post a Comment