View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chad chad is offline
external usenet poster
 
Posts: 273
Default Excel mailto: with Row Content?

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:
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?