Macro to email PDF file

V

VickiS

I have downloaded CutePDF Writer and can now print a report to a PDF
formatted file; however, I want to be able to inset the PDF file into an
e-mail macro. The output format for SendObject doesn't include the PDF format.

I read elsewhere that I needed to install a module that I named PDF (copy is
at http://www.freeware995.com/misc/vbacode.txt) but I don't think it's what I
need because it refers to PDF995 and I didn't install that (CutePDF is free).

I don't know where to go from here. I'm using Access 2002 but I'm
self-taught. Please don't just tell me to 'call' something ... I need you to
literally "spell it out". If it can't be done, then that's OK ... but it
looks like it CAN, I'm just not picking up what needs to be done to get
there. Many thanks for your patience.
 
S

Steve Schapel

S

SA

Vicki:

The free downloadable version of Cute PDF doesn't support automating output
to a file, in other words, you'll always be prompted for a file name and
require user interaction if you use that PDF printer driver, so automating
creating PDF files and e-mailing them is virtually impossible.

That said, there are very good and very inexpensive PDF printer drivers
(e.g. Win2PDF (www.daneprairie.com), Zeon's DocuCom PDF Printer
(www.pdfWizard.com) that do a great job and where you can both automate
output (to create a file without user interaction) and then combine that
with sending that document in an e-mail.

Our PDF and Mail Library for Access supports numerous PDF printers and
allows you to automate the whole process using a modest amount of Visual
Basic (macros can't do this.) You'll find this in the developer tools
section of our web site.
 
V

VickiS

Thanks to both of you for your response. I really don't want to buy something
that I wouldn't use that much ... I can preview the report and then go to
'File' and 'Print' and then point the printer to the CutePDF Writer printer
in the dropdown box. Not that hard - I was just looking for a way to automate
it. Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top