Making and Emailing a PDF

[feetdontfailme]

I use Microsoft Access VBA to make a PDF of a report. That part works. But, I use another subroutine to email that pdf as an attachment, because Outlook does not exist on the server that Access is on, and I often get that file cannot be found type of errors from the email subroutine. Even with sleep set to 500, there seems to be no good way to make sure that the PDF exists before trying to attach it to an email. Am I wrong? The PDF actually does get made, in the appropriate folder, and I can find it after the error happens, so obviously it is a timing issue. I thank you all in advance for your time and your replies.

[jr]

There are several ways to determine that the output document is ready. The problem is that your own program continues after the print is sent to the spooler. However, the PDF creation continues after the job has reached the spooler.

You can use the StatusFile setting to determine if the document is ready. The setting is documented at the link below.

http://www.biopdf.com/guide/settings.php

Regards,
Jacob

[feetdontfailme]

Thank you for your reply. My question is, what extension would you use (what file type) is the StatusFile? I thank you in advance for your replies and your time

[jr]

The status file is just a text file. It resembles an ini file in the structure.

/Jacob

[wait]

Hello, I'm having similar problem and have one question is the StatusFile created after the printing process and when the pdf file is ready or do I have to check the content of the file ?