Create an e-mail with recipient, subject and text

Dear All,

Excel 2000.

I have tried to follow previous questions posted but did not really get there.

I want to prepare an e-mail from Excel with the following:
* e-mail address of the recipient
* subject taken from a cell in a particular sheet such as cell (A1)
* text taken from a range in a particular sheet such as range (A3:J97)
* do not want the e-mail to be sent automatically
* do not want an attachment

Any help much appreciated.

--
Regards,

Martin

..

Hi damorrison,

Sorry, but your reply is empty.

--
Regards,

Martin


"damorrison" wrote:

> ..
>
>