You can easily create a mailto from columns of to, cc, subject and body. For example to convert:
| to | subject | cc | body |
|---|---|---|---|
| a@email.com | hello | b@mail.com | hello world! |
| c@email.com | hello | d@mail.com | line break |
To:
By using Decode to URL encode the subject and body and Substitute to construct the mailto syntax.
Example:
mailto.transform (2.7 KB)
