Distributing Excel reports

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

We have individual Excel sheets for each employee that we update monthly and
e-mail them individually to each person. Is there a way to automate the
process of e-mailing them?
 
Thanks. Is there a way to only e-mail certain cells within the sheet? Or to
send as a PDF? I have a couple of columns that are used for calculations,
and I don't include them in the print area. I have the print area sent, and
I print as a a PDF and e-mail to each person.
 
Hi Jennifer

I have code to do this on my site
http://www.rondebruin.nl/mail/folder2/mail4.htm

Or
http://www.rondebruin.nl/mail/folder1/mail4.htm


There is PDF code for Excel 2007 here
http://www.rondebruin.nl/pdf.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Jennifer said:
Thanks. Is there a way to only e-mail certain cells within the sheet? Or to
send as a PDF? I have a couple of columns that are used for calculations,
and I don't include them in the print area. I have the print area sent, and
I print as a a PDF and e-mail to each person.
Click to expand...
 
Back
Top