emailing indivual worksheets

[Stephanie]

I have a workbook with several worksheets. I need to
email each indivual worksheet to different addresses as
attachments. Currently I can only forward as part of the
email message and the worksheet is to large to view or
print out.

Thanks in advance for you assistance
Stephanie

 

[Ron de Bruin]

Hi Stephanie

Check out my site for different examples
http://www.rondebruin.nl/sendmail.htm

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/sendmail.htm#Sheet

 

[Norman Harker]

Hi Stephanie!

See:
Ron de Bruin:
http://www.rondebruin.nl/sendmail.htm#every

Whilst there, you should download his SendMail Addin and User Guide as
it's a great utility for emailing Excel from within Excel.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[guilbj2]

Hi Stephanie,

Is there an issue with everyone seeing all of the data ? If not, yo
could just attach the Excel file rather than pasting it into you
e-mail

 

[mzehr]

Hi,
Try

Email Selection http://www.rondebruin.nl/sendmail.htm -
selection
Email Sheets http://www.rondebruin.nl/sendmail-addin.htm

HTH