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

Показать описание

Excel VBA Macro: Send Email from a Specific Account (in Outlook). In this video, we go over how to send an email from a different address. The code that we write allows the users to easily send emails from another address using "SentOnBehalfOfName". We also briefly go over how to create a dropdown list and insert the current date in a string.

#ExcelVBA #ExcelMacro

greggowaffles

Рекомендации по теме

Комментарии

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

skiff

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

leopoldoleonel

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

mikevanwieringen

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

Nova

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

freezendog

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

jorgettesantos

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?

agatasiwak

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

debayanroy

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

riteshblackbelt

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

eduardosavinon

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?

brianhobbs

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

Moodlex

From address is not getting changed, pls assist

mailsuren

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

akexcelinstitute

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 =
Set OutMail = OutApp.CreateItem(0)

Set rg1 = Sheets("BLABLABLA").Range(Cells(1, 1), Cells(1, 9))

Set rg2 = Selection

str1 = "<BODY style = & _
"Hola buenos días, <p> BLABLABLABLA. <p>

str2 = "<br>Saludos, <br>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

javierromerolopez

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

Send Mail From Excel via Outlook

Excel VBA Macro: Send Email (with Attachment)

Excel VBA Macro: Send Email (with Outlook)

Excel VBA - Send Excel Tables via Outlook Emails

Excel VBA Macro: Send Email With Table In Body (Dynamic Range)

VBA to Automate Sending Email From Excel Table with Attachment from Folder

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

Excel VBA Macro: Send Email with Picture in Body (Embedded Image)

Convert outlook emails in PDF using VBA. #EXCEL #vba and #SQL

Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)

Send Email with Attachment (Invoice) using Excel VBA Button

Excel VBA Macro: Send Email with All Files (in a Specific Folder) Attached

Send Multiple Emails From Excel

How to Send Emails from an Excel Spreadsheet Using VBA Scripts

Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required!

Excel VBA Macro: Send Email with Dynamic Hyperlink (Variable Based on Cell Value)

How to Automatically Send Emails With HTML Tables Using Excel VBA Macros

Excel VBA Macro: Send Email with Attachments from a List (Dynamic Range)

Excel VBA Macro: Send Email With Multiple Tables In Body (Static and Dynamic Ranges)

How To Automatically Send Customized Emails With Attachments Using Excel Macros

Excel VBA Macro: Send Email (with Hyperlink)

How to create VBA code in Excel to send Emails through Outlook automatically | VBA

Excel VBA Macro: Send Email with Multiple Attachments (Based on Cell Value)

Email excel file VBA Code | How to send email form excel | Excel VBA lesson 55 | Excel VBA function