Excel VBA Introduction Part 29.11 - Sending Emails from another Outlook Account

By Andrew Gould

[ashodmartirossian]

After a day of searching and testing, I finally found this source that not only worked, but also has clear explanations of steps and what they can do or not to do. Thank you very much.

[chinchye]

Thanks for the tutorial! Everything works except for the line:
changed to
and it works perfectly. Thanks!

[mehmetcanbulat]

First of all, i would like to thank you Andrew. I asked him to this question via wiseowl.com and 3 days later he made a video at here. I dont know if he made this video for me or not but i can really say that Andrew listens ua and really try to help us. I appreciated what he done so far.

[yaprezero]

dear Andrew, I love you man! Fantastic work simple and straight to the point. Congratulations and a lot, thank you very much!

[uLu_MuLu]

I will try this tomorrow at work! Great video!

[tameraziz]

Andrew, I would to thank you a lot for the efforts you are doing and sharing with us. Quality Work!

[MrDaveinnocent]

Hi although I have 4 accounts in my outlook, when I do this or other similar methods, I can only see my main account. The others don't show at all. Do you know what's causing this?

[dharm]

Paul, how to use a saved draft to send new mail. Also if we can set AIP Label to outgoing mail ?

[pradeepmn]

Thank you so much for detailed information. However, this will not send multiple e-mails at a time. It sends only first recipient. Can you share the link where we can share multiple e-mails using shared e-mail

[amollad]

Hi @Andrew,


Can you please help me out i am getting the error as Object variable or with block variable not

[amollad]

Hii Andrew this code is not working with outlook exchange can you help me with it?? It gives me a error as ‘object variable or with variable not set’

[pradeeprawatvlogs]

Sir again by heart ❣ thank you so much sir 🙏🙏🙏🙏🇮🇳
Love your content and teaching style

[krn]

Great video Andrew. I was curious about that.

[mohamedal-musallam]

You have an amazing channel. I have a question, how can I attach a report in MS Access into an email using vba without using DoCmd. Is there another way to do it?

[alessandrolazzarini]

Thanks for the tutorial! I have a little question: why after sending the email from another ol Account I see the mail in the "Inbox" folder instead in "Sent Items" folder of that account? 😊

[victoropere]

Hey Sir @Andrew could you do a video on how we can apply the Shell function in VBA

Thanks for the enlightenment from your videos

[smartexcelsolutions]

Thank you for this tutorial. I was desperately trying to make this work before I stumbled across this video, but everything I tried failed (Outlook would always use the default email). In my case it probably had to do with me using late binding. Only after I switched to early binding would this finally work. Specifically, there is no late binding equivalent to In late binding this produces an error.

[nikl]

Thanks a ton Andrew - you're a life saver!
While this works perfectly with early binding approach, it doesn't work with the late binding of the Outlook related objects. Why do you think that is?

[kaneboult]

Hullo,

I was wondering if I could use this method for a shared mailbox?

Cheers

[bbangamaly]

Hi Andrew,
I have made program to email the annual leave information to the employees. It’s sending from other account, the company account not from my personal account, the program works fine and generate all emails with different employee email id. But it’s not sending to the employees, it’s all sits in the outbox of the company email. What I want to do for it?