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!
@@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.
Your tutorials are fantastic Leila 👏. I'd love to learn how to create standardised organisation-wide email signatures which can be updated centrally...
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!
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
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.
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. th-cam.com/video/yj_s3cdfVDY/w-d-xo.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.
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!
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
Thanks for this Video. I face always a problem that was not solved wirh this explanation. Maybe you have a solution for it as well. Imagine you have invoice details for a flexible number of items. So you can't predict how many colums you would need for the invoice. My idea would be to have a single row for each item, but I think this would not work with the logic of a serial letter, correct? Next idea is to have a maximum expected number of colums and then go on with your example. But in that case I assume only an if clause will help to decide if empty rows musr not be shown in the letter, correct? If so, can you explain how? Or maybe there are even simpler methods you can share with me. Thanks for any idea! By the way...greatexplanations in all if your videos. Short, on the point and close to what Excel Users need. Ulf
(Great tutorial!) I would also like to know how to print out the letter heading fields just once and then to itemise different rows that belong to the same customer's order (customer name and order number)?
This is so helpful Leila. Thanks a lot. Let me ask you a question. Is there a way I can choose for the emails to be sent later? Or even better, have them go to my drafts folder and then I can choose when to send each one of them?
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 ?
Wonderful video. If for example I am chasing invoices payment in which each invoice details is in one line in Excel, how would I go about in combining all the rows for that customer into one email showing the multiple invoices from the multiple rows? Thanks
Not directly. Unless you have the Adobe add-in for Word. Next week we actually I show a method to send PDF documents with mail merge directly from Excel, but these PDF documents were created before hand. I've made a note to look into making a video specific for the topic you requested.
Thank you for you tutorials. They are great. On the topic of mail merge, I am interested to know how to send invoices to customers, where the items are in rows rather than in columns. Where each customer may have one or more rows. A total should also be disayed. Thanks
Hey Leila, great video as always. I was hoping you could provide some details on how to amend the file name if you wanted to save each file individually based on values within the excel file too?
I've been experiencing problem with number formatting as the excel formatting doesn't automatically comes in ms-word.....thanks a lot for saving my time
Hii, My name is Yonas, one of your subscribers and in my company we regularly write experience letter for employees who works in more than one and sometime two positions and I wish you could make video on this mail merge or suggest me video so, i can easily take up lesson. Thanks
Hi Leila, yet another great video THANKS!. Quick question, is there a way to have the excel information fields to be vertically oriented rather than horizontally? Also, is there a way to produce an email attachment that is a PDF instead of a Word document? (Without Pdf'ing saving, writing an email and attaching the Pdf)
Hi Leila, I need to send the AR aging to many subsidiaries. So I would like to attacthe excel file in the email and the excel file is contain more that one tab. It that possible to do that? And also can I send the mail with cc / bcc?
Your videos are the best - thank you for sharing your Excel knowledge! Do you have a video like this one, where all services provided are in one column (instead of separated: service 1, service 2, etc)?
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.
Thank goodness for mail merge. Appreciate the tutorial Leila :)
Very true :)
@@LeilaGharani Please give me download link project file
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 TH-cam. Thanks for the heads up!
SAME HEREEEEEEEEEEE.. idk why this video come to my youtube recomendation.
Amazing! You are a lifesaver....I'm referring specifically to minute 5.33 onward - how to format currency!! Just wonderful. Thank you!!!!
Your tutorials are fantastic Leila 👏. I'd love to learn how to create standardised organisation-wide email signatures which can be updated centrally...
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!
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
Clear, concise instructions - perfect! Thank you!
I hadn't Mail Merged in 20 years. Thank you for this great tutorial!
Glad you enjoyed it!
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 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!
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!
Thank you! Very easy instructions to follow and your voice is so soothing!! Great job!!
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.
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.
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!!
Thanks for valued information.🙏
Thank you Leila; you are 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 😉
Thank you! I learned Mail Merge today. Appreciate..😊
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 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
Awesome tutorial. I am lucky to find this video the right time.
Thanks so much Leila! you're a life saver
2022 - I was struggling to make a letter across 100+ employees, and this is the answer. I love you.
Happy to help!
Saw some tutorials on this, but yours is the best as always!
Thanks a lot. This saves my day. I had to print 1500 envelopes to send greetings cards. This saves my day
Happy to help!
I have become one of your ardent fan just by watching your first video!
Hey Leila this was very helpful to all - Thanks , you are really intelligent
Thank you Leila. That was nice with a few extra things that are new for me.
It really useful, thank you so much
This was amazing and saved me SO much time- thank you!!!!
Glad it helped!
Thankyou soo much leila. Explained with example and result.
Glad you liked it.
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. th-cam.com/video/yj_s3cdfVDY/w-d-xo.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.
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!
i like this simplicity little more knowledge what I missed thank you Leila.
You’re welcome 😊
شكرا أختي ليلى ربي يجازيك كل خير
Thanks looking something like this for my project 😊😊😊😊
As usual, this is another very important area covered by Leila. Great and thanks a lot.
Woow, how easy you make things look. Amazing, you are the best.
This was very helpful, 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 😊
I first liked the video then watched it, such impact leila has on my excel learning, thank you as always!
Great to hear!
Nice and succint Thanks Leila.
This is very useful. Thank you and Happy New Year 2024.
AMAZING Videos, thank you!
Very Helpful! Thank you!
Thanks so much Leila. It’s really helpful for us.
Thank you form Brazil.
Super helpful. Thank you!
Thanks for this Video. I face always a problem that was not solved wirh this explanation. Maybe you have a solution for it as well.
Imagine you have invoice details for a flexible number of items. So you can't predict how many colums you would need for the invoice. My idea would be to have a single row for each item, but I think this would not work with the logic of a serial letter, correct? Next idea is to have a maximum expected number of colums and then go on with your example. But in that case I assume only an if clause will help to decide if empty rows musr not be shown in the letter, correct? If so, can you explain how? Or maybe there are even simpler methods you can share with me.
Thanks for any idea!
By the way...greatexplanations in all if your videos. Short, on the point and close to what Excel Users need.
Ulf
(Great tutorial!) I would also like to know how to print out the letter heading fields just once and then to itemise different rows that belong to the same customer's order (customer name and order number)?
Thanks a lot... I can do it now. 😊
Fantastic and simple!!!
Thanks Leila. This is very helpful and time saving!! : ) : )
Very helpful. Thanks a lot
This is so helpful Leila. Thanks a lot. Let me ask you a question. Is there a way I can choose for the emails to be sent later? Or even better, have them go to my drafts folder and then I can choose when to send each one of them?
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 ?
Wonderful video. If for example I am chasing invoices payment in which each invoice details is in one line in Excel, how would I go about in combining all the rows for that customer into one email showing the multiple invoices from the multiple rows? Thanks
Mam, Excellent did for all
Easy to understand 👍👌 keep posting 👍
Excellent. Thank you.
Wow! Fantastic, thank you
excellent content
Thank You Leila
Thank u so much!!!
Hello. Is it possible to send the attachment in PDF format instead? Thanks!
Not directly. Unless you have the Adobe add-in for Word. Next week we actually I show a method to send PDF documents with mail merge directly from Excel, but these PDF documents were created before hand. I've made a note to look into making a video specific for the topic you requested.
Thanks! Leila
Also pdf file name can be invoice number instead invoice template and email body with summaries of invoice
@@LeilaGharani Can't wait to see that video. Thank you in advance, Leila. You are great! 😃👍
Nice
Thank you so much! I am waiting to see that video as well 😊 🙏
This is so helpful and all of your tutorials for me. I have a question, how to mail merge from pdf file to outlook?
Nice Dr. Who mug😉
Thanks!
Thank you for you tutorials. They are great. On the topic of mail merge, I am interested to know how to send invoices to customers, where the items are in rows rather than in columns. Where each customer may have one or more rows. A total should also be disayed. Thanks
I learnt something new today and thanks for this
Happy to help.
Thanks, Leila now I'm subscribed.
That's great. Welcome!
Excellent, well presented 👍
Thank you! Cheers!
Hey Leila, great video as always. I was hoping you could provide some details on how to amend the file name if you wanted to save each file individually based on values within the excel file too?
I am still looking for a way to save each document separately without downloading a mail merge splitter. Does anyone know?
Awesome!!
Beautiful work. Thanks for the share.
Hi Leila thanks lovely tool that can save stay of time. Trust you well and taking special care. Kind regards Jason
Thank you! You too Jason!
Thanks for the video👍🏻
So fantastic tutorial.!!!! But we can block the content of the word?? O sending in PDF?
I've been experiencing problem with number formatting as the excel formatting doesn't automatically comes in ms-word.....thanks a lot for saving my time
THIS IS AN AWESOME VIDEO OMG
This is wonderful, could help to save a lot of time, thank you.
I wonder, would it be possible to send the attachment as PDF in mail merge? TIA
What about saving individual PDFs for each record?
Print to pdf?
Email pdf
Could you please show to make mail merge of picture from excel to word?
You are a life saver
Hii, My name is Yonas, one of your subscribers and in my company we regularly write experience letter for employees who works in more than one and sometime two positions and I wish you could make video on this mail merge or suggest me video so, i can easily take up lesson. Thanks
Hi Leila, yet another great video THANKS!.
Quick question, is there a way to have the excel information fields to be vertically oriented rather than horizontally?
Also, is there a way to produce an email attachment that is a PDF instead of a Word document? (Without Pdf'ing saving, writing an email and attaching the Pdf)
I also have the same question! Looking forward to the answer 😊
Thanks Ma'am
Hello Leila, thanks so much for the helpful video, just a quick question, is it possible to attach another files/tables with mail merge?
best toturial ever
Thank you
Salam sister, thank you this was exactly what I needed. Keep up the good work.
Hi Leila, I need to send the AR aging to many subsidiaries. So I would like to attacthe excel file in the email and the excel file is contain more that one tab. It that possible to do that?
And also can I send the mail with cc / bcc?
Your videos are the best - thank you for sharing your Excel knowledge! Do you have a video like this one, where all services provided are in one column (instead of separated: service 1, service 2, etc)?
Great piece of information! Just one question, how to create and save individual documents instead of one multi page?
Please give an example with mail merge using graphs as well. Thank you Leila