sending a lot of mails from a query

Question

a have a file with about 13000 addresses

i have a query to choose some addresses, and want to send an email.

what is best ? putting all addresses in 1 e-mail or sending seperate mails to each address ?

and how do i loop trough the query

Answer 1

honestly your best option is to export that list; and then import it into an application that is designed for mass emailing.

I believe that attempting to turn an Access database into a mass emailing application is a round peg in a square space - - it just isn't a fit.  Plus there are emailing applications out there already built and at a very reasonable price.  Perhaps even your own Outlook system.... so why reinvent the wheel....

Limit the role of the database to be the application that creates the correct set of emails; but then port the data over to an application that is made for emailing and has built in all the contingencies i.e. bounced back invalids, etc.

my 2 cents....

Answer 2

I ' ve putthe adressen in the Bcc sectio's of the email and sent it by Outlook , it worked fine en very Quick ! Thx for the reply