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!
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!
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 .
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.
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 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.
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
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!
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. 👍😊
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.
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!
Your tutorials are fantastic Leila 👏. I'd love to learn how to create standardised organisation-wide email signatures which can be updated centrally...
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.
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
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 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?
@@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. ruclips.net/video/yj_s3cdfVDY/видео.html
@@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...
@@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.
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
I'm trying to do an email merge with multiple rows of the data going into one email per unique email address. I see the NEXTIF field code, but I've only seen it used to create a multiple page document. Is there a way you know to send emails instead of page breaks? Use Case, notify users of one or many items they need to resolve with the data in a CSV with a many to one relationship of the rows to email addresses. BTW, you are the very best Microsoft Teacher out there!!!
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
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!
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!
truly yes. very recommended this video.
H=] h+h+hhh=b hm] +hhh='b h b
Can someone guide me too?.
@timnyapming8114 Please follow the step by step process shared in the video. Pause, play and apply it on your work.
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 .
That's great, Dee! Good thinking on the Christmas greetings :)
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.
exactly. she skipped over the importnt part that makes all this makes sense. that stinks!
Thanks!
Thank you!
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 ☺️
Haha yes, with Power Automate the sky is the limit 😁
Omg this is exactly what I needed! Leila, you are propelling my career, thank you so much
I'm so glad!
@@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.
I already reported it to RUclips. Thanks for the heads up!
SAME HEREEEEEEEEEEE.. idk why this video come to my youtube recomendation.
Thank goodness for mail merge. Appreciate the tutorial Leila :)
Very true :)
@@LeilaGharani Please give me download link project file
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
Amazing! You are a lifesaver....I'm referring specifically to minute 5.33 onward - how to format currency!! Just wonderful. Thank you!!!!
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!
Glad I could help!
2022 - I was struggling to make a letter across 100+ employees, and this is the answer. I love you.
Happy to help!
MAM...I Love You....Your way of explanation, vocabulary and every small detail you are presenting. I Love your work.
Thanks for such dedication.
It's my pleasure.
This was the best how to video I've ever seen, I have screwed up more mail merges than I can count until today!
Glad it was helpful, Jeff!
You just saved me numerous conversions to text in Excel to achieve the right formatting in Word. \# Who would have guessed that? Not me!
Glad it was helpful, Klaus!
Thanks a lot. This saves my day. I had to print 1500 envelopes to send greetings cards. This saves my day
Happy to help!
Thank you! Very easy instructions to follow and your voice is so soothing!! Great job!!
Clear, concise instructions - perfect! Thank you!
This is the best video tutorial I have found. Thank you so much for this!
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. 👍😊
Glad it was helpful, Larissa!
She is true MS office goddess ... So professional and full of knowledge 🌷🌹
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.
I hadn't Mail Merged in 20 years. Thank you for this great tutorial!
Glad you enjoyed it!
Thank you Leila; you are a life saver!
Simply - super. Thank you Leila.
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!
Thank you 😊 Please do!
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!
You are awesome! I appreciate how thorough you are in your coaching.
I appreciate that!
Thanks for valued information.🙏
Your channel is amazing! I've learned so much from your really great videos. Thanks so much!
Happy to hear that, Howard!
Another task to add to my To Do list of tasks. Well done, Leila Gharani.
Thanks, Claire!
Thank you so much for this video. It has helped me tons and now I know how mail merge works - YAY!!
Your tutorials are fantastic Leila 👏. I'd love to learn how to create standardised organisation-wide email signatures which can be updated centrally...
Another great video. I've used Mail Merge before but it was a looooong time ago. This was a great refresher.
Thanks so much Leila! you're a life saver
Mail merge is too easy for me after watching you video.
Thank you liela
Then just wait for next week's tutorial 😉
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.
Excellent! Glad you found something new.
Thank you for this tutorial. You are amazing!
I have become one of your ardent fan just by watching your first video!
Awesome tutorial. I am lucky to find this video the right time.
Another excellent and useful tutorial, thank you so much
Great vid! Also shoutout to Doug Robbins’ Merge Tools extension that makes Mail Merge even better.
Super!! I knew the tool but always I had problems with the number formatting, now it's clear. Many thanks, Leila
Thankyou soo much leila. Explained with example and result.
Glad you liked it.
Saw some tutorials on this, but yours is the best as always!
This was amazing and saved me SO much time- thank you!!!!
Glad it helped!
Super helpful. Thank you!
You are a Goddess of excel. Thank you for sharing..
Again, great Video and very important topic 👍🏻
Thank you!
That was fantastic, thanks Leila!
Thanks, Chris! Next week we'll take it to the next level with Power Automate :)
Thank you! I learned Mail Merge today. Appreciate..😊
Very precised and clear! Thank you!
As usual, this is another very important area covered by Leila. Great and thanks a lot.
Hey Leila this was very helpful to all - Thanks , you are really intelligent
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
You are fabulous! Thank you for making this so clear and understandable!
Very good Leila. Useful. Thanks!
@Leila Gharani Hello Leila, I didn't understand your answer.
Thank you very much. This tutorial video is very helpful for me, very detailed.
AMAZING Videos, thank you!
Thank you form Brazil.
Awesome !!! 🤩🤩🤩 Thank you so much Leila 🙏
Can we convert Word docs to pdf before sending by Outlook ?
I guess it's pretty randomly asking but do anyone know of a good website to watch new movies online?
This was very helpful, thank you!
Thanks so much Leila. It’s really helpful for us.
Thank you Leila. That was nice with a few extra things that are new for me.
I first liked the video then watched it, such impact leila has on my excel learning, thank you as always!
Great to hear!
شكرا أختي ليلى ربي يجازيك كل خير
Thank you. Very informative
Very Helpful! Thank you!
It's amazing. Thanks again and again.
Glad I found this video! thanks!
Woow, how easy you make things look. Amazing, you are the best.
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
Do a youtube search for "Bulk send emails from Outlook with attachments"
@@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?
@@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. ruclips.net/video/yj_s3cdfVDY/видео.html
@@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...
@@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.
This is very useful. Thank you and Happy New Year 2024.
i like this simplicity little more knowledge what I missed thank you Leila.
You’re welcome 😊
Great and very good teaching method
Fantastic and simple!!!
Great job, very important information. Thanks.
Our pleasure!
Thanks Leila. This is very helpful and time saving!! : ) : )
Thanks for this very useful tip!
Wow! Fantastic, thank you
you are great teacher
Thank you! 😃
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
Glad you like it. I love my coffee mugs 😊
Excellent, well presented 👍
Thank you! Cheers!
Thanks, Leila now I'm subscribed.
That's great. Welcome!
Excellent. Thank you.
Amazing as usual.
Beautiful work. Thanks for the share.
Wow this the awesome way to mail merge..... Only possible due to you Leila Gharani
😊
What about saving individual PDFs for each record?
Print to pdf?
Email pdf
It really useful, thank you so much
Easy to understand 👍👌 keep posting 👍
best toturial ever
I'm trying to do an email merge with multiple rows of the data going into one email per unique email address. I see the NEXTIF field code, but I've only seen it used to create a multiple page document. Is there a way you know to send emails instead of page breaks? Use Case, notify users of one or many items they need to resolve with the data in a CSV with a many to one relationship of the rows to email addresses. BTW, you are the very best Microsoft Teacher out there!!!
Thank you so much Leila jan, it really helped 😊
Thanks for the video👍🏻
Hi Leila. Nice tutorial! Very instructive. Thanks for sharing :)) Thumbs up!!
Thank you, Wayne! Cheers!
I learnt something new today and thanks for this
Happy to help.
You are a life saver
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.
Coming up next week. Stay tuned :)
Omg yes!! This pls! And if multiple attachments...