How can an email address containing a special character (in this case, an ampersand) be added to a RAP/SSRS/SQL Server Reporting Services Subscription via the SSRS Front-End please?
Frontend: Open RAP > Right Click the relevant Report > select Manage > select Subscriptions > click Edit for the existing subscription.
I've tried the following in the email address:
using the & = no error occurs, but no email is sent/received
using %26 instead of the & = Failure sending mail: Syntax error in parameters or arguments. The server response was: #5.1.3 Invalid character ('%') in username.Mail will not be resent.
double quotes around entire email address ("...") = Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.
using \& instead of & = Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.