+ Reply to Thread
Results 1 to 4 of 4

Automatic email to automatically send; how?

  1. #1
    Forum Contributor
    Join Date
    07-22-2009
    Location
    Minneapolis, MN
    MS-Off Ver
    2010
    Posts
    204

    Automatic email to automatically send; how?

    I have this code, which works great for sending emails. An outlook window opens up, already filled out, and you hit "send"; simple.

    However, I would like the code to hit "send" for me.

    What/ how could I modify the code below to do this? Or, is there a more efficient code for doing so? This code will just be added to an existing macro.

    Thanks for the help!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,964

    Re: Automatic email to automatically send; how?

    Try

    Please Login or Register  to view this content.
    If this doesn't work, you might try making a reference to Outlook and declaring Outmail as an Outlook mailitem.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Forum Contributor
    Join Date
    07-22-2009
    Location
    Minneapolis, MN
    MS-Off Ver
    2010
    Posts
    204

    Re: Automatic email to automatically send; how?

    Bingo!

    I replaced
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.
    and presto! A window did not pop either, which is great.

    Thanks for the help!
    Last edited by Cutter; 09-03-2012 at 04:54 PM. Reason: Removed whole post quote

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Automatic email to automatically send; how?

    @ Rerock

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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