469,579 Members | 1,098 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

How to email a file using the DoCmd.sendobject


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
Nov 12 '05 #1
1 9480
"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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Lauren Quantrell | last post: by
2 posts views Thread by John Taylor | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.