I've this field customers_whole in customers table, where field is 1 when i able this customer as dealer ( http://www.zen-cart.com/index.php?ma...roducts_id=166)
I want send newsletter only to whole customers: what can I do?
Thank's in advance
I've this field customers_whole in customers table, where field is 1 when i able this customer as dealer ( http://www.zen-cart.com/index.php?ma...roducts_id=166)
I want send newsletter only to whole customers: what can I do?
Thank's in advance
The SQL queries to select the audience for a newsletter or email are stored in the database in the query_builder table.
The queries are typically fairly simple, like this
select customers_firstname, customers_lastname,
customers_email_address from TABLE_CUSTOMERS where customers_newsletter =
'1'
You would need to create and insert a new entry in the table that included your customers_whole in the query, as well as 'newsletters' under the query category.
Great!
I've just insert the sql query in database, and I'm trying to send newsletter only to specified customers....
Thank's a lot... I'll tell you if it works well!
It's strange, but I see the number of received in the dropdown list, but them don't receive the newsletter.