MyBB Community Forums

Full Version: Retrieving Email Address with Names
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Since default Mass Mail option does not support Images and good customizations, I thought of using external newsletter service.

They usually ask for CSV or Tab Delimeted .txt file.

So I need a database query by which I can save into external file. Hope I am clear here.

TIA Smile
SELECT email , username
FROM mybb_users
WHERE email <> ''
ORDER BY regdate ASC

use firefox with table2clipboard add-on to copy & use the results
Thank you for replying Smile

The phplist says like this :

Quote:You can import a list of email addresses and other user data from a CSV or Tab delimited file. Most database and spreadheet programs can produce a Comma delimited or Tab delimited text file. It is recommended to use "tab" instead of "comma" as a field delimiter, because your data is not likely to contain a TAB, and will therefore cause less trouble than files using the comma delimiter.

So running above query could gain as stated above ?
^ if you copy with firefox thru table2clipboard add-on then you can paste into MS-Excel and save it as required !!
Oh okay ! thank you Big Grin