Page Index Toggle Pages: 1
Topic Tools
Normal Topic Extracting email addresses from csv file. (Read 837 times)
westwegoman
Ex Member
**




YaBB 2.5.2
Extracting email addresses from csv file.
Jul 26th, 2012 at 10:33pm
Post Tools
There may be another way to do this but since I'm addicted to playing around with excel, this works for me so, I thought I would share anyway.

If you are like me, you may want to send emails via something other than your YaBB forum. If so, I have put together an excel workbook that will extract email addresses from YaBB's "yabbaddress.csv" file and save it as a new file without usernames.

Simply run the macro and it does it all.

It's not pretty and all fancy, but it works.

Note: This workbook and YaBB's "yabbaddress.csv" file must be located within the same folder on your PC.

v3
- simply extracts emails and saves new file without user names.
-Saves new file as "YaBB_Extracted_Emails.csv"
« Last Edit: Jul 27th, 2012 at 8:07pm by WestwegoMan »  

ExtractEmail_v3.zip ( 14 KB | 37 Downloads )
Back to top
 
IP Logged
 
westwegoman
Ex Member
**




YaBB 2.5.2
Re: Extracting email addresses from csv file.
Reply #1 - Jul 27th, 2012 at 8:04pm
Post Tools
New file should handle as many addresses as you want. Still extracts user names but leaves it in a csv file. Dont know why I didn't do it like this the first time.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Topic Tools
Bookmarks: del.icio.us Digg Facebook Google Google+ Linked in reddit StumbleUpon Twitter Yahoo
 
  « Board Index ‹ Board  ^Top