+ Reply to Thread
Results 1 to 9 of 9

VBA Outlook help

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    VBA Outlook help

    Good day,

    My code works perfectly, but I need to choose a certain mailbox as I have more than one mailbox in my outlook account. is it possible to be able to choose what mailbox it sends from ?

    Thanks michael

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA Outlook help

    Try this code
    Please Login or Register  to view this content.
    Taken from this link Here
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: VBA Outlook help

    Thanks, that video was great and tank you for your help. but the code im using isn't mine I found it online and no where in the code does it state outlook.applictaion so im not sure where to place the above code?
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA Outlook help

    Does this code work for you ??

  5. #5
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: VBA Outlook help

    it does but it sends from my main account and not the secondary account.

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA Outlook help

    The ShellExecute is a sub or function that is not defined ..
    Can you post the link of the code ..?

  7. #7
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: VBA Outlook help

    here is the Link

  8. #8
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: VBA Outlook help

    Any Ideas on how I can get this to work, I have been tinkering with it for a few days now.

  9. #9
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,915

    Re: VBA Outlook help

    I don't think you can do it with ShellExecute as it's simply using a mailto hyperlink. You'll have to automate Outlook as YasserKhalil showed.
    Rory

+ 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. Replies: 1
    Last Post: 08-21-2018, 01:48 PM
  2. I dont want Outlook remembers last location and last size of “Outlook Inspector”
    By HerryMarkowitz in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-20-2017, 05:45 AM
  3. Attach last saved file outlook/add this to quick step in Outlook
    By Nravota in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 06:25 AM
  4. Outlook 2007, Referencing mail Item created from outlook template
    By thusidie in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 04:33 PM
  5. [SOLVED] Using Exell VBA to launch Outlook Email while separating lines in the body of Outlook.
    By Tazyote in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-27-2013, 01:18 PM
  6. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  7. Share Task From Outlook 2010 to Outlook 2007 and Vice Versa
    By Hudas in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-22-2012, 03:01 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