Excel mailto: with Row Content?

[Chad]

I'm using Excel 2007 (office SP1)

I'd like to create a bullet hyperlink in a column, per row that has a
mailto: hyperlink. I know the basic of this is obvious and feature right
there. But, I'd like that bullet link in that row to also include the content
of another column in the same row (same idea for next bullet in next row). I
want something like this:

mailto: (e-mail address removed)
subject: reactivate "server-label" ('server label' is the content that would
be taken automatically from the specified other column, same row.
body: reactivate "server-label"

How can I achieve this?

 

[Sheeloo]

Use
=HYPERLINK("mailto:[email protected]?subject=reactivate "&J1&"&body=reactivate
"&J1,"Click to send mail")



Replace J1 with the cell you want to pick content from...