How to send filtered report via email

[degras]

I have a report that I currently open via a button that runs the following code:

DoCmd.OpenReport "MultiInvoice", acViewPreview, , "InvoiceNo = '" & Me.InvoiceNo & "'", , "NoGroup"

I would like a function for emailing this report. I am aware of the "DoCmd.SendObject" command, however there is no "where clause" in this command. How do I get around this limitation?

[pbaldy]

A couple of ways, simplest for you probably adding the SendObject line right after the OpenReport line. Though SendObject doesn't have the wherecondition argument, if the report is already open it should send the filtered report.

You can also filter from within the report:

http://www.granite.ab.ca/access/emai...recipients.htm

[degras]

OK, thanks.

[pbaldy]

Happy to help. Did that work for you?

[degras]

Happy to help. Did that work for you?

Yes, I made an extra function to output the report to PDF. I told the users they could email the report via the main menu.