Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel to form email in outlook | Excel Worksheet Functions | |||
Excel in email form... | Excel Discussion (Misc queries) | |||
Excel should not delete document after trying to send email | Excel Discussion (Misc queries) | |||
Email Excel form | Excel Programming | |||
Email an Excel form input using VBA | Excel Programming |