CODEWITHSUNDEEP
vbaemailexceloutlook
Mike Marshall
Mike Marshall

Reputation: 361

How to send email from secondary email address without setting up a second account?

I am using Excel 2010 on W7 x64, to send email from Outlook using code from Ron de Bruin. I have an individual and group email address that I send from.
I want to send from the group address by changing it in VBA.

The secondary address is not set up as an actual account in Outlook. If I go to File - Account Settings in Outlook, there is only one email account listed.

The group email address simply forwards to the group.

I created an actual account for the group box.
I added the reference to Microsoft Outlook Object Library in VBA, and added the code to select between account 1 or 2 using the MailItem.SendUsingAccount property, but Outlook would freeze up when trying to send from this address.

I can manually select between my Individual and Group email in the from dropdown box in Outlook when I send emails.
Is there a way to do this in VBA without setting up a second account?

Upvotes: 2

Views: 38135

Answers (2)

Deepak Lohia
Deepak Lohia

Reputation: 1

SendUsingAccount worked for me.

    For Each acc In OutApp.Session.Accounts
        If acc = frmMain.cmbxSendFrom.Text Then
             .SendUsingAccount  = acc 
        End If
    Next acc

Upvotes: 0

Paresh J
Paresh J

Reputation: 2419

You can use .SentOnBehalfOfName property of outlook to send mail in the name of other user. Check the following code and URL for further details: http://www.slipstick.com/developer/code-samples/send-email-address-vba/

oMail.SentOnBehalfOfName = "[email protected]"

Upvotes: 6

Related Questions