Unable to send email through macro

[dzirkelb]

I have a simple macro set up to send an email in Access. It sends a word doc via email. The To: field is blank so the user can enter in the address. When they run the macro, they get the following error message:

Microsoft Access can't send a message for the reason stated in the preceding alert.

Resolve that problem, and then send the message again.

I put in a To: field and it works. However, we do not want our users editing the macro.

I found this article published by microsoft, however, it has no resolution to the problem! I have changed the Edit Message from no to yes and back and forth to no resolution.

http://support.microsoft.com/?kbid=262997

Any ideas?