Hi everyone,
I'm trying to create a custom task in order so send email 15 days before account expiration.
The account is collected from AD with its attribute accountExpires.
In my custom task all I do is
- select accounts from PV_ACCOUNT with EXPIRATION_DATE in 15 days and look for their email address in PV_USERS tables
- send email to all the email address found in BCC
My problem is to understand if passing a workflow variable in BCC it's ok.
These are my workflow variables:
And this is how I configured the send email node
Do you know if this is ok?
Unfortunately when I run the task in my demo environment there are no email log.
Thanks
Marta
Make sure the following points are met with your tests:
1. Populate the "Outbound Server's hostname/IP" field, even with any dummy input for test purposes in the Admin > Email > Settings page. You can also disable sending of emails right at the end of the settings page if you put a valid outbound email server and do not want IG&L to send emails using it (when email is sent, it will still show under the Admin > Email > Logs tab even with the "disable sending of emails" set to "Yes").
2. A "To" recipient populated even something dummy for test purposes in the email node
3. A "From" field populated even something dummy for test purposes in the email node. I've set it as the outbound address.
4. Populate the "Subject" field even something dummy for test purposes in the email node
5. Populate the "Body" field even something dummy for test purposes in the email node
Your example here worked for me after making sure all the above were populated (same email node config at To & BCC). I used the following dummy query to test which should simulate your same SQL select query structure; returning 1 email per row in the result:
Then I fed the "email" workflow variable to the email node like you have in your screenshot and it showed on the email log.