Copying worksheets into separate workbook and emailing separately.
 

I have a company that wants me to mail 18 different worksheets into 18
different emails, with different subject lines. Any ideas?

Copying worksheets into separate workbook and emailing separately.
 

FYI , EXCEL 2002, OUTLOOK 2002. Thanks

"mistlecane" wrote:

I have a company that wants me to mail 18 different worksheets into 18
different emails, with different subject lines. Any ideas?

Copying worksheets into separate workbook and emailing separately.
 

See
http://www.rondebruin.nl/mail/templates.htm

Or only code
http://www.rondebruin.nl/mail/folder2/mail5.htm



--

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


"mistlecane" wrote in message ...
FYI , EXCEL 2002, OUTLOOK 2002. Thanks

"mistlecane" wrote:

I have a company that wants me to mail 18 different worksheets into 18
different emails, with different subject lines. Any ideas?

Copying worksheets into separate workbook and emailing separat
 

Ron,
I implemented your code and it works beautifully!! Thanks

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/mail/templates.htm

Or only code
http://www.rondebruin.nl/mail/folder2/mail5.htm



--

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


"mistlecane" wrote in message ...
FYI , EXCEL 2002, OUTLOOK 2002. Thanks

"mistlecane" wrote:

I have a company that wants me to mail 18 different worksheets into 18
different emails, with different subject lines. Any ideas?