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
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
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 !!