Sending a Report by Email

[Robert2150]

I have program that produces a report for each of the Properties that I have in the Database.



I have developed a Print Report Button that sends the report to my printer for the specific Property that is open in my main form. (Based on the Property ID number of the Property open in the Main form.)

I would like to be able to Email that report (for the Specific Property that is open in the form).

However, when I formed a button to Email the report, the program attaches the report data for ALL of the properties.

How do I limit the Email attachment to just the property that is open in my main form?

Thank You.

[pbaldy]

Greetings from next door.

i assume you're using this method when printing:

http://www.baldyweb.com/wherecondition.htm

if so, your simplest solution is probably to use the same method but open in preview mode, then use SendObject to send, then close the report. Since the report is open, SendObject should send the filtered report.

[Robert2150]

Paul,

It works great, thank you very much for your help

Bob W

[pbaldy]

Happy to help!