Send active workbook as attachment

O

OTTO

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
 
Top