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?