View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noemi Noemi is offline
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