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?