[AccessD] email and pdf

Hi Richard
Well it depends where the system is now. If you're already emailing stuff
then the attaching a file and sending it won't be an issue to you. If not
then that's one subject on its own.

As regards the PDf side you'll find different people use differnt PDF
creation software. We've started using PdfCreator from
http://www.pdfforge.org/products/pdfcreator andd like it very much. Lijke
all of these products it installs as a printer so one issue is that you need
to be able to direct your output to a specific printer. In A97 (which I'm
STILL on!) that's a bit of a nightmare but I gather it's much easier with
later versions. Then there's the question of the placing and naming of the
file. If you want to make it seamless with no user-intervention, as I do,
then what I've done is set PDFCreator to always output to a specific folder.
I empty that folder, instigate the print and then poll that folder until my
file appears. I then move it to a second folder (so that the first one is
always just a temporary store) and do the emailing and attaching from there.

Not simple but not rocket science either.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] email and pdf
Date: 29/01/08 10:19


Hi



Not been doing a lot of MS Access recently, but have now a request to
add this functionality to a A97 database.........



save reports to pdf format and then email.





How easy is this?



Richard

-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other
privilege.
If you are not the intended recipient, you must not copy, distribute or take
any
action in reliance on it.
If you have received this e-mail in error, please notify us immediately by
using
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it may
be
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or any
response to it under the Freedom of Information Act 2000 unless the
information
in it is covered by one of the exemptions in the Act. By responding to this
e-mail you accept that your response may be subject of recording/monitoring
to
ensure compliance with the Council's ICT Security Policy.
Electronic service accepted only at legalservices at bury.gov.uk and on fax
number
0161 253 5119 .
*************************************************************
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2