How can I send a mass email with recipients populated from an Acess DB? sharepoint, outlook, access, sbs?
Posted on 2007-10-04
I have a client that has some special needs. They have an MS Access database with data is kept up to date by another oganization. The database keeps client information (name, phone number, email, etc). They would like to be able to use this database to send out mass emails to approx 1,000 clients within this database. Oh and the database is always being updated, approximately every 30 minutes to an hour a new one is downloaded locally. That's basically all the functionality they need.
However, I'm working with very non-technical people here. So I'm wondering what would be the best way to get this working as easily as possible.
I know there are multiple ways of doing this, so I'm just thinking out loud here. I'm thinking maybe using SharePoint as the "middle man" and have that pull the data from Access and then using Outlook to send the emails. Or maybe getting Access to send the emails directly from there. Or maybe there is a way to sync Outlook and Access directly. Can you tell I don't know where to start. But I have a gut feeling that this has been done before and I'm not alone on this issue.
Any help, direction, advice, questions, or comments are greatly appreciated.