+ Reply to Thread
Results 1 to 4 of 4

Sub Routine in Excel to Sent E-Mail and then delete

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    27

    Sub Routine in Excel to Sent E-Mail and then delete

    Hi,

    Not sure if this should be posted in Excel or Outlook section...

    I am using Excel to generate an display an E-Mail (not send).

    Is there any way that I can once I have added text to E-Mail body and sent it to get it to delete it from my Sent Items automatically as part of the same macro/sub routine.

    So Excel -> Macro to generate and display E-Mail -> Add text to body -> Click Send -> Delete E-Mail from Sent Items.

    Cheers,

    Bren.

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Sub Routine in Excel to Sent E-Mail and then delete

    Hi,
    try this, it works for me.
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  3. #3
    Registered User
    Join Date
    07-04-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Sub Routine in Excel to Sent E-Mail and then delete

    Oh that worked an absolute treat - thank you so much, great solution!

    TLP.

  4. #4
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Sub Routine in Excel to Sent E-Mail and then delete

    Glad it helped you!

+ 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. [SOLVED] Search And Delete Routine Based On Conditions
    By FarOut in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2013, 05:05 AM
  2. Delete row from mouse after sub routine has been executed
    By cgkmal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2011, 07:03 PM
  3. Delete sent e-mail from outlook in excel VBA
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2011, 07:13 AM
  4. delete multiple addresses in excel before mail merge
    By dacook4usn in forum Excel General
    Replies: 0
    Last Post: 02-21-2006, 05:55 PM
  5. [SOLVED] how to delete an excel file? how to e-mail a worksheet?
    By mailman in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-25-2005, 06:05 AM

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