Mail Merge is a great time-saver if you need
to create multiple documents that are the same, but unique in some way – like name tags
for an event, or envelopes printed with each person’s name and address. The document I have here is a letter offering
customers a discount on their next order. I want to personalize it by addressing each
copy of the letter to the customer, using information I have stored in a spreadsheet.
To begin, go to Mailings, then Start Mail Merge. The Step by Step Mail Merge Wizard
will walk you through the process one step at a time, using this window on the right. The type of document I’m working on is indeed
a letter, so I’m going to click Next. I also plan to stick with my current document instead
of using something else, like a template. Now I need an address list, so Word can create
a copy of the letter for each customer. To start from scratch, you can “Type a new list,”
then click Create to enter your recipients individually. Alternatively, if you do have
a list (like an Excel workbook in my case), choose “Use an existing list,” then Browse
to find it. Now click Open and select the worksheet that contains the list – I know
mine is in Sheet 1. In this window, you can check or uncheck all
or individual recipients to decide who’s included in the mailing. I would like to include everybody,
so I’m going to go ahead and click OK, and now it shows that workbook as my recipient
list. Now it’s time to write my letter. You can
add something unique for each recipient, including their address, a personal greeting, custom
postage (which requires special software), and more. I’d like to add an address block
first. Just place your cursor where you want it to go, then click the item. Here’s a preview
of what it’s going to look like, and a couple different formats to choose from for the recipient’s
name. Click OK, and a placeholder will appear in your document, where the address will go
later. The other thing I’d like to add is a greeting. Again, you have a preview here,
and the ability to change some of the formatting. Let’s move onto the next step: previewing
the finished product. I just want to make sure the information from my list appears
the way it should. You can take a look at each recipient’s copy by clicking the arrows
here. Everything looks great, so let’s complete the merge. If you click the Print command, Mail Merge
will ask which pages you want to print before sending you to the final step. I want to print
every document in my recipient list, so I’m going to keep All. Now all you have to is
adjust the settings if you need to, then click OK. Knowing how to use Mail Merge is a must for
creating multiple letters, labels, envelopes, and more. The possibilities – and the time
and energy you’ll save – are almost limitless.
A quick tutorial, with loads info! Thanks!!
The best on you tube straight to the point…..Thanks!!
Thanks.Time saver!
@never1dullmoment Thanks! Glad it helped! ^Jess
@mzgemini0006 Thanks! Glad it helped! ^Jess
@MoniW913 Thanks! Glad it helped! ^Jess
Great that was just what I was looking for – Short, Concise, Complete and above all FREE. 🙂
@1yskoob Thanks! Glad we could help! ^Jess
i love your voice …
thank you for the help ..
@gaurav091 Glad we could help! ^Jess
Awesome, thanks 😀
Simple, informative, and straight to the point! Thank you very much!
I love it.thanks.:-)
Great help 🙂 thanks for vid.
Wonderful! Glad we could help! ^Jess
If you look at our tutorial at our site (URL above in video description), you'll find much more information on this topic. ^Jess
🙂 thnxxx
GCF promise what I want when I want it, so….I wanna million bucks with which I can buy a small farm with a cottage and lovely little garden path, and I pretty much want it now. I can say please if you want…..
Very clear and easy video to learn how to create merged mails.
Thanks for the compliments! ^Jess
Perfect. Thank you!!
WOW thanks. Why did I waste a good chunk of my life writing individual letter omg the pain.
Glad we could help! No more wasting time!
Clear and concise. Exactly what I wanted to know
perfect.step by step learning.i just subscribed 🙂
I want to learn how to fly a TARDIS and where to get one. (Doctor who reference)
Super, A BIG help. You rock.
Glad we could help! ^Jess
Thank you!
thanks a ton! hopefully I can pass my MS office certification test now…
Wonderful! Glad we could help! ^Jess
(y)
Great job! Love the step by step. I put your video on one screen and worked on my other screen. Very helpful.
Simple, helpful and informative.
I've watched others and it wasn't as simple and straightforward as this
this is very useful for working in the office ^0^
Thanks a lot for this video uploaded person..
really helpful………
Thanks a bunch! Saved me lot of time.
Very well done.
wow. this helped so much.
Fantastic video 🙂 And what a background voice, how friendly !
Thanks a lot for uploading this video,
Excellent tutorial! Clear and concise, well produced.
Loving it! Thank you.
good
Was helpful to a point for what I need. Still a process but thank you for this.
this was perfect to refresh my memory. I haven't use this in a while and i needed a short and easy reminder. thank you.
I love it! I think my students will like it, too.
Very clear explanation, thanks
Very helpful in my internet course in college.. Thank you!
GREAT!!!! THANKS!!!
Wow. You made it look so simple – and in just a few minutes too. Thank you.
very good. I had no idea I could that!
Good explanation
Hi, when I am trying to do the greeting line, its not changing to what I selected…what am I doing wrong?
How do you save the merged document document with all the names and addresses you have merged – all in one document.
Really helpful
thank alot ….
thanks you helped me a lot with my work 🙂
cool very very cool for my practical exams
Thank you for captioing your video. It is diifuclt to find videos that are accessible to hard of hearing persons. I appreciate the extra effort!
Thanks really helped with my assessment
Wow! I didn't even know this existed until now! Thanks!
Such a great tutorial on using mail merge for Microsoft word 2010. The steps are easy to follow and hopefully this will help me ace my exam that I will be taking for my ecdl course during the week. Thanks again for posting the video folks 🙂
its help me alot
u all all left
Thank you so much for you help!! I was able to do my work in a breeze thanks to your video!!!!
This is exactly what I was looking for: an explicit, straight-forward process.
Thanks!
A superb, easy-to-follow tutorial, which has really helped a lot. Fantastic job! Thank you so much!
thank you for showing me this video its very helpful
Txs very useful
Thank you.
her voice was realy soothing and i could do it in a nice slow and comfy way! THank You
thank you alot simple..short and very helpful
Very good; it was really easy sample to follow and she explained very well.
we like the video thanks alot and may God bless you
Appreciate you well explained videos. You've have helped me a lot! Thank you
From Egypt I like all videos that you're doing guys keep connect this series it's awful رائع جدا يا اصدقائي
Thank you, very helpful! 🙂
I am beinng forced to watch this
Thank you learn free org you make me feel free about the mail merge . thank you and go ahead to power up people
Good explained… Loved it. Thanks
Thank you!
very helpful thank you
dfghj