Hey all,
I need to pull the email addresses for customers in a few specific states as we have a promotion that we want to inform them about that is only available ina few states. This is not something I have to do often so I dont mind running a query in phpMyAdmin. I am not too familiar with SQL and did notice that the customers email address is in one table (zen_customers) while their email address is in (zen_address_book).
Has anyone done this before and can anyone help me with the syntax or know if a way this can be done within the zencart admin? We do have the newsletter export mod so we can export all our customers but I do not belive there is a way to filter by states.
I have been playing with it but cant get it to work. I had something like this but it keeps pulling every cusomer not just the ones in the states I want:
SELECT `customers_email_address` FROM `zen_customers`, zen_address_book WHERE `entry_state` = "MA" or "NH" or "RI" or "ME" or "VT"
Bookmarks