View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin[_21_] Martin[_21_] is offline
external usenet poster
 
Posts: 50
Default 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