"TF- Advanced Email and SMS Task 2020.18.1" truncating email address when having a apostrophe sign

79 Views Asked by At

In my SSIS package, I have "TF- Advanced Email and SMS Task 2020.18.1" controller. So I have a recipient that his email address is like below

Test.T'[email protected]

So when I'm sending email to above address, the "TF- Advanced Email and SMS Task 2020.18.1" controller truncate the email address before apostrophe (') and sending

So currently it is sending email to this kind of address

[email protected]

So it is truncating the first part of the email address before apostrophe sign. Really appreciate, if anyone can help me on this.

----Update---- I guess some work around need to do here. What I tried is manipulating the email address before passing to "TF-Advanced Email and SMS" controller.

This is the flow, currently I'm executing. In c# script I tied to manipulate the "To" address before sending

Also I tried something like this

string ToEmail = "{Test.T'Est}"+"@testdomain.com";
ToEmail.replace('{',' ');
ToEmail.replace('}',''\');
''''

Then when I send a email through "TF-Advance Email.." controller, it will send a email to below address.

Test.T'Est'@testdomain.com

But the additional apostrophe will be there Also, **it cannot replace with current apostrophe**, like this ("Test.T{'}[email protected]" - this is not working)

So still **did not find any clue** on this.

 
0

There are 0 best solutions below