Hi,

I'm trying to create a button on a worksheet that when
clicked will create a new Outlook message with the Send
To,Subject and Message body already completed and will
then automatically send the message. The only way I can
find of doing this is via the Workbook.SendMail command
but although this sends an e-mail it also sends the xls
file which I don't want to be sent.

Are there any other ways of doing this? If I had Visual
Basic v6 installed would it give me the capability via
MAPI commands but still allow end-users with a standard
Excel97 installation to use the facility?

Any help greatly appreciated.