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

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

0

AndreeLl B

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.

29.05.2023

11:36

Hi,

I have you tried to also select the form type?
Can you paste your SQL?

Solution (0)

Helpful (0)

Wrong answer (0)

AndreeLl B

29.05.2023

14:46

AndreeLl B

In reply to: Andreia Correia

Hi,

I have you tried to also select the form type?
Can you paste your SQL?

Can you help giving an example of yours? thanks

Solution (0)

Helpful (0)

Wrong answer (0)

29.05.2023

18:08

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

Solution (1)

Helpful (0)

Wrong answer (0)

AndreeLl B

29.05.2023

19:16

AndreeLl B

In reply to: Andreia Correia

Thank you! Solved.

Solution (0)

Helpful (0)

Wrong answer (0)