Was there a change in TDP 3.3 on how it handles variables for the e-mail address in an automation script?
In TDA 3.1 and earlier I had to put “quotes” around the e-mail address in my sql statement for the list of values to send the e-mailed document to:
SELECT COMM_METHOD_TAB.IDENTITY Supplier,
FROM MINC1APP.COMM_METHOD_TAB COMM_METHOD_TAB
ON (COMM_METHOD_TAB.IDENTITY = SUPPLIER_INFO_TAB.SUPPLIER_ID)
WHERE (COMM_METHOD_TAB.“NAME” = ‘OPENORDER’)
ORDER BY 1
Then the e-mail address would format correctly when sent out. I just discovered that none of our e-mails are going out from scripts using bind variables for the e-mail address. And when selecting forward on an e-mail that was supose to go out I get an address that looks like this: email@example.com <"> and it fails. But when removing the quotes from the sql statement I get an even more weird e-mail address.
Anyone have this issue?