How to create mailto links

You can easily create a mailto from columns of to, cc, subject and body. For example to convert:

to subject cc body hello hello world! hello line break


By using Decode to URL encode the subject and body and Substitute to construct the mailto syntax.


mailto.transform (2.7 KB)