Thanks Ron. This is great! ~Xavier

"Ron Coderre" wrote:

See this website for the vba code:

Q10081 - HOWTO: Send data from a range as part of an e-mail's body
http://www.excelkb.com/article.aspx?...1&cNode=1X5M7A

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Xavier" wrote:

i want to have a control button which would send an email to a specified
e-mail address . The goal would be be able to click a button which sends the
contents of a cell as the subject line from my work e-mail address (which I
can only access using Lotus Notes) to some outgoing email address.

Normally, I just copy the contents of the cell, log into my lotus notes
email account, paste onto the subject line, and send an e-mail. But I would
like to automate this proccess using some sort of excel programming. Would
appreciate ideas. Xavier.