Sending mail from excel

  • Thread starter Thread starter Fletch
  • Start date Start date
F

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
 
How about the function:
=HYPERLINK("mailto:"&B1,"send e-mail")
where B1 is the cell containing the e-mail address
 
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
 
Back
Top