Solved SEND EMAIL WITH A QUERY, TO A GROUP OF RECIPIENTS (1 Viewer)

[georg0307]

Dear All,

I'd like to automatically send an Email, to a group of recipients, resulting from a query where, depending on the selected anomaly, only the correct recipients are filtered as per the "EMAILS" table.

I put some vba code to a button but something get wrong, could you please hep me?

In attachment the file.

Georg.

 

[arnelgp]

firstly, Anomalie field should be short text.
you need to use an Unbound form.
see Form1 on the sample.

 

[georg0307]

Hi, many thanks. Seems work.

Best regards,

Georg