Send a PDF via email.

[tcheck]

I poasted a similar question a few weeks back to find out why I would get a Run-Time error '7971' when I would click on a button to open the PDf. I used the command;



Application.FollowHyperlink Me!ReportLink

and that worked.

Now I am trying to send the the PDF via email using the command

DoCmd.SendObject acSendReport, Me!ReportLink, acFormatPDF, "", "", "", "Subject", "", True, ""

And I am getting a Run-Time error '2059' Microsft Office Access cannot find the object with single quotes around the file location and name.

[pbaldy]

SendObject is looking for the name of the report object you want to send, not a path to an existing file. It will create and send the PDF without saving it. If you want to send an existing file, you need to use a different method (automation, CDO, etc).

[tcheck]

Thanks. Do you have a command line that I can test to send an existing file?

[pbaldy]

There is no one-line command that I know of. One method is to automate Outlook, presuming you have it. Here's one link:

http://support.microsoft.com/?kbid=209948