boustrophedon,

Use the HYPERLINK() function in your formula:

?subject=S tatus Change " &
Data!A1,"Test Email")

You can also concatenate to create the email address if the info is in cells
on the worksheet.

HTH,

Conan


"boustrophedon" wrote in message
...
I want to make an email hyperlink that includes text and a cell value in
the
subject line, like this: Status Change [Data!A1] .

Is there an easy way to do this or do I have to VB it?