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

C

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
 
J

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]
 
C

Casy

Thank you John.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top