Hello everyone

Please can someone help me. How can I create a "link" on a spreadsheet so that when I click on it it opens up an email to a certain email? and would also be possible for the information on that spreadsheet to be transposed to the email?

Thanks again for your help.