Can a form or report send an email message?

[Paul James]

I'm trying to figure out a way to write some VBA code for the Close event of
either a form or report that would automatically send an email message to
the address of a field in the recordset. I would also like to either
display or attach the page from the form or report to the email message.

Is there any way to do this?

Thanks in advance,

Paul

 

[Cheryl Fischer]

Check out the SendObject method in VBA Help.

 

[Paul James]

Looks like this is what I need.

Thanks, Cheryl.