OTTO

I think you should wander over to Ron de Bruin's site and look at the code and
add-in he has for sending mail.

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

The SENDMAIL add-in is free and easily set up.

Gord Dibben Excel MVP

On Fri, 4 Jun 2004 15:52:30 -0700, "OTTO"
wrote:

Hello,

I have a routine that creates a number of individual
workbooks that need to be sent to different recipients.
Ideally, I'd like to append some new code to the existing
that simply sends the open workbook to an e-mail address
in a worksheet cell somewhere in that open workbook --
this address will change based on a lookup embedded
elsewhere.

So again, send open workbook to a recipient whose name
appears in a certain cell... What do you all think?!

THANX