newsletter to dealer

[100asa]

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

[Chuckl]

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.

[100asa]

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!

[100asa]

It's strange, but I see the number of received in the dropdown list, but them don't receive the newsletter.