Good lord this video (and it's companion merge to pdf) have saved me literally thousands from having to request an enhancement request from our SAS Billing System developer. Well done, simply explained, robust and extremely powerful.
Your mail merge to PDF saves me probably 20 hours of grunt work a month. For that alone, I can't thank you enough. I am looking forward to implementing this because I think it will save me an additional 5 or so more hours. You're an outstanding teacher. Clear, well put together. Thanks yet again!😊
Wow! I found a buried treasure! Thanks so much for putting your macros out there. They both work amazingly, and cut down on the HOURS of minutia I have to take care of. Thank you Thank you Thank you.
Again, Thanks for this :) used the mailmerge PDF along with this email with attachments - you have saved myself and team days of copying/pasting etc - looking forward to any more time saving videos/tips
Thank you for taking the time to make such a great program to complete what MS had left off. This program works great, and I did not have to make any changes to the code (not that I could anyway). Everything worked straight out of the "box". Great Job!!!
Thank you Thomas - the code is just a taster of what can be done, so please get in touch if you have any other tasks which could be sped up in a similar way.
Thank you so much for making this tutorial, and the one before which generates PDF’s. As you mentioned, this is incredibly powerful and I really appreciate your efforts. I especially liked how you split the video into two parts, the first being getting the macro into word and setting up your data so you’re all good to go, and the second being a deep dive into how the macro works. This way, it caters to your viewers needs very well. I simply pasted the macro (and added the references) and made sure my data was set up exactly like how you instructed, and the drafts generated perfectly on the first run. Thank you! I hope you continue to make more tutorials like these in the future, you deserve a huge audience.
This is an outstanding contribution -- it has saved me hours. The only strange thing I found was that if the file I wanted to attach was in the same folder, I would get the message "File Not Found". If I put the same file in a higher folder, the program found it and added it perfectly. Again, I am really impressed with the job you did developing this and explaining the VBA code.
I've came across this video (and the previous one on how to create the PDFs) last week, I cannot thank you enough. You have literally saved me dozens of hours a work a month. Well explained and I know little about Excel and I followed it quite easily. Fantasic couple of videos, thank you!
This is extremely helpful. Thank you so much. We needed to send an attachment to a mail merge we were doing and I followed your detailed instructions. No issues whatsoever. This will save us lots of time going forward!
I usually don't comment on videos much..... But damn I must say you made so many peoples job easier with this.... Thank you for this informative video.
Oh my goodness! This was an incredible video and a great resource. I followed all the instructions and it worked perfectly for me. (I didn't need more than ½ of the features and it still worked great!). This will be a big time saver for me over time. Much appreciated!
9 місяців тому
"let's take a deep breath and send the emails"... I know what you mean! Great video!
@@sukhmanikaur3332 ensure your spelling is correct for all titles. In the beginning I couldn't get my second attachment into the e-mail, turns out I had a typo "attachement", with an extra " e". As soon as I corrected that, the 2nd attachment was added.
Thank you very much for this solution. It worked perfectly! I have watched a lot of videos trying to accomplish this and none worked. Imnoss 100% fantastic.
This is amazing. Thank you so much. I've been using your macros to create personalised PDF documents and mail merge with attachments, which helps me save tons of time.
This along with it's companion (mergetoPDF) is by the far the best tool/tutorial that is available on youtube and I've seen hundreds. A work of art and beautifully done. Along with filters in 'edit recipients' the possibilities are endless. My life is so much easier now. Thank you @imnoss
Brilliant video! Thank you, I am now able to send our regular Newsletter, via email as an attachment, to our members. Quick and simple, no GDPR issues either.
I'm facing an error please help me out..When I run the micro its shows an error- (User-defined type not defined-and highlights the 1st (Sub EnhancedMailMergeToEmail) and Dim outlookApp As Outlook. Application.
@@Imnoss I've got it working and it's amazing! Thanks so much. I use this to schedule and send out emails about appointments and with custom corresponding attachments in bulk. My only snag is that when I try to send the emails from the drafts folder in outlook online instead of the desktop app, it doesn't like the format of the email addresses. If I delete them and retype the same address it works, and if I send it from outlook desktop program it works. The reason I want to use outlook online is because of their free delay email feature, which doesn't require the computer to be on to send it at the delayed time. Any suggestions for things to try with the email address format? I've tried semi-colon afterwards, comma, or nothing, and hyperlinked or non-hyperlinked..? Otherwise this is still an amazing time saver thank you!
Thank you so much for making this video, I really wanted the dynamic subject line and I wasn't able to figure out how to set that up. Your video instructions worked like a charm and looking forward to using this technique in the future. The whole process and code walkthrough was clearly explained. Thanks again!
Thanks, this worked beautifully. One point though - you should mention that the excel file being used for the PDFs is the same one that was used to do the mail merge in word. It may not be obvious to some people (like me..lol)
Works wonderful. Thank you very much. Suggestions: 1. Sometimes one needs to send messages with the same Subject and the same Attachments (not differenrt ones). Then it seems superfluous to add them, in the excell for each row, and perhaps ot can be entered only once by modifying the Macro. 2. I will try to run same mailmerge from Access table, If successful will report
Wow! Just Wow. Thank you so much @Imnoss!! This is excellent instruction and extraordinarily useful. I came from your other video and got the split docs and the PDFs thanks to your Mac code. There were a few hitches but I got it to work thanks to helpful responses you gave other commenters. (FYI, it would not save to a Google drive but would to desktop; it also choked where there were duplicate last names, but that was only a few.) I hoped you'd have Mac code for this Emailing step but see that's not done yet so I'll subscribe. I wish I could give you my old Mac to play around on! Or hire you :-) Alas, I'm in the States. If you ever come to the U.S., visit Chicago and I'll buy you lunch, or a beer in gratitude. You're a great teacher!
Hi, Thanks a ton for this tutorial and it worked like a charm. My requirement is to email customized birthday cards to staffs. I want the picture to be inserted in the mail body rather than add as an attachment. Also the email should go on the birthday dates at a specified time. Will you be able to help me ?
This code is a tremendous way to improving efficiency! Thank you for sharing. We are in the process of upgrading our machines. Does it require any modifications to be compatible with Windows 11?
Thanks for the word mail merge to separate pdfs… it was easy to follow. With this one, I’m stuck at the identify the mail merge of the active document. Not sure what I am doing wrong..
Hi, have you set up the mail merge for the document? (i.e. click "Start MailMerge" in the Mailings tab). If you have then is that the document at the front when you run the macro?
The main reason I generally use (and teach people to use) early binding is that you get full use of the intellisense in the vba code editor. I've also found it generally to be a bit faster and less buggy (inexplicable errors on late bound objects disappear when they are early bound). It only occurred to me after making the video that late binding would have removed the need for the references, but by then it was made...
This is seriously incredible, I am using this tool to send 4k-5k emails at a time, and currently in testing mode, IT WORKS great, and I cant appreciate you enough, The only part that is a bit slow is that it takes about 16 minutes for the message box "Are you sure you want to send XXXX number of email", is there a way to reduce this time? Im guessing based on your notes that it is just counting the rows in the excel spreadsheet?
Hi James, thank you :-) This seems like a nice feature to add so I have updated the code to *not* count active records when there are more than 50 recipients. Please make sure you have the line "If lastRecordNum < 50 Then" at around line 50 when you copy the new code to make sure you have the latest version and not something from a cache.
I really like what you shared. I can see this being a very efficient flow for me. However, do you have any suggestion on how I can get rid of the User-defined type not defined error? I have both references enabled and replaced the XX.X with the version listed in the references. Any assistance would be appreciated.
It works very well, it only does not work with signatures with images in it. after 2 or 3 emails the MS Word app will crash and you need to restart the process
Great video Simon, it helpd me a lot. Could you please give me ideias on how to include a unique clickable web link for each person in the excel file? Thanks.
Good lord this video (and it's companion merge to pdf) have saved me literally thousands from having to request an enhancement request from our SAS Billing System developer. Well done, simply explained, robust and extremely powerful.
Thank you, this is exactly why we do what we do.
Your mail merge to PDF saves me probably 20 hours of grunt work a month. For that alone, I can't thank you enough. I am looking forward to implementing this because I think it will save me an additional 5 or so more hours. You're an outstanding teacher. Clear, well put together. Thanks yet again!😊
I can't say anything that hasn't already been said, all I can do is affirm what has been said: you rock!
thank you
Wow! I found a buried treasure! Thanks so much for putting your macros out there. They both work amazingly, and cut down on the HOURS of minutia I have to take care of. Thank you Thank you Thank you.
You are so welcome!
its a life & Time saver in corporate ... Great Job
And thanks for step by step tutorial
Again, Thanks for this :) used the mailmerge PDF along with this email with attachments - you have saved myself and team days of copying/pasting etc - looking forward to any more time saving videos/tips
Thank you for taking the time to make such a great program to complete what MS had left off. This program works great, and I did not have to make any changes to the code (not that I could anyway). Everything worked straight out of the "box". Great Job!!!
Superlative solution my friend. I don't have words to thank you. Your channel deserves many more subscriptions and likes. Would recommend it to all.
I have been searching for this solution for more than 6 months. Got it to the point. Thank you very much
Extraordinary! This is the level of code I'd expect you to charge for after seeing the limited example. Very nicely done. Thank you!
Thank you Thomas - the code is just a taster of what can be done, so please get in touch if you have any other tasks which could be sped up in a similar way.
Thank you so much for making this tutorial, and the one before which generates PDF’s. As you mentioned, this is incredibly powerful and I really appreciate your efforts. I especially liked how you split the video into two parts, the first being getting the macro into word and setting up your data so you’re all good to go, and the second being a deep dive into how the macro works. This way, it caters to your viewers needs very well.
I simply pasted the macro (and added the references) and made sure my data was set up exactly like how you instructed, and the drafts generated perfectly on the first run.
Thank you! I hope you continue to make more tutorials like these in the future, you deserve a huge audience.
Thank you, I appreciate the positive feedback.
Fantastic - Just what we needed at the Squash Club, no other sideshows, only what is needed. The basic function in detail.
This is an outstanding contribution -- it has saved me hours. The only strange thing I found was that if the file I wanted to attach was in the same folder, I would get the message "File Not Found". If I put the same file in a higher folder, the program found it and added it perfectly. Again, I am really impressed with the job you did developing this and explaining the VBA code.
I've came across this video (and the previous one on how to create the PDFs) last week, I cannot thank you enough. You have literally saved me dozens of hours a work a month. Well explained and I know little about Excel and I followed it quite easily. Fantasic couple of videos, thank you!
This is extremely helpful. Thank you so much. We needed to send an attachment to a mail merge we were doing and I followed your detailed instructions. No issues whatsoever. This will save us lots of time going forward!
Super duper! Beats the Mail Merge Toolbox being behind pay wall now. Thanks for the resource.
Happy to help!
Exceptional! Even if your not a techie this is a phenomenal tool to have in your kit. Thanks so much!
Nevermind, I figured it out!!! Thanks again for this, it is amazing!
i've tried several tutorials and none of them worked beside this one :') although this one takes much more effort, it's worth it!
Glad I could help!
Thank You! I work in a nonprofit and this is very helpful for outreach. Thank You!
I usually don't comment on videos much..... But damn I must say you made so many peoples job easier with this.... Thank you for this informative video.
Oh my goodness! This was an incredible video and a great resource. I followed all the instructions and it worked perfectly for me. (I didn't need more than ½ of the features and it still worked great!). This will be a big time saver for me over time. Much appreciated!
"let's take a deep breath and send the emails"... I know what you mean! Great video!
I feel like I should have paid for this, it was so extremely helpful
Seriously .. thanks man.. you make working life more smarter than harder ....
Thanks for facilitating. Worked nicely though everything wasn't applicable. Brilliant piece of Work!!
I pasted the same code but yet it is not picking the subject and attachment. What could be the reason behind this ?
@@sukhmanikaur3332 ensure your spelling is correct for all titles. In the beginning I couldn't get my second attachment into the e-mail, turns out I had a typo "attachement", with an extra " e". As soon as I corrected that, the 2nd attachment was added.
Very amazing. Such a life saver for a company like us that sends hundreds to thousands of certificates. Keep it up! Hope to see you succeed
Thank you very much for this solution. It worked perfectly! I have watched a lot of videos trying to accomplish this and none worked. Imnoss 100% fantastic.
I pasted the same code but yet it is not picking the subject and attachment. What could be the reason behind this ?
This is amazing. Thank you so much. I've been using your macros to create personalised PDF documents and mail merge with attachments, which helps me save tons of time.
Man, thank you so much. You’ve saved me uncountable hours…
Thank you for taking the time to create this efficient and nice automated solution, Everything works as it should. Great Job! and thank you again!
fantastic work has made our life so much easier, cannot recommend this enough
This was exactly what I was looking for! I tried it out - and it works perfectly. Thank you so much
This along with it's companion (mergetoPDF) is by the far the best tool/tutorial that is available on youtube and I've seen hundreds. A work of art and beautifully done. Along with filters in 'edit recipients' the possibilities are endless. My life is so much easier now. Thank you @imnoss
You are very welcome
This was the best Outlook process/tip ever. Thanks for this video. Seamlessly turned my Excel into Mail Chimp.
Great content!!! This channel is underrated.👏
This has been a lifesaver, thank you so much for the easy step by step guide.
Brilliant video! Thank you, I am now able to send our regular Newsletter, via email as an attachment, to our members. Quick and simple, no GDPR issues either.
I'm facing an error please help me out..When I run the micro its shows an error- (User-defined type not defined-and highlights the 1st (Sub EnhancedMailMergeToEmail) and Dim outlookApp As Outlook. Application.
Just awesome !! congrats on the dev done!
Absolute Legends. I can't wait to try this!
Thanks Paul :)
@@Imnoss I've got it working and it's amazing! Thanks so much. I use this to schedule and send out emails about appointments and with custom corresponding attachments in bulk. My only snag is that when I try to send the emails from the drafts folder in outlook online instead of the desktop app, it doesn't like the format of the email addresses. If I delete them and retype the same address it works, and if I send it from outlook desktop program it works. The reason I want to use outlook online is because of their free delay email feature, which doesn't require the computer to be on to send it at the delayed time. Any suggestions for things to try with the email address format? I've tried semi-colon afterwards, comma, or nothing, and hyperlinked or non-hyperlinked..? Otherwise this is still an amazing time saver thank you!
Thank you very much for this! You have no idea how helpful. :D You just gained a subscriber.
Unstoppable today, unstoppable today
Thank you so much, the macros and this kind of videos saved my life!
Thank you so much for making this video, I really wanted the dynamic subject line and I wasn't able to figure out how to set that up. Your video instructions worked like a charm and looking forward to using this technique in the future. The whole process and code walkthrough was clearly explained. Thanks again!
AMAZING - Thank you so much, love your step by step straightforwardness...
Thank you very much fo this video it helps alot in mail merginng especially with attachments.
Thanks, this worked beautifully. One point though - you should mention that the excel file being used for the PDFs is the same one that was used to do the mail merge in word. It may not be obvious to some people (like me..lol)
Thank you for this
Very very very helpful
Hope to learn more from your channel
Works wonderful. Thank you very much.
Suggestions:
1. Sometimes one needs to send messages with the same Subject and the same Attachments (not differenrt ones).
Then it seems superfluous to add them, in the excell for each row, and perhaps ot can be entered only once by modifying the Macro.
2. I will try to run same mailmerge from Access table, If successful will report
Thanks for the clear and easy step by step guide. It helps me a lot.
LOVE LOVE LOVE your videos and they work! Thank you!
Worked like a charm!! :) thanks for sharing
Excellent Excellent Videos & Explanations. You're my HERO!!!!!
A first class tutorial thank you so much.
What macro code did you use? mine gave me an error
I can't thank you enough for doing this.
I pasted the same code but yet it is not picking the subject and attachment. What could be the reason behind this ?
Wow! Just Wow. Thank you so much @Imnoss!! This is excellent instruction and extraordinarily useful. I came from your other video and got the split docs and the PDFs thanks to your Mac code. There were a few hitches but I got it to work thanks to helpful responses you gave other commenters. (FYI, it would not save to a Google drive but would to desktop; it also choked where there were duplicate last names, but that was only a few.) I hoped you'd have Mac code for this Emailing step but see that's not done yet so I'll subscribe. I wish I could give you my old Mac to play around on! Or hire you :-) Alas, I'm in the States. If you ever come to the U.S., visit Chicago and I'll buy you lunch, or a beer in gratitude. You're a great teacher!
how to attached same file name while sending mail merge emails and also your video is awesome please upload more like this thank you :)
Thank you so much!!!!!!!! May God bless you!!!!!!
Greetings from Costa Rica.
thank you
Great piece of code! Thanks a lot!
As amazing as the previous one!
Wowsers! Great tutorial my dude!
Thank you. Great VB code and working like a charm.
Thank you so much! What a great tool to use!
Simply Amazing, perfect job.
Terrific job! Much appreciated
you're welcome
@@Imnoss I hope you are up to something else :) The way of giving info in your videos is perfect
Amazing resource, well done
Literally genius !
This is very very helpful!
This is just amazing !!! Thank you for this !!!
Thank you! Amazing tool
thanks!
Hi, Thanks a ton for this tutorial and it worked like a charm. My requirement is to email customized birthday cards to staffs. I want the picture to be inserted in the mail body rather than add as an attachment. Also the email should go on the birthday dates at a specified time. Will you be able to help me ?
This code is a tremendous way to improving efficiency! Thank you for sharing. We are in the process of upgrading our machines. Does it require any modifications to be compatible with Windows 11?
Thank you so much it worked seamlessly, if I wanted to donate how can I do so?
Thanks for the word mail merge to separate pdfs… it was easy to follow. With this one, I’m stuck at the identify the mail merge of the active document. Not sure what I am doing wrong..
Hi, have you set up the mail merge for the document? (i.e. click "Start MailMerge" in the Mailings tab). If you have then is that the document at the front when you run the macro?
This is amazing and is saving me a ton of time. Is there a way to add more than one email address in the cc field?
You can, just separate them with a semi-colon like you would in an outlook email.
I CAN NOT THANK YOU ENOUGH!! 🤩
You are a gem! Too good👌👌
Absolutely brilliant and extremely helpful! Are there any reasons for not using late binding in VBA?
The main reason I generally use (and teach people to use) early binding is that you get full use of the intellisense in the vba code editor. I've also found it generally to be a bit faster and less buggy (inexplicable errors on late bound objects disappear when they are early bound).
It only occurred to me after making the video that late binding would have removed the need for the references, but by then it was made...
Thank you, and again, great product both in terms of code and video content!
Absolute genius. Wow.
I love you! This is fantastic. Thank you! Thank you! Thank you!
Hello Sir,
thank you so much for your work! this really save us a lot of time. May I check if we can set VBA auto label email before it was send?
this is the best ! thank you very much
This is seriously incredible, I am using this tool to send 4k-5k emails at a time, and currently in testing mode, IT WORKS great, and I cant appreciate you enough, The only part that is a bit slow is that it takes about 16 minutes for the message box "Are you sure you want to send XXXX number of email", is there a way to reduce this time? Im guessing based on your notes that it is just counting the rows in the excel spreadsheet?
Hi James, thank you :-)
This seems like a nice feature to add so I have updated the code to *not* count active records when there are more than 50 recipients. Please make sure you have the line "If lastRecordNum < 50 Then" at around line 50 when you copy the new code to make sure you have the latest version and not something from a cache.
you saved my day, i awe you a lot, thanks a lot.
Ingenious
Great to hear! Thank you
The words can't thank you enough.
you are welcome
Thank you for this video! But I do have one question - what happens if I want to send an excel attachment instead of a pdf?
You can send any type of attachment you want. Simply put in the full file path of the Excel xlsx instead of the pdf.
Super sir, excellent delivery, thanks for explanations, how to send the mail thru Gmail instead of Outlook
Thank you so much. You really made my day. :)
How brilliant !
I really like what you shared. I can see this being a very efficient flow for me. However, do you have any suggestion on how I can get rid of the User-defined type not defined error? I have both references enabled and replaced the XX.X with the version listed in the references. Any assistance would be appreciated.
this is prefect! thank you so much really!
Great, it also helps me a lot, Just have one question is there any video or any solution we can use over Gmail?
It works very well, it only does not work with signatures with images in it. after 2 or 3 emails the MS Word app will crash and you need to restart the process
Great video Simon, it helpd me a lot. Could you please give me ideias on how to include a unique clickable web link for each person in the excel file? Thanks.
Great work
you are the absolute best!
good video!
Very useful, thanks a lot for the solution. Could you tell me how I can attach 2 or 3 files?
So good, this video is excellent