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" <wilro85.2a4w8z_1151534703.9091@excelforum-nospam.com> wrote in
message news:wilro85.2a4w8z_1151534703.9091@excelforum-nospam.com...
>
> 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
>