🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@glennclever3640
Ай бұрын
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.
@ExcelForFreelancers
Ай бұрын
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.
@andrdem
Ай бұрын
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
@ExcelForFreelancers
Ай бұрын
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.
@droidfan
Ай бұрын
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 ! ! ! !
@ExcelForFreelancers
Ай бұрын
That is so great to hear and thank you for your continued support. Thank you for your Likes, Shares & Comments. It really helps.
@keithturner4036
Ай бұрын
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.
@ExcelForFreelancers
Ай бұрын
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.
@robbe58
Ай бұрын
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. 👋👌
@ExcelForFreelancers
Ай бұрын
HI and thanks so much. I do have a training on sending emails using Gmail here: kzitem.info/news/bejne/zX6Klqlos3hzooY I hope this helps and thanks so much.
@ericvanreck4686
Ай бұрын
Can you please add code for adding individual attachments from colum E. Thanks a lot
@ExcelForFreelancers
Ай бұрын
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.
@abdulhamidalhaddadi2255
Ай бұрын
Thank you sir
@ExcelForFreelancers
Ай бұрын
For sure, you are very welcome and I am happy to help and share
@PraveenKumar-il8kn
Ай бұрын
Hi Randy, can you make videos of SAP tool automation.
@ExcelForFreelancers
Ай бұрын
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.
@ranilan00
Ай бұрын
Thank you Randy! Amazing video as usual. Is there a reason for declaring dim for every variable?
@ExcelForFreelancers
Ай бұрын
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.
@ranilan00
Ай бұрын
@ExcelForFreelancers Thank you, is it better practice to declare Dim x as integer, dim y as integer Than Dim x,y as integer?
@ExcelForFreelancers
Ай бұрын
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.
@davidnavas9065
Ай бұрын
Excellent!👏👏👏😁 Thanks!!!
@ExcelForFreelancers
Ай бұрын
Thank you so very much, I really appreciate that David
@Dexter101x
Ай бұрын
Do you just do vba or are you doing python stuff in the future?
@ExcelForFreelancers
Ай бұрын
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.
@ericvanreck4686
Ай бұрын
Very nice Randy
@ExcelForFreelancers
Ай бұрын
Thank you so very much, I really appreciate that Eric. I am glad you enjoyed the training
@christobacon1
Ай бұрын
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.
@ExcelForFreelancers
Ай бұрын
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.
@IvyPlans
Ай бұрын
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.
@ExcelForFreelancers
Ай бұрын
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.
@IvyPlans
Ай бұрын
@@ExcelForFreelancers Thanks, I will try that.
@muhammadmuavia4825
Ай бұрын
i am getting an error 429. "activex component cannot create object" any help? the line of error is "Set OutApp = CreateObject("Outlook.Application")"
@ExcelForFreelancers
Ай бұрын
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/
@ProHack_GR13
18 күн бұрын
What about the New Outlook. I doesnt seem to work with the New Outlook.. 😢
@ExcelForFreelancers
17 күн бұрын
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.
@henkvinck888
Ай бұрын
Hello Randy, I hope you are having a nice day. Looking forward to seeing this video again. Can't wait!!!!!!!!!!!!!!!
@ExcelForFreelancers
Ай бұрын
Great, thanks so much Henk. This one is back to basics and I am sure you will love it
@olodium6755
Ай бұрын
doesnt work on macbook :(
@ExcelForFreelancers
Ай бұрын
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.
@smithmtodd
Ай бұрын
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"
@ExcelForFreelancers
Ай бұрын
Great Tip! Thanks so much and I will check it out. Much appreciated
Пікірлер: 48