Capture record displayed on form and transmit via e-mail

[Guest]

Is it possible to capture a record that is displayed on a form and then
transmit that record image via e-mail?? We are currently getting paper
copies of a record that is displayed on a form, and then sending that paper
copy to the individual. We would like to capture the image of that record
and then sent that image to the individual via our e-mail system. Please
note that most of my forms are longer than what is visible on the computer
screen at one time.

 

[Guest]

konichewa,
http://c85.cemi.rssi.ru/access/TipDetail.idc?TipID=71
also and
see help on do.cmd sendobject method action.

 

[Kevin Sprinkel]

See help on the SendObject method. I've never tried to
send a form, and always create a report definition showing
the same information.

You can specify the addresee(s) in the 4th parameter, or,
if left blank, you'll be prompted to enter them once your
mail program opens.

Something like:

DoCmd.SendObject acSendReport, "YourReportName", _
acFormatRTF, , , , "YourSubjectLine", _
"YourMessageText", , False

HTH
Kevin Sprinkel