Send Email from a Specific Account (in Outlook) | Excel VBA Macro 

Thank you for this, Gregg!

Thank you thank you thank you! You just saved me a ton of time!

Thanks Gregg, this really helped me out a lot when automating e-Mails at work!

Dude thank you so much for this

Thanks Greg, just what I needed :) Thanks for sharing

hi, unfortunately that doesn't as it should. wenn you send the mail, the receiver sees the main mail outlook adress and after that it written "on behalf" ... your secondary mail adress. is there a fix for that as well?

Thanks buddy, this just helped me, nice and clear instructions. 👍

Thanks for the video! I have an issue though. I am trying to send emails from a shared mailbox that I have access/rights to but Outlook crashes when I generate the email. It works perfectly fine with me deleting the SentOnBehalfOfName :/ Are you able to advise please?

Excellent contribution, you really helped me with this code!!!

Hi gregg, great video... is it possible to use the .SentOnBehalfOfMe function on Word mail merge?

This is great, thank you!

Thnx buddy.

I have managed to create the vba code. There are 1200 rows, however for each row, there is a prompt in outlook to allow/deny sending the mails each time, defeating the purpose of automation

Somwhow, even afterctrying all this, I am still struggling to send the emails from my group email configured to the same outlook as the personal. I am missing something, i am not sure what

When I send on be half another account, the sent item appears on my account. How can I solve this?

How can you exclude an outlook account from sending an email. The spreadsheet we have auto sends an email and saves the excel spreadsheet when you close it. It sends the emails to the bosses who then review the spreadsheet. However, when they close the spreadsheet, it sends another email to them. How can we remove their email addresses (outlook) from being able to send?

how can you create spaces or tabs between word and lines in the HTML body ?

Nice

Hi how to send automatically when we click on run. When I run getting an error as run time error 287

Hi Gregg, fantastic videos!!! I´m new on VBA. I have been able to send 2 ranges to a email, one static and the another one dinamic as you can see in your code below I would like to add the option of send an email from a different address But it doesn´t work any recommendation Kind regards Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) Set rg1 = Sheets("BLABLABLA").Range(Cells(1, 1), Cells(1, 9)) Set rg2 = Selection str1 = "" & _ "Hola buenos días, BLABLABLABLA. str2 = "Saludos ,Javi" On Error Resume Next With OutMail .To = "" .CC = "" .BCC = "" .Subject = "BLABLABLA " .Display .HTMLBody = str1 & str2 & RangetoHTML(rg1) & RangetoHTML(rg2) & .HTMLBody End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub

From address is not getting changed, pls assist