Learn to use Mail Merge in Word 2010/2007

In this video learn how-to create Mail Merge in Microsoft Office 2010/2007. Learn to create Letter, Envelopes, Email Messages. Also learn how you can use Microsoft Outlook contacts in your Mail Merge letter/envelopes/email messages.

[@spot5]

Just wanted to say a massive thanks for everything you do. It's impossible to find good quality information on MS Office out there without having to pay through the nose for it. What you provide on this channel, FOR FREE, is worth its weight in gold

[@roxytherottenweiler2103]

I agree. Im writing an exam tomorrow and this helps immensely. Thank u and well done

[@bastardassfuckgoblin]

This basically saved my life! I was having trouble in my Intro Tech class (especially with mail merge), but this one video was a total help. I'm sincerely grateful for these tutorials!

[@SonofBenton]

Amir, I have watched several KZbin videos explaining how to do Mail Merge; none, repeat none, of them have done it as well as you have. I at last understand how it is done. Thanks to you!

[@hrnaveenk]

I have watched other videos on Mail Merge but they didn't cover all the options of Mail Merge. Your video is complete as it contains explanation of using Mail Merge for printing, letter and envelope and sending emails. Further you are very specific and detailed. Thank you.

[@AmirParmar]

Very glad that this video was useful in your learning. I was trying to show mail merge in the simplest of instructions so anyone with little/no knowledge of Microsoft Word can learn it. Comment left by you and others will give others the confidence to give this video a try. Thanks.

[@sandrafederkiel5670]

I just couldnt get my head round mail merge on a ECDL course. I love this guys explanation cos he covers everything from the start to the end, of the procedure. Creating your mailing list through to creating replica fields in your main letter. I found his explanation much easier and to follow and more logical..thankyou, tomorrow I can continue my course feeling much more confident

[@VickiPPS]

Thank you. I personally am familiar with mail merge but was looking for a good instructional video to pass on to board members who are not as familiar. This looks like it will do the trick.

[@patriciabyrne2578]

Thanx so much Amir for all your hard work, Your Access and Mail Merge lessons are excellent God Bless you for your kindness

[@janeihara6137]

Thank you for the clear explanation, you're a very good instructor!

[@karencressman9739]

Thank so much Amir! This helped me prepare for a job interview!!! Blessings to you for this gift.

[@manjulanair8059]

Hi Amir, You are a good teacher! Thanks for all the informative videos.

[@abdullahzubair8338]

To whoever is reading and watching this video, this is the go-to video for computer and ICT pratical exams.

[@ARTolbert]

Thank you very much for this video! It answered several questions that I had that other videos did not address. You make it very easy to get started using Mail Merge. Thanks again!

[@koshishshrestha9199]

One of the best tutorial in youtube. Helped me alot with my test. Thanks alot. Subscribed😊😊

[@sushamap8568]

Excellent job, Amir. Helped a lot to learn mail merging for the first time

[@sweetolyve]

I just wanted to post a thank you on here for this very well made video. It has helped me tremendously. Thank you very much.

[@AmirParmar]

Hi, thanks for your comment and good wishes. You can Right Click on the file and choose OPEN WITH and choose EXCEL. The file should open in Excel. And another work around would be to create the Source Data in an EXCEL file and in the step for SELECT RECIPIENTS, Browse to the excel file. Hope this helps. Amir

[@MYSTIQUE2002]

Thank you very much Amir sir! This has been very helpful for my exam tomorrow! Very clear and easy to understand!

[@husseinasrasalah7348]

You are the best teacher in the world

[@zaharazulkifli40]

Dear Sir, Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu *_~ I have my exam today and this vedio helped me alotttttttt . Thank you sooo much.

[@AmirParmar]

Zahara Zulkifli All the best.

[@alijancharles8823]

Thanks alot.. was very helpful

[@valerievillar89]

Great video! Thanks so much, I was so confused about creating a mail merge :)

[@shumaradams4448]

Thank you very much Amir Pamar you just hepled me pass my exam

[@kevins.3615]

Fantastic video. Absolutely brilliant. Thank you so much. 10/10 very well explained, the whole video from start to finish!

[@danielcoulthard9627]

If you got stuck around 15:00 / 16:00, go to recently loaded documents in the list of Word's Home button (top left), find the access file and just load it up in access. I couldn't find the table because I'm a fud and go too quick. xD Good video though, want to be able to breeze through an upcoming ECDL course and you help a lot Amir. So cheers brah.

[@AmirParmar]

+Daniel Coulthard From the Generic letter, you can also open the Data Source, this is also useful for people who don't have Access installed. From the Mailings Tab look for "Edit Recipient List" and in the windows that opens on the Bottom/Left you will see the name of your data source, double click it. all the best.

[@manaarkhandoker609]

Thank you sooooooo much This helped me a lot for my school assignment

[@AmirParmar]

Hi Carol, if I understand your question correctly. You want to add certain images on letters based on the person. so if John is a guest, his letter will have Guest image.The way I think this will be possible will be to create 2-3 different Mail Merge letters; one for each category, using the same Data Source. In the Data Source add a new field called Category and type Member, guest etc for each record.Now Filter the recipients based on category.In the 5th step of Wizard use "Edit Recipient List"

[@rahulamin1170]

many many thanks

[@martinanthony8447]

Thank you Amir for a great video!

[@ericsparks2349]

Thank you very thorough!

[@sathish1118]

thank you very much sir it helped me to learn very clearly about a mail merge for my practicals

[@kathylewis9411]

Very helpful - you are an excellent instructor. I just subscribed - thank you for taking the time to put this together.

[@aastha1411]

it is very helpful information you way of taking is very polite...thanks

[@queenjoy67]

Amir, you are the best!!! Thanks for posting this.

[@hollyh1969]

Thank you for putting this up, I have a test in a month in Word.

[@AmirParmar]

hollyh1969 All the best. I also have 2 videos for exam prep, here is the first link Microsoft Word 2007/2010/2013 Exam Q & A pt 1

[@hollyh1969]

Thank you

[@onlyoldnavy]

Many thanks for your time with these videos!

[@ahmedmagdy-el4wf]

Thank you alot amir wish to see you the best in your field

[@leticiaramirez7668]

thank you, you are a great teacher!!!!!

[@rasanjayamadusanka8465]

Clear explanation & very useful.. Thank u so much..

[@lungilekhumalo8515]

!!Very helpful for my exams!!

[@sudhanshurajakkumar]

#this video is very golorsious. U have been taught. #Excellent 😇😇😇

[@AmirParmar]

Hi, I tested it and send it to my Hotmail & Yahoo account. They both had the pictures in place, Yahoo had the attachments also and for some reason duplicated the image. Here are things to try: 1. When you insert the Image, set the "Text Wrap" to "Through" 2. In the last step when you choose "Electronic Mail" choose "HTML" as sending option (not attachment or plain text). Hope this helps, let me know if it works. I am using Office 2010. Also make sure you have updated the Microsoft software.

[@MrThatkidthere]

You do the most I wanted to know how to do a basic step by step mail merger an I just ended up taking a class on msword to much excess

[@riadhosein7362]

Thanks Amir! You are a lifesaver!

[@debbiecarmel9950]

Thank you for producing this video, Amir. It was very helpful!

[@MoustafaAntar]

Thanks a lot for your simple sufficient explanation.

[@Ms_T_Perfectly_Imperfect]

Very helpful, thank you.

[@AmirParmar]

Thanks for the comment, I have learnt from a lot of people and the Internet. This is my way of saying Thank you to all my teachers. Share the knowledge with others and the debt shall be paid :) All the best.

[@Divya-of4nq]

Amir Thanks a lot. Really itz very useful 4 me n i understood very clearly. i need it very much and i am satisfied more than enough. Till now I had a different different explainations from different tutors. Now I worked on it and I am very happy. Once again thanks

[@AmirParmar]

Very glad that tutorial was useful. I also created new tutorial for Word 2013 in which I have added more details and made separate videos for Mail Merge Email, Letter and envelope. All the best.

[@Divya-of4nq]

Thankyou Amir certainlu I ll watch the oder videos too

[@mmaullon]

Great Job Amir, really useful !

[@shankychopra6563]

Thank a lot very nice presetation

[@amanpathak7873]

Sir, It is really helpful. Tomorrow is my exam and reading from the textbook is such a pain. Thanks! Keep up the good work. :)

[@AmirParmar]

All the best.

[@amanpathak7873]

Amir Parmar Sir It went really good. :) Thanks :)

[@jestervanchhawng]

superb lecture, easy to learn. thank you

[@juliosanchez-banos8563]

Thank you very much Amir. Your instructions are very well clearly done, step by step! If you don;t mind (or anyone) can you tell me how to find your video showing how to install Outlook?.. Thanks again!

[@AmirParmar]

Hi Julio, I don't have the video on installing Outlook, but do have a video on how to set it up with Email, see the Outlook playlist kzbin.infoplaylists

[@ChelseaRae011]

Thank you so much! this helped me a lot.

[@snehaguhathakurta5625]

Thank you! That was very informative.

[@prahee4suman]

THANK YOU SO MUCH. GREAT WORK SIR.

[@bbalboa6219]

Thank you so so much!!!!!!!!!

[@AmirParmar]

How about Inserting a Hyperlink to the cell of the image. Because if you add the Picture or even as an Object, it hovers over the cell. The hyperlink will keep the link to the file and you can open by clicking it. Let me know.

[@jeanniemilone8182]

Thank you so much. You Rock!!!!

[@ronochabrahma3940]

thank u sir😊

[@durgaprasadp2551]

Too good detailed explanation... very useful

[@AmirParmar]

Also have a Hindi channel if anyone needs instructions in Hindi kzbin.infoplaylists

[@lisat7850]

Many thanks for your video Amir ! Very clear and concise. I have a question - how would you go about doing mail merge to send and email with an attachment and copying other people in the email as well? From what i have read elsewhere we cant use mail merge to attach docs or copy people, we would need to use VBA. Was wondering about your thoughts on it. Thanks in advance.

[@jjjkeel1260]

It was helpful! Thanks so much.

[@kanofraser2349]

Thanks mate, good work

[@DanishKhan-qq3cn]

Great job ! keep up the good work

[@akshaysing9845]

this will help me for my praticle

[@sadiasarder7416]

Thank you very much! Subscribed too :)

[@themaverick3552]

Thanks Amir

[@rabnawazabbasi798]

very informative & very helpful!!! Please make some video about hyperlinks too. Thanks Mr. Amir

[@AmirParmar]

Hyperlinks? There is video in which I have covered Bookmarks and Hyperlinks, is there anything else you need to know?

[@yangzomfilms]

Thank you Sir, it helped me a lot.

[@adepekun858]

its nice and great job love i Amir you are sensible man

[@chill95125]

Thank you, Amir for the quick response. I have a data source in Excel with the fields "First name", "Last Name", "Member", "Friend", "Star". I want to have a different symbol on the name tags indicating the person's affiliation. I'm confused about how to embed or link the image for the cell of each individual. This should be easy but it's not.

[@Lwils-vv5oe]

thanks this is the hardest one fore me.

[@fatemahaboubakr8376]

Thanks a lot for that video

[@royalwords2964]

Really hlpful

[@TheNengg]

this is very helpful thanks a lot the other guy that says this is not helpful is a thick skull

[@alicianotkeys]

Loved!! So helpful Amir. Can you help me with a question. How would a add he/she and him/her in a mail merge letter data. It's a personalized thank you large letter to mail and I need to reference the person as he or she and him and her.. Would I add or rename or customize a column in the data sourced table??

[@AmirParmar]

Hi Alicia, sure you can add 2 Columns one to enter He or She and another to add Him or Her.

[@Munkaa]

thanks for the help :)

[@mariab4905]

thank you so much. very helpful

[@MalaySanasana]

Thanking you Sir

[@younithin]

Thank you Amir Parmar.

[@kikijean4768]

Hi Amir, I did everything you said it was going perfectly up until the point of going to my data sources to edit or use that contact for mailing the envelopes, there was nothing in the that file. I know that the computer I have does not have access. Can you please advise what I can do so that I can continue through your tutorial and practice using the information that should have saved to proceed with envelopes etc. Thank you soooo much. Great Video! Just stuck at the portion. I am preparing for an exam....

[@AmirParmar]

Kiki jean Hi, did you save the Data Source when working on the Mail Merge Letter? If you open the Original Mail Merge Letter and go to the Mailings tab, you will see the option "edit recipient list" click it and you will see the name of your data source in the box, double click it. You can add or remove names from here. If the file does not have any names, than you forgot to click on the Save button when exiting Word. In terms of practice if you can use the "existing data source" in the Envelope step, you have the done the right step by choosing the right File, but for some reason the Names are not there. you can fill them up by going back to your original file as mentioned above. Hope this helps.

[@kikijean4768]

Amir Parmar Hi Amir, I double-checked and I did see it saved, as mail merge recipients. It could be an issue with the computer I am using, it is a loaner. I have a mac which uses a newer version of word, which an issue for me because the test will be on an older version of word, using a PC. I hope to be ble to try on another computer. Thanks to your videos I know that I am in much better shape than I would have been otherwise, as I’ve had to reacquaint myself with this version in a very short time span. Your videos are a god send. So, again, many thanks.

[@AmirParmar]

Kiki jean All the best with your test. I also have exam prep tutorials here is the link to the playlist kzbin.info/aero/PLcmYWY91gQNeKyMX7aeS8d3tCayO9SuoK

[@kikijean4768]

Amir Parmar I appreciate it. I will definitely be checking out.

[@JainMms]

loved it

[@justice4taiwan]

Thanks very much. Two problems in the email merge: 1. The position of inserted pictures sometime were relocated. 2. The inserted pictures were showed up as attachment. Any suggestion to resolve these two problems?

[@rebeccakeane2584]

hi amir, i just wanted to ask, when you are opening the access file containing your recipients list was that automatically created when you wrote out the list in word or did you create that separately

[@AmirParmar]

Rebecca Hoare - Keane It was created automatically.

[@philipwallace90]

Thanks

[@kevinkavin5094]

Amir, Great job. Thanks: will you ever upload videos about MS Excel or Tally ERP 9. in Hindi ? I will be looking for them.

[@AmirParmar]

kevin kavin Thanks Kevin, I have never come across Tally so not sure about it. I do have Excel, Word, PowerPoint and Access tutorial in Hindi. kzbin.infoplaylists

[@AmirParmar]

It should have opened in excel and your suggestion to open the Source Data through "Edit Existing List" is possible. I have sent you a personal message, maybe I can convert the file for you to excel.

[@chill95125]

Great instructions. Could you tell me how to include images in a merge? I want to make name tags with different images indicating different affiliations, such as "member," "guest," "dignitary" etc. How would I accomplish this? Thanks, Carol

[@mincasingh6173]

great man 👍

[@shahidmahmood7046]

good style

[@AmirParmar]

I have added a video showing how-to add images to Mail Merge. Hope this solves the problem.

[@monicahwanjiru6455]

awesome

[@edkay3601]

Great video Amir, I have a Question. When I click on address block I never see the square and so my recipients are scattered about the envelope. It says click a location in the document and I do but I never see a box like in your excellent video. I can't figure out what I am doing wrong. Can you help? thanks

[@AmirParmar]

ed kay Hi Ed, when you see the Envelope try to click in the middle of the envelope and try clicking further down; till you see the box. Let me know if you still have a problem.

[@edkay3601]

Amir Parmar You're right! I was clicking too high on the envelope. Thanks a lot.

[@sabrearzul5082]

Quick question amir; how do i send the emails automatically? at the moment they are saved into drafts. Once I click 'mail merge to outlook' I want them to be sent out immediately

[@AmirParmar]

When you hit Send/Receive it should start to send the messages out. Are the messages sitting in Drafts or Outbox?

[@jennybendtsen4778]

Does anyone know if it's possible to use mail merge AND the 'direct replies to' feature? I only want replies for the specific email I am sending out via mail merge to have the 'direct replies to' on. I do not wish have all of my regular mail sent to another email address.

[@chill95125]

I think you misunderstood what I want to do. I want to print out name tags with a symbol (image) on them and I want to accomplish this with mail merge. I'm willing to do 3 separate mail merges after filtering my participants by their affiliations but it would seem that if the symbols were specified for each individual, that it would be possible to do one run. This shouldn't be this hard.

[@AmirParmar]

Sorry that this video was not helpful to you. Hope you can find someone else's instructions that you will find useful. My goal was to make Mail Merge easy to understand for people who have never used it. It would be helpful to know why this Tutorial did not fulfill its function.

[@othnice]

So, if I use mailmerge for emailing 100 people, will the message they receive appear as a mass email with multiple recipients in the "sent to:" field?