Automatic Email Generation

[wbowie]

I would be most appreciative if someone could tell me if
Excel is capable of automatically creating PDFs and
distributing via Outlook?

In other words...
1) Update excel file
2) Save PDF
3) Outlook email kicks off
4) Attach PDF to email
5) Send to distribution

 

[Paul Falla]

This is possible, but only through coding it in VBA and
attaching the code to a button.
Also, you need to have Acrobat Distiller installed.

If you require further help with the code, please post
back.

Hope this helps

Paul Falla