Need your help

[sapna]

Hello everyone,



I am new to this forum. I have a query and for its solution when I searched on net I found this forum. I hope to get some quality solution here. Here is my question:

I want to send mail in bulk and would like to use MS ACCESS for this(using MS OFFICE 2003). It would be grateful if anyone could help me. I need it urgently so waiting for your reply eagerly.

[NTC]

well here is the situation ; Access is a great database. But it is not a bulk emailing system. Wasn't designed to be - so you don't want to do back flips attempting to custom code a solution for which it is not intended.

Assuming you have an Access database with names/contacts - and one of those fields is the email. You use Access to find the emails tht meet your criteria. Perhaps by zip code. Or those that purchased last month... whatever. You mine the database to find the right set of records.

Then you "put" those emails into the bcc field of your email (if you are doing a bulk/mass email). How you do that varies on both your email and version of Access. Try a couple different ways: highlight the whole column of emails (query or table) and simply copy/paste into your email address field - that might work. or export to a csv file that is ; delimited - - then copy/paste this into the email....this almost always works....