How to find the path of a report in your database

[ksmith21]

I have developed a form to send an email from my Access database using VBA. I would like to add an attachment as a default. I would like this to be a report within the database. I have a code that will browse to an external file and then attach and send but I just want to add a local file.
How do I find the path of the report in the database?

[June7]

What do you mean by 'path of the report'? An Access report is an object in the database, there is no 'path'. Reports are dynamic. The data displayed in a report changes as data is input to the database. A report must be open for the data to be viewed. Reports can be exported to other formats such as xls and pdf. A report open in PrintPreview can be directly included as pdf attachment to an email with SendObject method. Other code methods require report to first be exported to xls or pdf and then that file can be attached to email.

[ksmith21]

Thankyou for the response. When you use the wizard to insert a hyperlink and you can point straight to a report - that was what I was hoping would be a "path" which I could just insert into a default attachment box. I understand what you are saying though and will now try and work out the code for what you have suggested (I cannot use SendObject - the computer settings and firewalls in place block everything so I have had to vba code (which works).

[June7]

By 'insert a hyperlink' you mean into a Hyperlink type field?

What do you mean by 'attachment box' - an Attachment type field would embed the file into record, this would not be a 'hyperlink' to external file. Including a file from Attachment field requires first saving the embedded file out to external folder location.