Send Automation Email with embedded apostrophe

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.

IE: o'

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?

Couple things come to mind. Have you tried escaping the single quote with backslash?

Otherwise, most companies can assign employees an alias/alternate e-mail address. Check with your email admin.

I tried escaping it in the automation script and that didn't work. But I was able to escape it in sql and that seems to do the trick. Thanks.