+ Reply to Thread
Results 1 to 3 of 3

Excel to Email VBA Question

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Excel to Email VBA Question

    Hi All,

    I am using a macro in VBA in an attempt to have it open a new email in outlook, attach the full workbook to the email, and have it auto populate some of the email details.

    I have a macro that is sending the full workbook view outlook but it does not open a new message to do so. I actually want to be able to hit the submit button on the email rather than it all happening in the background, here is the code I am using:


    Please Login or Register  to view this content.

    Does anyone have any thoughts on how I can modify this code to have it open up a new email and then require the user to hit send instead of it all happening in the behind the scenes?

    Any help anyone may be able to provide would be greatly appreciated!

    Thank you!
    Last edited by bobsmith123; 07-17-2014 at 09:01 AM. Reason: Updating my code to adhere to rule 3 as per Moderators request. Thank you.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,244

    Re: Excel to Email VBA Question

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Registered User
    Join Date
    03-29-2014
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Excel to Email VBA Question

    not sure if this thread has been unlocked, bump?

+ 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: 2
    Last Post: 02-14-2014, 12:03 AM
  2. [SOLVED] Email Question
    By Maull in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2010, 10:55 PM
  3. Email from Excel 2007 Question
    By pcargila in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2008, 11:14 AM
  4. Email question Please.
    By Steved in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2005, 12:05 PM
  5. Email via Excel question
    By Fable in forum Excel General
    Replies: 0
    Last Post: 03-26-2005, 02:04 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