I use the following OUTLOOK Object Model code to email sheets to users. I
need to know if the sender actually sent the email.

I know how to get a return code using the SENDMAIL model, but I need to
modify the body of the message. I have searched all documentation that I
have, or have been able to find, including searching the OUTLOOK community
Q&A's.

Can a return code be sent back that tells me if the sender actually sent the
email?


Thanks regards,
Gary

€˜
€˜Send email
€˜
With OutMail
.To = "
.CC = ""
.BCC = ""
.Subject = "Ron, Thank you for making your code samples public!"
.Body = Modified_message_based_on_sheet_content
.Attachments.Add archivename
.Display
End With

If emailsent then
LogTheEmailSent
Else
Msgbox €œemail was not sent!€�
endif