I have a spreadsheet that has a list of dates in colum A. I would
like to click a hyperlink to create an email with my address as the
send to and the date in the subject line. I would then send this
spreadsheet to multiple people and have them click the hyperlink to
send me an email with that date in the subject line, can you help?

I have tried the following, but the info from the cell does not want
to populate.

?subject=I%20 want
%20tickets&body=Hi,%20I%20want%20the%20tickets%20f or%20(enter%20date
%20here,"test")