Break line as next line google sheet mail
You want to break a line as the next line in a Google Sheets email. Here are a few ways to do that:
Method 1: Using the
character
You can use the
character to insert a line break in your email. Here's an example:
=MAIL("Recipient's Email", "Subject", "Hello! This is the next line.")
Method 2: Using the CHAR(10)
function
Another way to insert a line break is by using the CHAR(10)
function. Here's an example:
=MAIL("Recipient's Email", "Subject", "Hello!"&CHAR(10)&"This is the next line.")
Method 3: Using the LINEFEED
function
Google Sheets also has a LINEFEED
function that you can use to insert a line break. Here's an example:
=MAIL("Recipient's Email", "Subject", "Hello!"&LINEFEED&"This is the next line.")
In all cases, the line break will be inserted in the email body, and the recipient will see the text formatted with a new line.
Note: Make sure to enclose the email body in quotes and use the MAIL
function to send the email.