Email macro with no email addresses

I have created a logbook at work using Excel 2003. Someone asked me if it would be possible to have a macro that allows a single worksheet to get embedded in an email, but leave the email open so names/addresses can be added. I've seen some of the macros for emails out there, but they all specify an address. Is there a way to run these without specifying an address? Or having the macro stop with Outlook open so addresses can be added? We use Exchange server with Outlook.

Thanks a bunch.

Hello!

Yes, you can do that. I don't know what year excel you're working with (I work with 2000) and this code works with mine. You'll have to tweak it, but it gives you a start!

Please Login or Register  to view this content.

you may want to check out this site
http://www.erlandsendata.no/english/index.php
as it's where I learned my OLE and got this code!