I am working on an automation script that sends out emails to let employees know they have received a paycheck.
I find I have a few employees with embedded apostrophes.
This errors in the automation script when setting the email to the local variable. I have tried escaping it with another apostrophe, surrounding it in single quotes and surrounding in double quotes. None work.
How do I support emailing to this type of email address?