Send Email To Customers

[FatGuyinAZ]

Thank you. I will do some searching and reading on the subject.

[FatGuyinAZ]

If anyone is interested, I was able to set this up. If you have a special Price Group and you want to be able to send emails to people ONLY in that group. The following I ran from Admin->Tools->Install SQL Patches. Mine in this example is called Monthly.

INSERT INTO query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES ('email,newsletters', 'Monthly Group Customers', 'Customers that are all part of the Monthly price group', 'select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_group_pricing = ''1''', '');

You would change wording of your group (query_name), drop-down menu wording (query_description) and the query itself finds my only price group. If you have more then one, make sure to define which you want in customers_group_pricing = 1.

Works perfect. Thank you DrByte for pointing me in the right direction.

[TheGardenBath]

Ah, that's just what I was searching for! Brilliant - worked like a charm!

[alabasta79]

If anyone is interested, I was able to set this up. If you have a special Price Group and you want to be able to send emails to people ONLY in that group. The following I ran from Admin->Tools->Install SQL Patches. Mine in this example is called Monthly.

INSERT INTO query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES ('email,newsletters', 'Monthly Group Customers', 'Customers that are all part of the Monthly price group', 'select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_group_pricing = ''1''', '');

You would change wording of your group (query_name), drop-down menu wording (query_description) and the query itself finds my only price group. If you have more then one, make sure to define which you want in customers_group_pricing = 1.

Works perfect. Thank you DrByte for pointing me in the right direction.

Refering to your customers_group_pricing = ''1'' . The number 1 there refer to group id, is it? If my customer group id is 2, so i must put 2... correct or not?