Home > Forum > Actions > Send a custom email - Selecting addresses by SQL/CAML query

Send a custom email - Selecting addresses by SQL/CAML query
0

28.05.2023
13:15
AndreeLl B

Hi,

I want to use the action - Send a custom email and get email addresses from a Dictionary.
I checked "Selecting addresses by SQL/CAML query" and as Data source: i chose my Dictionary
When i write a SQL query it doesn't filter. It shows all columns and rows.

In my workflow i have a choice field Vendor name (from a Dictionary - it contains Vendor Name, Vendor Email). When i pick that vendor, i want to send an email to that vendor.

Can you help? Thanks.

Reply  
29.05.2023
18:08
Andreia Correia
In reply to: AndreeLl B

Can you help giving an example of yours? thanks

Hi,

I'm assuming you're writing the email in a column on your field, if not, you need to change your field to picker option and in the config window, copy the email field into a form field in the workflow.

My query is getting users from a item list as an attendee list:

select distinct FORM FIELD IN ITEM LIST from WFElementDetails
where DET_WFDID={WFD_ID} and DET_WFCONID= ID of the ITEM LIST

Hope it helps

Reply  
Solution (1) Helpful (0) Wrong answer (0)
Menu
Babinskiego 69
30-393 Krakow, Poland
office@webcon.com
+48 12 443 13 90