+ Reply to Thread
Results 1 to 4 of 4

send sheet automatically via Outlook wihtout clicking on "send"

  1. #1
    Registered User
    Join Date
    08-09-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    28

    send sheet automatically via Outlook wihtout clicking on "send"

    Hello guys,

    I have done only a couple of really simple macros so far and I would need your help on that one!

    Scenario: I want an excel sheet (not the workbook) to be sent automatically to a specific email address via Outlook, WITHOUT having to click on "Send" in the outlook interface.

    Now, I found this code on ron de bruin website, which worked but I had to click on "send" once the sheet was attached to the email:

    http://www.rondebruin.nl/win/s1/outlook/amail2.htm

    Is there any code to add so that I do not need to click on "send" in outlook, and the email would be sent automatically with the sheet attached?

    Any thought is a great help!

    Thank you guys
    Last edited by aucho; 08-09-2013 at 06:05 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,084

    Re: send sheet automatically via Outlook wihtout clicking on "send"

    You have this line of code:

    Please Login or Register  to view this content.

    The clue is in the comment


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-09-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: send sheet automatically via Outlook wihtout clicking on "send"

    Thank you every much macro guru, next time I ll read the code more carefully!

    Problem solved.

    Aucho

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,084

    Re: send sheet automatically via Outlook wihtout clicking on "send"

    You're welcome.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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: 5
    Last Post: 02-22-2013, 02:00 AM
  2. [SOLVED] VBA code - automatically open outlook to send email
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:44 AM
  3. Excel to automatically send an email from Outlook when a condition is met
    By Spyke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2011, 04:40 AM
  4. Macro to send data automatically everyhour from Excel via Outlook and out to Readers
    By Shibu_john1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2010, 07:48 PM
  5. Automatically send Excel document in Outlook
    By Excel_Enthuse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2008, 09:05 PM

Tags for this Thread

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