Emailing report in access

[Robert2150]

I am currently working with an Access 2010 database. I have incorporated buttons to print specific reports related to a specific record on a table. Now I would like to set a command button to send that report by email (Using Outlook). I used the MACRO builder to do this, however when the Email is developed in Outlook all pages of the report are attached. In my print reports button I have the following code to limit which record report to print.

strWhere = "[Property Number] = " & Me.[Property Number]

How can I input this code into the Email Macro?, or is there another approach I could use?

[ItsMe]

I don't know how you are sending your emails but this is example code of mine that I use to save a report with specific criteria. The key is opening the report with a where clause. In this case I use a variant but you can place your string there. After it is open, you need to slelect it with Docmd.SelectObject. Now you are ready to Docmd.OutputTo.

Things might be a little different for Access 2010 and I don't know exactly how you are sending your emails but I believe the info you need is contained below in this example of how to save a text file to your hard drive.

DoCmd.OpenReport stDocName, acViewPreview, , varWhere, acHidden
DoCmd.SelectObject acReport, stDocName, False
DoCmd.OutputTo acOutputReport, stDocName, acFormatTXT, strDirectory
DoCmd.Close acReport, stDocName

[June7]

You have to open the report filtered to that criteria then send the open report.

Are you using SendObject method?