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
|