Macro to Send Email from different account
Hello,
I have Office 2013, and I am trying to write a macro to send an email from a certain account, but my Email_Send_From doesnt seem to be working. The email sends to who I want it to, and says what I want it to, but it is using the wrong email to send from.
Any help? I have several emails setup on my outlook. I want it to send from my gmail account. I have it setup with imap.
Thank you for the help.
Please Login or Register to view this content.
Last edited by automafia; 03-04-2015 at 04:57 PM.
Hi automafia
Welcome to the Forum!!!
Please wrap your Code in Code Tags...it's a Forum requirement.
Do a search on "excel vba send email on behalf of"
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Sorry about that. I have been searching the internet all morning on this and I havent found anything that has helped so far.
It is still sending from my main work account instead of the email I want it to send from.
Last edited by automafia; 03-04-2015 at 03:25 PM.
Hi automafia
This Code works for me...
Please Login or Register to view this content.
Okay let me try that real quick
Last edited by automafia; 03-04-2015 at 04:19 PM.
I get the following email when I try to send that.
Your message did not reach some or all of the intended recipients.
Subject: Hello Megan Schuelka
Sent: 3/4/2015 1:21 PM
The following recipient(s) cannot be reached:
Wes Smith on 3/4/2015 1:21 PM
This message could not be sent. Try sending the message again later, or contact your network administrator. Error is [0x80070005-00000000-00000000].
No clue...Google it.
Weird. I get that error if I just hit send. But if I manually click the From: and then select the account I want to use it works. It looks the exact same before and after I select it.
I have figured it out!
Here is the solution.
After adding my Gmail account to Outlook, I closed outlook at restarted it.
I then ran this Macro:
Please Login or Register to view this content.
Using this Macro I found that Outlook saw my gmail as Account Number 2.
I used the following code to send the email:
Please Login or Register to view this content.
Great work...I misunderstood your requirements.
You taught me something new today...Thank You.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks