Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Delete email after Excel form sent

Hi
Is there a way to have the email permenantly delete from your sent box in
Outlook once an excel form has been sent.

The code I current have is

With EOutMail
.To = "ASCR"
.CC = ""
.BCC = ""
.Subject = "ADV - " & varEmailCountry
.Body = "Hi," & vbNewLine & stMessage & vbNewLine & vbNewLine
.Attachments.Add ActiveWorkbook.FullName
.DeleteAfterSubmit = True
.Send 'or use .Display
End With
Set EOutMail = Nothing
Set EOutApp = Nothing

Reason we need to delete permenantly is becuase the forms can be large which
prevents the next form from emailing.

Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to form email in outlook Aaron Excel Worksheet Functions 1 July 3rd 07 03:25 PM
Excel in email form... bplumm01 Excel Discussion (Misc queries) 1 August 5th 06 04:29 PM
Excel should not delete document after trying to send email 4rs Excel Discussion (Misc queries) 0 January 14th 05 04:39 AM
Email Excel form MR[_2_] Excel Programming 3 April 9th 04 04:16 PM
Email an Excel form input using VBA Jaime[_3_] Excel Programming 6 January 26th 04 06:12 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"