Wilro:

Stop by our web and look in the MS Excel developer tools area and you'll
find our XL PDF Wizard add in. It allows you to use any one of 10 different
PDF printer drivers (including Acrobat and some other very in-expensive
drivers) to automate create of PDF documents (including bookmarks etc.) from
XL worksheets or workbooks. It also allows you to merge in Word documents
(with bookmarks,) or external PDF files. You can also reference the Add
In in any workbook and use its properties and methods to create your own PDF
creation jobs. So yes, it can be done.

Hope this helps
--
SA
ACG Soft
http://www.groupacg.com


"wilro85" wrote in
message ...

I'm re-vamping a form that I made last year. Currently the function I'm
evalutating works in the following way. Upon confirmation that all the
entered information is complete, copies are e-mailed to the relivant
project leaders.

Problem: The problem with this is the average size of these copies is
roughly 130kb. If I convert the summary page (which is all that needs
to be sent out) into a PDF, the file size goes down to about 8kb.

Why I think this should be possible. Both Adobe Acrobat and Nitro PDF
(we use both) have "Convert to PDF & Email" buttons that are on the
toolbar, however, since these are add-ons, they aren't in the VBA help
file, and we all know how good the support is that Adobe offers.

If nothing else, is it possible for me to do a print macro using and
then send the output as an attachment?

Does anyone have any ideas on how to do what I'm trying to do?


--
wilro85
------------------------------------------------------------------------
wilro85's Profile:
http://www.excelforum.com/member.php...o&userid=26935
View this thread: http://www.excelforum.com/showthread...hreadid=556708