How to Mail Merge in Word, Excel & Outlook | Dynamic Linking between Excel & Word

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@LassLaura]

Mail Merge has been my Mount Everest as an Executive Assistant. It's been years since I have had to use it for snail mail, but a new client needed a MM via e-mail this week for 700 contacts. Your tutorial 🤩is exactly what I needed, with directions that are very clear and easy to follow. Many thanks!

[@deebaxley7800]

I have been using MS mail merge for >20 years; thank goodness MS has developed it over time so that it is so much easier than it was at first. I'm now retired and use it for sending Christmas greetings to friends and family. Today's video was a great refresher, especially since l learned something new(!!) = that I can copy/paste an Excel table into a Word document and also use field codes for another project I am working on. Thank you Leila - I love your videos .

[@LeilaGharani]

That's great, Dee! Good thinking on the Christmas greetings :)

[@innermostbeing]

Without any hesitation, I would recommend those struggling to learn or understand the mail merge to refer this video. It was simple and easy to follow. The herculean task of sending individual email was simplified on viewing the video. An added advantage is, the emails are personalised to make the recipients special. From the bottom of my heart, I thank you for sharing your learning to us, Leila!

[@anisnabila7104]

truly yes. very recommended this video.

[@ozgulsahin3811]

H=] h+h+hhh=b hm] +hhh='b h b

[@timnyapming8114]

Can someone guide me too?.

[@innermostbeing]

@timnyapming8114 Please follow the step by step process shared in the video. Pause, play and apply it on your work.

[@investinginyourlife3186]

That moment when you said, I cheated here !!! Stop right there, you didn't cheat you used an efficient method ;-) That's all that we learn here . Efficiency across all your videos. Thank you Leila. I learn so much all the time.

[@JaneM.Blackboot]

exactly. she skipped over the importnt part that makes all this makes sense. that stinks!

[@tylesane2690]

Thanks!

[@LeilaGharani]

Thank you!

[@LS-zy7pk]

Amazing! You are a lifesaver....I'm referring specifically to minute 5.33 onward - how to format currency!! Just wonderful. Thank you!!!!

[@Scott1972011]

Thank you! Very easy instructions to follow and your voice is so soothing!! Great job!!

[@kgadeberg]

You just saved me numerous conversions to text in Excel to achieve the right formatting in Word. \# Who would have guessed that? Not me!

[@LeilaGharani]

Glad it was helpful, Klaus!

[@Jeff-v4p]

This was the best how to video I've ever seen, I have screwed up more mail merges than I can count until today!

[@LeilaGharani]

Glad it was helpful, Jeff!

[@hudsonalbert1360]

Thank you very much for the beautiful lesson, Leila. Your pronunciation can follow very easily because the way of your teaching is intended to learn your listeners... Thank you

[@GiteshBajaj]

You just gave me the answer to one of my questions I was searching for over 2 Years. A BIG BIG THANK YOU. I finally got a idea to link word to excel. I knew Mail Merge earlier, but still didn't recognized it. Now its a YES!

[@LeilaGharani]

Glad I could help!

[@ptichka1371]

Omg this is exactly what I needed! Leila, you are propelling my career, thank you so much

[@LeilaGharani]

I'm so glad!

[@randomguy-jo1vq]

@@LeilaGharani can you check my comment ? There is an imposter who has the same username and profile pic as you and they have comment under my comment.

[@LeilaGharani]

I already reported it to KZbin. Thanks for the heads up!

[@stevanusadiwena6975]

SAME HEREEEEEEEEEEE.. idk why this video come to my youtube recomendation.

[@nagusattenapalli7637]

MAM...I Love You....Your way of explanation, vocabulary and every small detail you are presenting. I Love your work. Thanks for such dedication.

[@LeilaGharani]

It's my pleasure.

[@nataliecaba4143]

This is the best video tutorial I have found. Thank you so much for this!

[@HBJSpiegel]

Your channel is amazing! I've learned so much from your really great videos. Thanks so much!

[@LeilaGharani]

Happy to hear that, Howard!

[@sudeerakelum3258]

Thanks a lot. This saves my day. I had to print 1500 envelopes to send greetings cards. This saves my day

[@LeilaGharani]

Happy to help!

[@evolvingcreativity]

Thank you, Thank You, Thank you! We have a database and needed to format it so it could be printed out as a nice layout as a PDF! You saved my team!

[@TylerStanczak]

Thank goodness for mail merge. Appreciate the tutorial Leila :)

[@LeilaGharani]

Very true :)

[@ArifulIslam-mb4gn]

@@LeilaGharani Please give me download link project file

[@Bosdaks]

2022 - I was struggling to make a letter across 100+ employees, and this is the answer. I love you.

[@LeilaGharani]

Happy to help!

[@JLvatron]

I hadn't Mail Merged in 20 years. Thank you for this great tutorial!

[@LeilaGharani]

Glad you enjoyed it!

[@aiting9874]

Thank you so much for the video. I like the way you keep the video short and easy to understand. It helps me a lot. Will definitely share with my friends and colleagues

[@andolenebusch9932]

Thank you so much for this video. It has helped me tons and now I know how mail merge works - YAY!!

[@martinkrajnc5140]

Simply - super. Thank you Leila.

[@tormodsolemslupphaug1043]

I've been using mail merge for a long time, but recently I've been moving over to SharePoint/Microsoft Lists and Power Automate (e.g. When a new SharePoint list item is created > populate Word Template > convert to pdf > send email with pdf attached). Or create other semi-automated flows which can be activated directly from the list. This really opens up a whole new world of automation possibilities. Mail merge is sooooo 2019 ☺️

[@LeilaGharani]

Haha yes, with Power Automate the sky is the limit 😁

[@NGT29]

Thank you Leila; you are a life saver!

[@ngoziebenezer8028]

You are awesome! I appreciate how thorough you are in your coaching.

[@LeilaGharani]

I appreciate that!

[@brockdidericksen8994]

Great vid! Also shoutout to Doug Robbins’ Merge Tools extension that makes Mail Merge even better.

[@sravanthivk2720]

Thankyou soo much leila. Explained with example and result.

[@LeilaGharani]

Glad you liked it.

[@xevimartinpera3293]

Super!! I knew the tool but always I had problems with the number formatting, now it's clear. Many thanks, Leila

[@Billoo172]

She is true MS office goddess ... So professional and full of knowledge 🌷🌹

[@user-ho7tg7kb9v]

I have become one of your ardent fan just by watching your first video!

[@HamidurRahman]

Hey Leila this was very helpful to all - Thanks , you are really intelligent

[@kakiraiyan]

Saw some tutorials on this, but yours is the best as always!

[@manojmalu7119]

Mail merge is too easy for me after watching you video. Thank you liela

[@LeilaGharani]

Then just wait for next week's tutorial 😉

[@srmchinni3]

Awesome tutorial. I am lucky to find this video the right time.

[@jonathancrawford7106]

Clear, concise instructions - perfect! Thank you!

[@Pedro_Is]

Another excellent and useful tutorial, thank you so much

[@Rezasameni]

Thanks so much Leila! you're a life saver

[@zarifamirzoyeva2500]

Thank you for this tutorial. You are amazing!

[@ucinh884]

Thank you very much. This tutorial video is very helpful for me, very detailed.

[@issamlotfi]

Awesome !!! 🤩🤩🤩 Thank you so much Leila 🙏 Can we convert Word docs to pdf before sending by Outlook ?

[@cadenmilo8652]

I guess it's pretty randomly asking but do anyone know of a good website to watch new movies online?

[@cdyard1]

Another task to add to my To Do list of tasks. Well done, Leila Gharani.

[@LeilaGharani]

Thanks, Claire!

[@puertadelaestrella]

Another great video. I've used Mail Merge before but it was a looooong time ago. This was a great refresher.

[@vinoalosius9533]

Thank you! I learned Mail Merge today. Appreciate..😊

[@Ded9822]

Great tutorial videos! Well produced, very well spoken and articulate; most importantly the content!!! Superb! Btw, I have to get the “Eat, Sleep, Query, Repeat” coffee mug

[@LeilaGharani]

Glad you like it. I love my coffee mugs 😊

[@larissafelin8204]

I wanted to learn this function to make a task in my job more efficient. Finally a good and understandable explanation. Thanks. I'm so happy to be your student. 👍😊

[@LeilaGharani]

Glad it was helpful, Larissa!

[@oregonsuzukiinstitute7576]

This was amazing and saved me SO much time- thank you!!!!

[@LeilaGharani]

Glad it helped!

[@dorkyturtle]

This was very helpful, thank you!

[@svenparris8726]

Your tutorials are fantastic Leila 👏. I'd love to learn how to create standardised organisation-wide email signatures which can be updated centrally...

[@N7eptune]

Thank you Leila. That was nice with a few extra things that are new for me.

[@Shantuski_]

Woow, how easy you make things look. Amazing, you are the best.

[@MrPremarya]

Thanks for valued information.🙏

[@Luciano_mp]

Very good Leila. Useful. Thanks!

[@Luciano_mp]

@Leila Gharani Hello Leila, I didn't understand your answer.

[@nickatnite91101]

You are a Goddess of excel. Thank you for sharing..

[@vincentkuiper8682]

I've been doing this for years but it is a hard task to teach someone how to do this, I will definitely use this video next time someone needs to learn how to use mail merge!

[@LeilaGharani]

Thank you 😊 Please do!

[@kpsrathore]

Though I have been using mailmerge for quite some time, I did find some value addition in your video about formatting the numbers. That is why I try to see every video of yours even if I am familiar with the topic. Appreciated. Keep up the good work.

[@LeilaGharani]

Excellent! Glad you found something new.

[@sarrabensoltane6529]

شكرا أختي ليلى ربي يجازيك كل خير

[@JonLuskin]

Super helpful. Thank you!

[@chrism9037]

That was fantastic, thanks Leila!

[@LeilaGharani]

Thanks, Chris! Next week we'll take it to the next level with Power Automate :)

[@mp87ch]

Fantastic and simple!!!

[@rukshanweerakoon2309]

This is very useful. Thank you and Happy New Year 2024.

[@javedalam1714]

Great and very good teaching method

[@lizzale]

Very precised and clear! Thank you!

[@vinvette04]

Thanks for this very useful tip!

[@wayneedmondson1065]

Hi Leila. Nice tutorial! Very instructive. Thanks for sharing :)) Thumbs up!!

[@LeilaGharani]

Thank you, Wayne! Cheers!

[@weswilliams7221]

Very Helpful! Thank you!

[@amayardaewii6961]

Thanks so much Leila. It’s really helpful for us.

[@matheus160ful]

Thank you form Brazil.

[@johnborg5419]

Thanks Leila. This is very helpful and time saving!! : ) : )

[@glynissmith1641]

Thank you. Very informative

[@notesoeasy]

I used to do this almost every day, many years ago, but for the life of me, I kept on missing something(?). Thank you Leila for simplifying things for me so clearly and quickly.

[@vishalpatil4102]

I first liked the video then watched it, such impact leila has on my excel learning, thank you as always!

[@LeilaGharani]

Great to hear!

[@farhadullah6899]

Amazing as usual.

[@moniquenb1182]

Glad I found this video! thanks!

[@mohammadashiq9996]

i like this simplicity little more knowledge what I missed thank you Leila.

[@LeilaGharani]

You’re welcome 😊

[@terabytetechnologies2201]

Excellent, well presented 👍

[@LeilaGharani]

Thank you! Cheers!

[@zawmyotun9451]

It's amazing. Thanks again and again.

[@lynnefranklin521]

You are fabulous! Thank you for making this so clear and understandable!

[@michaeloloishuro6915]

As usual, this is another very important area covered by Leila. Great and thanks a lot.

[@abdulbassethassan3677]

Great job, very important information. Thanks.

[@LeilaGharani]

Our pleasure!

[@oliverrowe7230]

Wow! Fantastic, thank you

[@IvanCortinas_ES]

Thank you for this tutorial Leila. Perhaps it could also be interesting to see if it is possible to attach a different pdf document to each customer.

[@LeilaGharani]

Coming up next week. Stay tuned :)

[@fairlymoon448]

Omg yes!! This pls! And if multiple attachments...

[@excelmastervba]

Again, great Video and very important topic 👍🏻

[@LeilaGharani]

Thank you!

[@kooto870]

Excellent. Thank you.

[@ItamarValdman]

AMAZING Videos, thank you!

[@jasonipfatsiong2062]

Hi Leila thanks lovely tool that can save stay of time. Trust you well and taking special care. Kind regards Jason

[@LeilaGharani]

Thank you! You too Jason!

[@octagon1915]

Thanks, Leila now I'm subscribed.

[@LeilaGharani]

That's great. Welcome!

[@ChennaiFlame]

Easy to understand 👍👌 keep posting 👍

[@Meysamrez]

Thank you so much Leila jan, it really helped 😊

[@osamasaid8476]

you are great teacher

[@LeilaGharani]

Thank you! 😃

[@ShaikAmirHussain]

Thanks for the video👍🏻

[@tinpotcooker]

It really useful, thank you so much

[@webseriesreviewtamil649]

You are a life saver

[@ivanmamchych5802]

Thank you for the lesson, Leila Is it possible: 1) to generate dynamic subject for emails, for example with Customer name? 2) to put some address or dynamic addresses to CC and to BCC fields? I lack of these two options and appreciate any recommendation from you

[@marypotter6497]

Do a youtube search for "Bulk send emails from Outlook with attachments"

[@ivanmamchych5802]

@@marypotter6497 Excellent advice.... So instead asking a blogger about some functionalities not mentioned in the video, it is better to make a search. Great. Your tip is universal one for any question: Just google it! Why didn't I guess about such a simple way by myself?

[@ennykraft]

@@ivanmamchych5802 What the person was trying to say is that there is an add-on that will let you do that. The video he mentioned is about how to install and use it. kzbin.info/www/bejne/r5vCpGaZmcuJers

[@ivanmamchych5802]

@@ennykraft I saw this video before. And I knew that custom add-ins can do the miracles, but that's another story. Sometimes an add-ins cannot be applied by various reasons. My intention was to succeed within standard MS Word functionality, described by Leila. I even expected to get a negative but honest answer. No reply was sent except a recommendation to make a search for some extra tools, like add-ins...

[@ennykraft]

​@@ivanmamchych5802 It isn't possible with the basic MS Word functionality. It's high time Microsoft gave Mail Merge an overhaul. There are so many features that would improve it from correctly importing number and date formatting from Excel, to more than two options for If...Then...Else (both without having to editing the fields) and the function you mentioned.

[@SyedMuzammilMahasanShahi]

Beautiful work. Thanks for the share.

[@yvanlesage4235]

THIS IS AN AWESOME VIDEO OMG

[@randomguy-jo1vq]

Awesome tutorial as usual, Leila. I have been watching your videos for a year or more but this is the first time I made a comment. Do you have an internal or external audit background ?

[@ranazaroonzaroon9615]

best toturial ever

[@lesleyverhaeven9459]

Hello Laila Thank you for the clear explanation. Can you also have a list of people appear underneath each other, depending on a specific date? Difficult to explain what I want... Thank you in advance!