+ Reply to Thread
Results 1 to 5 of 5

Excel not using correct Email account for Mailing

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    34

    Excel not using correct Email account for Mailing

    I use the macro below to send a emails with attachments. I want outlook to use the default account to send email from but it uses the second account.
    How do I force the macro to send using the default email or a specific Outlook email account?

    Thanks in advance for the HELP!

    Please Login or Register  to view this content.
    Last edited by zbor; 11-21-2016 at 09:46 AM.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Excel not using correct Email account for Mailing

    duplicate post... same as what I have below.
    Last edited by Arkadi; 11-18-2016 at 12:41 PM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Excel not using correct Email account for Mailing

    just before the olMail.Send line you could use:
    Please Login or Register  to view this content.
    but I'm not sure whether 1 is the number you need.... This little piece of code should help you figure out which account is which number:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-12-2006
    Posts
    34

    Re: Excel not using correct Email account for Mailing

    Got it!

    Thanks again!

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Excel not using correct Email account for Mailing

    My pleasure, but just like last thread, if your issue is solved do please mark them as solved? They both seem like the solution solved your problem but since they don't say solved, others may still think help is needed.
    I do thank you again for being kind enough to provide rep

+ 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. Maco to email using secondary email account
    By jdoerr1021 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2015, 09:51 PM
  2. Replies: 2
    Last Post: 02-25-2013, 10:40 AM
  3. Macro to copy email to excel not in correct format
    By josh640557 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 11:59 AM
  4. Replies: 2
    Last Post: 02-16-2009, 08:32 PM
  5. Send data from Excel in email from specific email account
    By eriknokc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2007, 05:02 PM
  6. [SOLVED] How do I import email from my account into Excel?
    By josh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-05-2006, 11:15 PM
  7. [SOLVED] how do i convert MS Word mailing labels into an Excel mailing lis.
    By unrhyll in forum Excel General
    Replies: 1
    Last Post: 02-03-2005, 09:06 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