Views:

When attempting to email a batch of invoices the client received an unknown error. This can occur when the email reply to address in the Message ID is set to the Exchange name instead of the email address. This writes it to the table as a string such as '/o=ExchangeLabs/ou=Exchange Administrative Group (XXXXXXXXXXXXXXXXXx)/cn=Recipients/' This doesn't work when emailing out. The table needs to store the email address as an email address. To resolve this I ran an update to set it to be an email address.

This script updates any that are not blank to be the actual email address.

update SY04901 set EmailReplyToAddress='bill@contesco.com' where CAST (EmailReplyToAddress as VARCHAR)<>''