Google Spreadsheet HyperLink to Send Email

Question:

I have email addresses in a google spreadsheet. How can I click on each one to start an email to that person.

Solution:

Use =hyperlink formula to achieve to create a link on a cell and then by clicking on that link you will get to the new webpage with "To" field set with the email address provided in the function..

Have a look at the following animated screenshot of my Spreadsheet:

I have the following formula in Cell A1:

=hyperlink("mailto:kishan.pionero@gmail.com";"Kishan")

Note: "mailto:" must be added as a prefix to the email address, as you can see in the above function.

And to have the Subject field populated with it, try the following formula:

=hyperlink("mailto:kishan.pionero@gmail.com?subject=I like iGoogleDrive";"Send email to Kishan")

And if you also want Body to be also populated with it then try:

=hyperlink("mailto:kishan.pionero@gmail.com?subject=I like iGoogleDrive&body=iGoogleDrive.blogspot.com is one of the best Blog";"Send email to Kishan")

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

Thanks,

Kishan.

iGoogleDrive