Email Screen Shot of Form

[derekstewart]

I have a database where users enter a training video code and the description of the video is populated. When they have completed the training video they check the checkbox next to thier name. There are about 20 people that need to log thier training videos. I have added a print button so users can print the current video record with the checks on the page, and it functions very well as an instant report. I have created other reports, but the only report my boss wants to see is the form with the checks next to the names. What I would like to be able to do is to send the form in an email. The only thought I had was to create a button that created a screen shot and then attached the screen shot to an email. Is there a better way to do this? Currently we are printing, scanning and emailing. Any advice would be appreciated. Derek

 

[jkl0]

You might want to look into outputing your report to an rtf, html or pdf(if the software is available?). Then you can email it as an attatchment.

DoCmd.OutputTo (in Visual Basic)

Hope this helps

 

[obli]

I've not much time to explain but...

check out sendobject - here's a snippit of code from one onclick event I use to do what you are talking about.

DoCmd.SendObject acReport, stDocName, acFormatRTF, "recipient@emailaddress", , , stDocName & " " & stDate, "Here is your list for today.", False

 

[obli]

Also Check out MS Knowledgebase article 293508 to find out how to deal with checkboxes on an RTF document.