How to include report name in database path?

[tracy1234]

I'm tinkering around with a program to send e-mails from Access to Groupwise. The program (written by Dimitri Furman and found at

http://www.mvps.org/access/modules/mdl0059.htm)

creates an e-mail attachment and then let's me specify the path to the attachment.

Right now I can attach my whole database to a groupwise e-mail:

varAttach(0) = "Q:\Access_User_Databases\Overdue_Oracle_Jobs\job_status.mdb"

But what I really want to do is attach a specific report to the e-mail. What is the syntax to add to the end of the path to specify a specify report?

-Tracy

 

[psemianonymous]

I might be wrong, but I'm pretty sure you'll have to export the report to a file, then use that file as an attachment--there's no direct linking to reports as file attachments.

 

[tracy1234]

Ok thanks, I'll try that now.

-Tracy