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

[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

 

[Guest]

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.

 

[John S. Ford, MD]

Thank you Jeff,

That's sounds like exactly what I'm looking for.

John