+ Reply to Thread
Results 1 to 4 of 4

Send email from a specific email address

  1. #1
    Forum Contributor
    Join Date
    04-05-2010
    Location
    Lakewood, IL
    MS-Off Ver
    Excel 2016
    Posts
    384

    Send email from a specific email address

    Hi, I have been using a Macro to send emails to specific people. The Outlook client on my computer has multiple email addresses. I need the "from" for the macro to send the email from a specific email address found in my Outlook Client. I have set that email address within Outlook as the default email address, but it keeps sending it for the wrong email. Here is the macro I am using:

    Please Login or Register  to view this content.
    I expect I need to add a .From statement but do not know where to put that statement. Does anyone know how to do that?

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Send email from a specific email address

    I think it's
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,386

    Re: Send email from a specific email address

    Try to find your account item number with:

    Please Login or Register  to view this content.
    Then use that item number in the code below
    Please Login or Register  to view this content.
    Last edited by JEC.; 10-30-2021 at 12:15 PM.

  4. #4
    Forum Contributor
    Join Date
    04-05-2010
    Location
    Lakewood, IL
    MS-Off Ver
    Excel 2016
    Posts
    384

    Re: Send email from a specific email address

    Quote Originally Posted by ByteMarks View Post
    I think it's
    Please Login or Register  to view this content.
    Unfortunately that does not work. What it does is send the email from the account I don't want it to and says on behalf of the correct email address. Thanks for your suggestion!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Email Send Macro - 0 pulling into CC field when no email address present
    By toriwoo86 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-26-2021, 02:18 PM
  2. Button to Send email & auto add email address from cell
    By TheNerdyGeek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2019, 02:43 PM
  3. [SOLVED] vba email send from excel - ignore second email address if "ENTER EMAIL ADDRESS"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2016, 07:22 AM
  4. [SOLVED] VBA to send email using data from the EXCEL including email address, subject and body text
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 11:07 AM
  5. VBA code to send email to the people whose email address is in the Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2014, 05:11 AM
  6. Send workbook to specific email address
    By tulliofn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 09:29 AM
  7. Replies: 6
    Last Post: 12-02-2011, 02:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1