How do I generate an e-mail list from Access 2007?

[Casy]

Hi folks,
What I need is quite simple and useful. I have a table which contains
all the students' information, including their email address. And sometimes I
would like to send emails to all of them. Is there a way in Access 2007 that
I can easily generate an email list, in a format like "email1, email2,
email3,.....". In this case, I could just simple copy and paste the email
list to my sending email.
Thanks a ton!!

Casy

 

[John W. Vinson]

Hi folks,
What I need is quite simple and useful. I have a table which contains
all the students' information, including their email address. And sometimes I
would like to send emails to all of them. Is there a way in Access 2007 that
I can easily generate an email list, in a format like "email1, email2,
email3,.....". In this case, I could just simple copy and paste the email
list to my sending email.
Thanks a ton!!

Casy

You need a little bit of VBA code to do this: see

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson [MVP]

 

[Casy]

Thank you John.

And I also find out that we can simply do it through the Export data->Merge
it with MS Word.