Access & Email

[Shao]

Is it possible to have Access send a list or error to my
email? Thank you. ^-^

 

[Tony Toews]

Is it possible to have Access send a list or error to my
email?

Yes, many different ways. The real simple solutions is
docmd.sendobject. Otherwise see the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[larry]

Yes, many different ways. The real simple solutions is
docmd.sendobject. Otherwise see the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I get a "The command or action "SendObject" isn't available now." error when
I try Docmd.SendObject or try it in a macro. And the "Send To" option on the
File menu is dimmed.


larry

 

[Tony Toews]

I get a "The command or action "SendObject" isn't available now." error when
I try Docmd.SendObject or try it in a macro. And the "Send To" option on the
File menu is dimmed.

That sounds like a default email client hasn't been setup. Which is
highly unlikely.

If you go Control Panel >> Internet Properties >> Programs >> E-mail
do you see your email program there?

Otherwise I have no idea. Possibly searching at support.microsoft.com
might help.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[larry]

That sounds like a default email client hasn't been setup. Which is
highly unlikely.

If you go Control Panel >> Internet Properties >> Programs >> E-mail
do you see your email program there?

Yup. Outlook Express.

Otherwise I have no idea. Possibly searching at support.microsoft.com
might help.

Tony

I tried support.microsoft.com. It would appear that I'm the only one that
ever had this problem but google shows that others did with previous
versions. Maybe MS has no idea what the cause is so they just ignore it.

This thing stopped working quite suddenly and I don't know what I could have
done to cause that.

I tried reinstalling Windows 98 SE (not a fresh install but over the
existing version) and I uninstalled then reinstalled Access 2002.

The Send To option in Windows Explorer works fine.

larry