Need to generate text list with email address

[pcoppola]

Hello everybody

First of all, I'm very new in MS Access.
I have a table to store data about people.
The fields are Name, Surname, e-mail, address, phone, and so on.

I need to generate a comma-separated text file with a list of e-mail addresses.
For example:

Record1: Name1, Surname1, [e-mail], phone1....
Record2: Name2, Surname2, [e-mail], phone2....
Record3: Name3, Surname3, [e-mail], phone3....
.....
Record-n: Name-n, Surname-n, [e-mail], phone-n....

The output should be a text file like this:

[e-mail],[e-mail],[e-mail],..... [e-mail]

Is there any way to do this?

Thanks in advance,
Pablo

[PEB]

Hi,

Save this function in a module

Function create_field(SQL, file_name)
Dim mydb as database
dim myr as recordset
dim res
set mydb as currentdb()
set myr as recordset
myr.movefirst
Do while not myr.eof
if res="" then
res=myr(0)
else
res=res+", "+myr(0)
end if
loop
 
open file_name for output as #1
Print #1, res
Close #1
myr.close
mydb.close
END function
 

Then create a macro runcode in which supply: create_field("Your query name", "Path and file name")

Your query with the mail have to have only one column - the column with the mails!

Best regards!

:)

[pgirl]

Or click on File -> Export and choose csv from the file types list.

You can click on the ADVANCED button to set more options.

This will put each record on a new line and seperate each field value with a comma.