Sending mail from excel

[Fletch]

I have a worksheet that data gets entered into. I am
wanting some coding to attach to a button that when
pressed will open up a "new memo" in Lotus R5 that we
use. It will also preferably already have an address
entered in the to box.

Please Help

 

[Stephen Bye]

How about the function:
=HYPERLINK("mailto:"&B1,"send e-mail")
where B1 is the cell containing the e-mail address

 

[Guest]

Thanks that looks like it is on the right lines but it
comes up with a message saying "You cannot add a directory
to your workspace". Any suggestions?

Thanks

Fletch