I have an incident reporting form in Excel that needs to email itself and PDFs of different bits of itself to various people within the organisation. I have a VBA program that does this, creating a new mailitem for each message.
This is what it does:
Set Msg = new Outlook.mailitem
(Other stuff)
Msg.to = string of email addresses
Resolve email addresses
If they’re OK, send the message.
If one or more is invalid, display msg to allow the user to sort it out.
If this happens, he might sort out the addressee problem & send it (good), or click the X to close it (bad). In either case, the message has disappeared, so mailitem.sent isn’t obviously available to know which, and I need to know as there could be consequences if a report isn’t acted on because the message wasn’t sent.
Thanks in advance for any suggestions.
This is what it does:
Set Msg = new Outlook.mailitem
(Other stuff)
Msg.to = string of email addresses
Resolve email addresses
If they’re OK, send the message.
If one or more is invalid, display msg to allow the user to sort it out.
If this happens, he might sort out the addressee problem & send it (good), or click the X to close it (bad). In either case, the message has disappeared, so mailitem.sent isn’t obviously available to know which, and I need to know as there could be consequences if a report isn’t acted on because the message wasn’t sent.
Thanks in advance for any suggestions.
