Sending an Email directly from an Access Application

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
George said:
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
Click to expand...

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.
 
Back
Top