How to email a file using the DoCmd.sendobject

[Alfred]

Hi
I am using access 2002
1.0 I want to email a word or html file using the docmd.sendobject The
document must be send as a attachment.

2.0 Second I would like to tell the Docmd.Sendobject to take the Info in a
html or word document and to use it as the body of the email message.

Is this possible. How can I do this.
Thanks Alfred

[Rick Brandt]

"Alfred" <sp**************@hotmail.com> wrote in message
news:bn**********@ctb-nnrp2.saix.net...

Hi
I am using access 2002
1.0 I want to email a word or html file using the docmd.sendobject The
document must be send as a attachment.

2.0 Second I would like to tell the Docmd.Sendobject to take the Info in a
html or word document and to use it as the body of the email message.

Sorry, SendObject only sends objects within the current database. You can't use
it to send files from disk storage. You could automate CDO, Outlook, or another
Email client that supports automation and do it that way. There is sample code
at the following link.

http://www.mvps.org/access/modules/mdl0019.htm

While you might be able to use word automation to retrieve the text from a
document and stuff it into the message argument of SendObject it would not
support anything but plain ASCII text so if your intent was to have the body of
the message look like the document that won't work either.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com