I'm writing a gmailApp script that looks at a spreadsheet and will send some emails out based on a sheet of names and emails. I'm trying to make it as user-friendly as possible. I'm aware I can use the option parameter and use htmlBody to send an email with formatting but I'd prefer the end-user not to have to enter the script to update the body if they want a link or to bold something.
I have a cell for the email body like this but can't seem to find the function to capture the formatting.
Dear {{name}},
Something something test. Link
Thanks
And when I use getValue or getDisplayValue it just returns
Dear {{name}}, Something something test. Link Thanks
No new lines, no links or formatting, etc. Any advice would be greatly appreciated. Thanks