View Single Post
  #1   Report Post  
WimR
 
Posts: n/a
Default Auto Email from Excel doesn't appear in Sent Items

When I email a Excel file using VBA code, the e-mail appears in my
Outbox but disappears once it has been sent. It does not show up in my
Sent Items. This only happens with e-mails sent through this code.

I use the code

ActiveWorkbook.SendMail Sheets("program").Range("f10").Value, _
"For your approval"
With ActiveWorkbook
..Saved = True
..Close

Can somebody please explain how I can fix this ?
Many thanks for your help.

WimR