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.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.