ExcelBanter - SendMail as pdf

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SendMail as pdf (https://www.excelbanter.com/excel-programming/427699-sendmail-pdf.html)

Is there a way that I can use sendmail to send a pdf of the print area?

I have 40 spreadsheets in a workbook but only the print area in each
worksheet is the sales dashboard. The rest of each worksheet goes to
creating the output in the dashboard area.

Hi there;
See Ron de Bruin's website about e-mailing with Excel.

http://www.rondebruin.nl/sendmail.htm

--
--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--
"ogerriz" wrote in message
...
Is there a way that I can use sendmail to send a pdf of the print area?

I have 40 spreadsheets in a workbook but only the print area in each
worksheet is the sales dashboard. The rest of each worksheet goes to
creating the output in the dashboard area.