Very useful code. I have been using this method for a while. One point though if you have multiple accounts in outlook then you will need a method to send the email from a particular account.
Hi and thanks Keith. Yes for sure and very true. However with this basic training I wanted to keep things as simple and straightforward as possible. Thank you for your Likes, Shares & Comments. It really helps.
Randy thanks for all the great work you do, I am old and probably never have a need for any of the trainings but memory issues these days make it necessary that I challenge my brain as much as possible with something that requires me to think how and why did he do that or trying to contemplate what you are going to do next when designing VBA. It had to be something I am interested in but didn't understand so it would force me to use my brain to help with exercising it. Believe it or not it has helped. Again thanks may not benefit anyone else but has helped me keep active.
That is really great to hear that. I am so happy that I can help and share and that you enjoy the training. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. When declaring variables it tells Excel the purpose of each variable to help eliminate bugs and issues. I also set my VBA to require variable declaration. I hope this helps and thanks so much.
That's very nice, I once created something like that with a Power Automate + Excel 365 (Sharepoint) version.. That combo worked a bit slow though, it took around 1 hour to send 80 emails, but the email content was much more complicated. Could you make an extended version of your VBA+Outlook solution adding more options to the email? For example, how to attach a unique invoice to each contact, add some other file, make a picture inside email body etc
Hi and thanks so much. So very true. I have many, many trainings on more detailed trainings on emails with lots of features. Please run a search on my channel for "Email" to see which trainings fits your requirements: youtube.com/@ExcelForFreelancers I hope this helps and thanks so much.
Hi Randy, I do not use MS Outlook for my email. So could you write and share the VBA code to create and send them with Gmail. Thank you for your kindness and sharing all your knowledge with us. 👋👌
HI and thanks so much. I do have a training on sending emails using Gmail here: th-cam.com/video/lHT0u2zFBoQ/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks so much. This template is complete however you are welcome to download the template and customize it however you like. I hope this helps and thanks so much.
Hi and thanks so much for your comment. I am just focused on VBA for now, however I will certainly consider Python in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Hi If you have tried to download this workbook using the links but had a problem please email Angela@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Is there a way to send the email from another email that is not your own? For example if you are working for someone and you want to send from the company email.
Hi and thanks this will send from the default email, so you would just need to change the default. you can also set the from using the mailItem.SendUsingAccount however its a bit more complicated for this beginners training. I hope this helps and thanks so much.
I'm wondering, what's the benefit of this over using SMTP? If you have an html signature you can inject the html in it and do exactly the same without ever leaving excel.
Hi and thanks so much. Yes for sure i have videos on HTML emails but they are a bit advanced for this beginner series. I also have videos on sending emails with SMTP however they require email password within the application or code so its a bit less secure. I hope this helps and thanks so much.
There is a missing in tool reference Microsoft Outlook 16.0 in VBA. How to add an alternative or name change of it. How to do? I want to do it through coding and send messages from Outlook.
Hi and thanks so much. Many times you don't need the exact one, for example, if you have Outlook 14.0 Object library and the Outlook 16.0 is missing, then the 14.0 will do just fine. You can scroll down your list of libraries to find a comparable one. I hope this helps and thanks so much.
Hi there. You may want to reinstall your Outlook application or search for the library on the internet and download it. I hope this helps and thanks so much.
HI and thanks very much. I have not tested this out with different versions of Outlook however this will work with the newest version of desktop Outlook in Office 365. I hope this helps and thanks so much.
Hi and thanks so much. This issue may be encountered on a Mac computer which cannot run ActiveX components and uses different code. If that is the case, please check out the code available here: www.macexcel.com/
Hi and thanks for your comment. For Macs the code is slightly different. You can find Mac-specific code here: www.macexcel.com/ I hope this helps and thanks so much.
If I want to share a workbook with others, I use a single line of code to send an email and include the workbook as an attachment: Application.Dialogs(xlDialogSendMail).Show arg1:="email address goes here", arg2:="subject line goes here"
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
Very useful code. I have been using this method for a while. One point though if you have multiple accounts in outlook then you will need a method to send the email from a particular account.
Hi and thanks Keith. Yes for sure and very true. However with this basic training I wanted to keep things as simple and straightforward as possible. Thank you for your Likes, Shares & Comments. It really helps.
Randy thanks for all the great work you do, I am old and probably never have a need for any of the trainings but memory issues these days make it necessary that I challenge my brain as much as possible with something that requires me to think how and why did he do that or trying to contemplate what you are going to do next when designing VBA. It had to be something I am interested in but didn't understand so it would force me to use my brain to help with exercising it. Believe it or not it has helped. Again thanks may not benefit anyone else but has helped me keep active.
That is really great to hear that. I am so happy that I can help and share and that you enjoy the training. Thank you for your Likes, Shares & Comments. It really helps.
I think I am in the right place to say that I watched that video with a huge smile on my face hahaha Thank you ! ! ! !
That is so great to hear and thank you for your continued support. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, can you make videos of SAP tool automation.
Hi and thanks. Yes, it may be possible, however I would need a lot more details and specifications. I hope this helps and thanks so much.
Thank you Randy!
Amazing video as usual.
Is there a reason for declaring dim for every variable?
Hi and thanks so much. When declaring variables it tells Excel the purpose of each variable to help eliminate bugs and issues. I also set my VBA to require variable declaration. I hope this helps and thanks so much.
@ExcelForFreelancers
Thank you,
is it better practice to declare
Dim x as integer, dim y as integer
Than
Dim x,y as integer?
Hi and thanks its best to use
Dim x as integer, y as integer
You only need one "Dim" per line.
I hope this helps and thanks so much.
That's very nice, I once created something like that with a Power Automate + Excel 365 (Sharepoint) version.. That combo worked a bit slow though, it took around 1 hour to send 80 emails, but the email content was much more complicated. Could you make an extended version of your VBA+Outlook solution adding more options to the email? For example, how to attach a unique invoice to each contact, add some other file, make a picture inside email body etc
Hi and thanks so much. So very true. I have many, many trainings on more detailed trainings on emails with lots of features. Please run a search on my channel for "Email" to see which trainings fits your requirements: youtube.com/@ExcelForFreelancers
I hope this helps and thanks so much.
Very nice Randy
Thank you so very much, I really appreciate that Eric. I am glad you enjoyed the training
Hi Randy,
I do not use MS Outlook for my email.
So could you write and share the VBA code to create and send them with Gmail.
Thank you for your kindness and sharing all your knowledge with us. 👋👌
HI and thanks so much. I do have a training on sending emails using Gmail here: th-cam.com/video/lHT0u2zFBoQ/w-d-xo.html
I hope this helps and thanks so much.
Thank you sir
For sure, you are very welcome and I am happy to help and share
Excellent!👏👏👏😁 Thanks!!!
Thank you so very much, I really appreciate that David
Can you please add code for adding individual attachments from colum E. Thanks a lot
Hi and thanks so much. This template is complete however you are welcome to download the template and customize it however you like. I hope this helps and thanks so much.
Do you just do vba or are you doing python stuff in the future?
Hi and thanks so much for your comment. I am just focused on VBA for now, however I will certainly consider Python in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Hi from france i can't download excel trainning. tanks for your's basic vba trainning
Hi If you have tried to download this workbook using the links but had a problem please email Angela@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Is there a way to send the email from another email that is not your own? For example if you are working for someone and you want to send from the company email.
Hi and thanks this will send from the default email, so you would just need to change the default. you can also set the from using the mailItem.SendUsingAccount however its a bit more complicated for this beginners training. I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks, I will try that.
I'm wondering, what's the benefit of this over using SMTP? If you have an html signature you can inject the html in it and do exactly the same without ever leaving excel.
Hi and thanks so much. Yes for sure i have videos on HTML emails but they are a bit advanced for this beginner series. I also have videos on sending emails with SMTP however they require email password within the application or code so its a bit less secure. I hope this helps and thanks so much.
There is a missing in tool reference Microsoft Outlook 16.0 in VBA. How to add an alternative or name change of it. How to do? I want to do it through coding and send messages from Outlook.
Hi and thanks so much. Many times you don't need the exact one, for example, if you have Outlook 14.0 Object library and the Outlook 16.0 is missing, then the 14.0 will do just fine. You can scroll down your list of libraries to find a comparable one. I hope this helps and thanks so much.
@@ExcelForFreelancers there is Outlook Name not available.
What to do??
Hi there. You may want to reinstall your Outlook application or search for the library on the internet and download it. I hope this helps and thanks so much.
What about the New Outlook. I doesnt seem to work with the New Outlook.. 😢
HI and thanks very much. I have not tested this out with different versions of Outlook however this will work with the newest version of desktop Outlook in Office 365. I hope this helps and thanks so much.
😊
Thank you so very much, I really appreciate that
i am getting an error 429. "activex component cannot create object" any help? the line of error is "Set OutApp = CreateObject("Outlook.Application")"
Hi and thanks so much. This issue may be encountered on a Mac computer which cannot run ActiveX components and uses different code. If that is the case, please check out the code available here: www.macexcel.com/
doesnt work on macbook :(
Hi and thanks for your comment. For Macs the code is slightly different. You can find Mac-specific code here: www.macexcel.com/
I hope this helps and thanks so much.
Hello Randy,
I hope you are having a nice day. Looking forward to seeing this video again. Can't wait!!!!!!!!!!!!!!!
Great, thanks so much Henk. This one is back to basics and I am sure you will love it
If I want to share a workbook with others, I use a single line of code to send an email and include the workbook as an attachment:
Application.Dialogs(xlDialogSendMail).Show arg1:="email address goes here", arg2:="subject line goes here"
Great Tip! Thanks so much and I will check it out. Much appreciated