How would I use this and reference an email address stored on the sheet?

"Conan Kelly" wrote:

boustrophedon,

Sure it is possible.

If you noticed in the "mailto:" link, the first part was the email address,
then a question mark, then "subject=text to be displayed in subject line".

Then to add body text, add an ampersand (&) and "body=canned text for body".

It may or may not be necessary to replace spaces with "%20" (only the spaces
that are between quotes...any that are outside of quotes can remain spaces).
I'm not sure. Mess with it to see what will work.

Using the formula I originally posted:

?subject=S tatus%20Change%20" &
Data!A1 & "&body=Canned%20text%20for%20body","Test Email")

If you want, you can put cell references in your formula to insert the body
text, the "Friendly_name", etc...

(body text is in cell C5 of the same sheet the formula is being used on)
?subject=S tatus%20Change%20" &
Data!A1 & "&body=" & C5,"Test Email")

HTH,

Conan





"boustrophedon" wrote in message
...
Conan (or someone else), let me push this one step further. Can I include
some "canned" text for the body of the email in that same HYPERLINK
command?

I know, I know ... feature creep. ;)