For lotus code see

Sending mail from Lotus Notes (XL-Dennis)
http://www.excelkb.com/?cNode=1X5M7A



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"igbert" wrote in message ...

Hyperlink is able to send email with cell content in the Subject line.

My Case

=HYPERLINK("mailto:Collections_Admin?subject=Overd ue Balance " & "_"&
'Sheet1'!G15,"Email To Collection Agency")

Sheet1G15 has the data I want to show in the subject line.

Is it possible to do this with Macros? I am using Lotus Notes for email.

Thanks

Igbert