Sending an Email directly from an Access Application

[George]

Access can be made to launch Outlook (or Outlook Express)
using the shell function as in
Call Shell(stAppName, 1)
where stAppName is the path to Outlook.

QUESTION: How do we use this code so the recipient email
address appears in the To: field, (as when you click on an
email address from within a word document?)

Is there a publication I can use? A Knowledge Base
Article?

Thanks

George

 

[Dirk Goldgar]

Access can be made to launch Outlook (or Outlook Express)
using the shell function as in
Call Shell(stAppName, 1)
where stAppName is the path to Outlook.

QUESTION: How do we use this code so the recipient email
address appears in the To: field, (as when you click on an
email address from within a word document?)

Is there a publication I can use? A Knowledge Base
Article?

Thanks

George

Use the DoCmd.SendObject method. Note that, although this is designed
to send Access objects as e-mail attachments, you can specify that no
object is to be attached -- just a plain text message. If you're using
Access 2000, make sure you're up to date on service packs for Access,
because the original release of A2K had a bug in the SendObject method.