Presto, it works! Thank you, Conan!

I had already tried the ampersand and cell id but apparently didn't
configure it correctly. Excel's help for HYPERLINK should include this info,
because I can't be the only one who wants to do this.

"Conan Kelly" wrote:

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