Access 2000 - extract email addresses?

RickVS · 09-13-2006, 01:20 PM

I have a list of email addresses in Access, with one email address per row of data. To send an email to all of these addresses, I need them in a format that lists them delimited by a comma. I can't seem to figure out how to accomplish this. Any ideas? Thanks.

Rick

Chevy · 09-13-2006, 09:22 PM

Export them as a CSV, then open the CSV in notepad and do a find/replace of all , for ;.

RickVS · 09-14-2006, 10:15 AM

Unfortunately, this doesn't work and here's why: The first thing I do is delete all of the columns of data I don't want since you seemingly cannot export just data in an individual column. I then export the table to CSV, however it places each row of data on a separate line (If I had multiple columns of data, it would separate each column of data by a comma, then start a new line in the CSV file for each row of data). So with only one column of data, the end result is that there is no delimiter, in this case a comma, and each data value begins on a new line rather than all on one line separated by commas. Back to square one . . .

Thanks.

jernelsingh · 09-14-2006, 02:08 PM

You can use software called Email extracter.....

09-13-2006, 01:20 PM	#1 (permalink)
RickVS Registered User Join Date: Sep 2006 Posts: 5 OS: XP	Access 2000 - extract email addresses? I have a list of email addresses in Access, with one email address per row of data. To send an email to all of these addresses, I need them in a format that lists them delimited by a comma. I can't seem to figure out how to accomplish this. Any ideas? Thanks. Rick Last edited by RickVS; 09-13-2006 at 01:22 PM.

09-14-2006, 10:15 AM	#3 (permalink)
RickVS Registered User Join Date: Sep 2006 Posts: 5 OS: XP	Not quite there yet Unfortunately, this doesn't work and here's why: The first thing I do is delete all of the columns of data I don't want since you seemingly cannot export just data in an individual column. I then export the table to CSV, however it places each row of data on a separate line (If I had multiple columns of data, it would separate each column of data by a comma, then start a new line in the CSV file for each row of data). So with only one column of data, the end result is that there is no delimiter, in this case a comma, and each data value begins on a new line rather than all on one line separated by commas. Back to square one . . . Thanks. Last edited by RickVS; 09-14-2006 at 10:36 AM.

09-13-2006, 09:22 PM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Export them as a CSV, then open the CSV in notepad and do a find/replace of all , for ;.

09-14-2006, 02:08 PM	#4 (permalink)
jernelsingh Registered User Join Date: Nov 2004 Location: USA,Ohio Posts: 227 OS: win 2003 ,Win XP	You can use software called Email extracter.....