EMAIL
Description
Converts an email address into a clickable
mailto
link. Optionally, you can
insert email details such as email content and recipients.
Syntax
EMAIL(
email
, [
text
], [
cc
], [
bcc
], [
subject
], [
body
])
- email: The email address.
- text: The clickable text to be displayed in the cell. If you don't include this argument, the function uses the email address to generate the clickable text.
- cc: The copy list of recipients for the email. To separate multiple email addresses, use a character that your email client supports.
- bcc: The blind copy list of recipients for the email. To separate multiple email addresses, use a character that your email client supports.
- subject: The subject of the email.
- body: The body of the email.
Example
Formula | Result |
|---|---|
=EMAIL( "william.davis@workday.com", "Will Davis" ) | Will Davis (as a clickable link) |