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
|