email word document

[judith]

i am using Access 2000 and want to email a word document to a selection of
people in my database. What is the best way to do this, can I use the
SendObject action

thanks

 

[Steve Schapel]

Judith

No, you won't be able to use a SendObject macro for this. Not directly
anyway... you could get a new email message opened, but you would have
to manually attach the document.

You really need to use a VBA procedure for this. There is some good
information here, about various approaches:
http://www.granite.ab.ca/access/email.htm Unfortunately, this is not a
simple matter.