By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

How to email a file using the DoCmd.sendobject

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
"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.