mass emailing from accesss

[jothish_r]

hello friends i need ur help
i have a students database and i have the email address of all
the students stored inthe database

what i want to do is like get the e-mail of all the students and
use that 4 send them email ,like common messages etc ...like tommorow is holiday..

can i import the email alone and store in outlook and mail from there..is there any way extracting mail address alone...and storing or any feature in access tat can be used for this


thanx in advance

 

[Fornatian]

You could either send the email directly from access using the SendObject command:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52307&highlight=email+loop

or alternatively, if you just want to output the names and addresses to Outlook and then use outlook, you could output the information required using a query and output it as a comma delimited text file which could then be imported into outlook.

The first method is better because there is no possibility of missing any students added after the last export/import