Send Automation Email with embedded apostrophe

Toad Data Point
1

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'bryan.nicole@SomeCompany.com

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?

Embedded Apostrophe
Embedded Apostrophe1070×383 14.8 KB

2

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.

3

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.