hyperlink with cell info in subject line

A

ajr

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.

=hyperlink(mailto:[email protected]?subject=I%20want
%20tickets&body=Hi,%20I%20want%20the%20tickets%20for%20(enter%20date
%20here,"test")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top