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.