Macro to email PDF file

[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.

 

[Steve Schapel]

Vicki,

No, you will not be able to do this with a macro. If you use Outlook as
your email client, you would be able to use Automation in a VBA
procedure, in order to attach the PDF file to an email. Unfortunately
this is not a simple matter that can get a simple answer. There is some
infromation about this here...
http://www.granite.ab.ca/access/email/reportsasattachments.htm
http://www.granite.ab.ca/access/pdffiles.htm
http://support.microsoft.com/?id=161088

 

[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.

 

[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.