list opted outs

[ysh]

Hi

How can I list targets, or even leads & contacts, for whom the email
address is registered as 'opted out'

I'm going to have to send them an email of apology, because it seems
that they are still receiving emails sent by new campaigns.

If I were in their place, it would drive me nuts if I were still still receiving
emails even though I had opted out !

Thanks for your help

yann

[blackradius]

I'm not sure you can from within SugarCRM itself. The easiest way for me was through a sql query.

SELECT prospects.first_name, prospects.last_name, email_addresses.email_address, email_addresses.opt_out
FROM prospects
JOIN email_addr_bean_rel ON prospects.id = email_addr_bean_rel.bean_id
JOIN email_addresses ON email_addr_bean_rel.email_address_id = email_addresses.id
WHERE email_addresses.opt_out = '1'
ORDER BY last_name

[ysh]

Hi BR

Thanks for the info
I might try to tackle this using Talend Open Studio

yann