E-Mail "Opted Out" list needed

[nhellwig]

Is it possible to run a list of all of our leads that have "Opted Out" of our e-mail campaigns? I haven't found a way to search on this criteria and their e-mail addresses do not display with a strike through in list view. Thanks in advance for any assistance.

[datasponge]

I don't know of a way to do this search within Sugar.

But there are add-on reporting tools that can do it, like Kinamu Reporter or Zucker Reports.

Or you can do it directly in your database. In mysql you can run queries through the server console or use mysql admin, phpadmin or other tools like that. But you'd have to know a little about queries and the Sugar table structure.

For example, from the mysql server console, you basically can just type:

SELECT * FROM email_addresses WHERE optin = 1;

and it will list all entries in the table including the email address. From there you can look up Contacts by the email address and see if it appears correctly in Sugar.

If you don't know how to do this, just post what database you are using, whether you get to the server console or terminal window and whether you have any database admin tools like mysql admin and we can try to help direct you.

Phil