E-mailing a report to an address specified on a form

  • Thread starter Thread starter John S. Ford, MD
  • Start date Start date
J

John S. Ford, MD

Suppose I create a form that allows data to be entered into some controls
one of which is txtEmailAddress which of course accepts a valid E-mail
address.

I wish to have a command button at the bottom that generates a report using
the entered information.

What kind of VBA code would I need to E-mail that report to the E-mail
address my user entered? In what form would the report have to be converted
to be E-mailable and opened by the addressee?

I'm fairly competent in MS Access coding but don't know anything about
interfacing Access with a mail program (i.e. Outlook Express). Where can I
get this kind of information?

John
 
Try reading up on the SendObject Method

using the SendObject function you can specify an existing report, specify
the format you want to email the report in: txt, rtf, snp etc,

you can then specify the mail address (Me.txtboxeithemailaddress) and even
include a subject and message.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top