I am trying to email a personal invoice to our members. I can generate a PDF
file of the invoice OK for each person and I can email them something as an
attachment. However it seems a bit hit & miss whose invoice gets sent.
I suspect that the problem is that the first PDF file is on the screen and
that is the one that gets attached as I don't see the subsequent invoices
while the first one is visible.

Can anyone point me in the right direction of closing the Acrobat
application using VBA. Presumably I have to find it's hwnd and then do
something with that.

"Phil Stanton" <phil at (no spam) myfamilyname.co.uk> wrote:

I am trying to email a personal invoice to our members. I can generate a
PDF
file of the invoice OK for each person and I can email them something as
an
attachment. However it seems a bit hit & miss whose invoice gets sent.
I suspect that the problem is that the first PDF file is on the screen and
that is the one that gets attached as I don't see the subsequent invoices
while the first one is visible.

Can anyone point me in the right direction of closing the Acrobat
application using VBA. Presumably I have to find it's hwnd and then do
something with that.

Don't use Adobe Acrobat. A2000ReportToPDF is an Access 2000 database
containing a
function to convert Reports and Snapshot files to PDF documents. No PDF
Printer
driver is required. Free.
http://www.lebans.com/reporttopdf.htm

I've been using it via VBA for a few years now. It works well and
efficiently.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/