Re: [Mickaboo Techlist] [Ticket#0132789] You got follow up! (Thanks for contact [...])

Pam: I have to apologize here, because I've made an incredibly braindead and stupid mistake. When I formatted your list of ZIP codes into SQL queries to get a list of emails in them, I ran them through a loop to generate the SQL queries. I forgot, of course, to include the red-flag checks and donotcontact checks in the queries, so I generated a big list of people that includes our red-flagged folks and opt-out folks. Nothing to do here but mea culpa, and fix the queries so the list gets generated right for next time. For the tech teams' information, the current query "SELECT EmailAddress FROM owner WHERE OwnerPostcode="94103";" should actually read "SELECT EmailAddress FROM owner WHERE OwnerPostcode="94103" AND IsBanned=\"0\" AND Comments NOT LIKE \"\%donotcontact\%\";" Sigh. It's one of those days. :P Mickaboo Workflow System wrote:

Hi Admin,

you got a follow up!

Pamela Lee wrote:

<snip>

...

More information about the SF bay area bulk emailing - psychomamma@gmail.com is red-flagged in ASM, and apparently received our emailing. Another thing to look for in our query criteria.

Thanks.

- Pam

--- On Fri, 8/21/09, Mickaboo Tech Team wrote:

From: Mickaboo Tech Team Subject: [Ticket#0132789] Thanks for contacting the Mickaboo Tech Team! To: "Pamela Lee" Date: Friday, August 21, 2009, 6:25 PM

Hello! We have received your email regarding review criteria for bulk

<snip>

https://mickaboo.org/otrs/index.pl?Action=AgentZoom&TicketID=33209

Your OTRS Notification Master