Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › emailing customers PS3

emailing customers PS3

Thread began 5/20/2010 4:22 pm by ken.parish391000 | Last modified 5/20/2010 6:11 pm by Jimmy Wu | 768 views | 1 replies |

5/20/2010 4:22 pm | #1 ken.parish391000

emailing customers PS3

I have the registered customers but how do I convert/extract details to email them all directly without looking at each individual record?

Can I download a full listing in whatever format I require. Bear in mind I am a novice

5/20/2010 6:11 pm | #2 Jimmy Wu

Currently, there is no built in functionality to email to all customers or get a list of all the customers email addresses so you can email them. If you have access to your database I can give you a query to get all the email addresses and email them then.

You would want to go to the database you have for PowerStore and run this query:
SELECT UserFirstName, UserLastName, UserEmail FROM `ps3_users` WHERE 1

Note: The user may not have filled in a first name and last name in their profile so some of the results for that will be null.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.