+ Reply to Thread
Results 1 to 2 of 2

To check if email was Sent or not sent and then do set of commands.

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    To check if email was Sent or not sent and then do set of commands.

    hello

    Background :

    The following code sends an reminder email. The code is designed to display the email (not automatically send)
    Based on what the user chooses ("Send" or "Close the display") ; I want the code to do few things.

    Code is

    Please Login or Register  to view this content.

    Problem
    • When I send the email after putting recipients email, it follows whats in green in the code
    • When I close the display, it still does the same...


    What I tried ?

    I tried to put the "If omsg15.Sent Then.... End If ' olEmail.sent" inside the "With...End With". It didn't work as it should. It closed the email and did whats in Green in the code



    P.S

    Relevant to whats discussed on https://www.excelforum.com/excel-pro...recipient.html

  2. #2
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: To check if email was Sent or not sent and then do set of commands.

    Any help on this is much appreciated...

    thanks

+ 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. Valid email id check
    By luxmraj in forum Excel General
    Replies: 5
    Last Post: 11-09-2021, 12:51 PM
  2. Check date, auto email
    By JonathanB2 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-12-2013, 11:17 AM
  3. Macro Recording Chart Format commands missing all important commands!!!!
    By nounours in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 09:20 PM
  4. Sharepoint commands: Check out and check in
    By Mojave in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2012, 02:22 AM
  5. check if email (provider) is valid
    By Armitage2k in forum Excel General
    Replies: 0
    Last Post: 06-03-2011, 11:39 AM
  6. [SOLVED] Provide a check in VBA for backward compatibility of commands
    By Robert Munster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 06:05 AM
  7. Visual Basic commands for email
    By David Overington in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2005, 11: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