Use VBA to create pdf file from Access Report AND Word docs

[Adrian]

Currently our users can automatically email snapshot reports from Access
(2003). I want to change this so that we send pdf files instead of snapshot
files.

I have looked at Stephen Lebans ReportToPDF
(http://www.lebans.com/reporttopdf.htm) and I think this would probably
achieve this.

However I would also like to extend this so that we can create and email a
pdf file from Word Documents (and in an ideal world this would be extended
to include Excel Documents) and I don't think this can be done with
ReportToPDF. I would prefer not to have to implement 2 completely different
solutions.

Any ideas or suggestions would be welcome.

Adrian.

 

[SusanV]

For an overall solution, you could use CutePDF Writer, a free utility that
will print to a pdf file:
http://www.cutepdf.com/

Be sure to download both the writer and the converter (GhostScript). Once
this is installed users can select The CutePDF Writer from their Print
options.

 

[Adrian]

Susan,

Thanks for your advice.

We do actually have CutePDF Writer which our users use to print
interactively to a PDF file. However I am not aware that this can be
automated i.e. The user selects a report or word doc, puts in the recipient
email address, and presses a button to send the report to the recipient
without any further user interaction.

Adrian

 

[SusanV]

Ah, gotcha. Sorry my post wasn't more helpful.

Susan,

Thanks for your advice.

We do actually have CutePDF Writer which our users use to print
interactively to a PDF file. However I am not aware that this can be
automated i.e. The user selects a report or word doc, puts in the
recipient email address, and presses a button to send the report to the
recipient without any further user interaction.

Adrian

 

[Adrian]

No problem. I am always grateful to anyone who takes the time to reply.