Zen Cart Logo
Forums / General Questions / newsletter to dealer

newsletter to dealer

Locked

Views: 1,049

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
27 Apr 2007, 10:36 AM
#2
chuckl avatar

chuckl

Totally Zenned

Join Date:
Nov 2006
Location:
Papworth, Cambridgeshire, UK
Posts:
717
Plugin Contributions:
0

Re: newsletter to dealer

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.

3 May 2007, 1:12 PM
#3
100asa avatar

100asa

Totally Zenned

Join Date:
Oct 2006
Location:
Italy
Posts:
636
Plugin Contributions:
0

Re: newsletter to dealer

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!

3 May 2007, 4:20 PM
#4
100asa avatar

100asa

Totally Zenned

Join Date:
Oct 2006
Location:
Italy
Posts:
636
Plugin Contributions:
0

Re: newsletter to dealer

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