Attaching a single report to a single Email address

[NYFashionToGo]

I have reports that act as Invoice and sales receipts. I am trying to create a way to email them. When I experimented and tried to do so.... Every single report is attached to every single customer. How do I make it a single. So the report or Invoice goes to the correct person.

 

[PaulBricker]

You need to look at the FilterName or Where Condition of the OpenReport Method. If you are looping thru a recordset and attaching the reports that way, then you can build a Where Condition that will filter the report for the specific client.


Paul