Log in

View Full Version : exporting emails


True african
11-08-2008, 12:50 PM
I need to get all my forums members email address from the vBulletin as CSV format so that i can Import them to gmail . thanks in advance

UKBusinessLive
11-08-2008, 06:43 PM
There is no built-in function to do that.

You would need to use a MySQL query, something like:

SELECT username,email FROM user WHERE usergroupid='x';

...where 'x' is the appropriate usergroupid number.

hope this helps :)

snakes1100
11-08-2008, 08:04 PM
admincp --> users --> generate mailing list.

Save the list to a notepad file.
download an editor like EditPlus (http://www.editplus.com/)
open the file in edit plus
click search
click replace
in the find box, click the space bar one time so there is a empty space
in the replace with box, place a comma
click replace all on the right.

now u have a csv formatted list.