Calculated to e-mail
In a script i loop through all records and depending on the text in a certain field another script is called and performed to send an e-mail with a fixed text plus variable text extracted from certain fields. This works fine. The problem i have is that depending on the content of a field "department", the recipient of the e-mail should be different. I tried to have the TO field as a calculation:
This does not seem to work. What am i missing ?
i am using FM12 advanced server and mails are sent via smtp.