Results 1 to 2 of 2
  1. #1

    Default Subscribers not showing under Newsletter dropdown

    The Newsletter drop down box includes the ability to send email 'to all Newsletter subscribers'. I imported 300+ subscribers, and they are all located under the table 'subscribers'. Currently it (the drop down menu) seems to be pulling the information from the 'customers' table, but not from the subscribers table.
    For example I only have (39) as the number of All Newsletter Subscribers. The number should actually be over 400.

    Basically I don't think that the Newsletter Manager is looking at the 'Subscribers' table correctly, or at all.

  2. #2

    Default Re: Subscribers not showing under Newsletter dropdown

    Reply to my own question:

    basically I needed the query builder to suck up the info from the subscriptions table, I found the way to do this by looking at some other post variations.

    answer:

    Code:
    INSERT INTO Z_query_builder (query_id , query_category , query_name , query_description , query_string ) VALUES('', 'email,newsletters', 'ALL subscribers', 'email all them subscribers', 'select email_address from TABLE_SUBSCRIBERS order by email_address')

 

 

Similar Threads

  1. Newsletter Subscribers?
    By twins225 in forum General Questions
    Replies: 1
    Last Post: 20 Oct 2010, 09:38 PM
  2. Newsletter Subscribers
    By My Digital Cafe in forum General Questions
    Replies: 3
    Last Post: 27 Mar 2009, 03:45 AM
  3. Newsletter Subscribers Help
    By farrahscreations in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 29 May 2008, 08:18 AM
  4. View Newsletter Subscribers??
    By Kokopelli in forum General Questions
    Replies: 2
    Last Post: 7 Sep 2007, 05:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR