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

Problem: The problem with this is the average size of these copies i
roughly 130kb. If I convert the summary page (which is all that need
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 PD
(we use both) have "Convert to PDF & Email" buttons that are on th
toolbar, however, since these are add-ons, they aren't in the VBA hel
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 an
then send the output as an attachment?

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

--
wilro8
-----------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...fo&userid=2693
View this thread: http://www.excelforum.com/showthread.php?threadid=55670