SendObjects - Catching the Cancel

[Michelle]

Quickie question, I get the message "SendObject Action was
cancelled" when I opt not to send the result of
cmdSendObject. How can I change the resulting message (it
doesn't actually generate a trappable error?) so that it
sounds a bit more user-friendly?

Many thanks
Michelle

 

[Arvin Meyer]

I can't repeat your behavior in several different versions of Access. When
SendObject is involked, it opens an email. If you elect not to send the
email, the error message, if there is one, is in the email program.

If this is not what is happening, you might try using:

On error resume next

in your code, or:

On error GoTo 0
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access