Please Help w/ Access automated timed merge

[Officetutor]

Hi so in a nutshell here is what I would like to do and I am wondering if it is possible:

I would like to keep a database of clients or sold customers and I would like to be able to have access and outlook work in a harmony to automatically send personalized emails to said clients with merged personalized information: names, products purchased, etc. and I would like this all to be based on date, one date to be specific : sold date, which of course would be stored in the database. I would like the programs to periodically send different emails to clients based on the time elapsed since purchase date, i.e. 1 day thank you message, 6 month follow up, and 1 year to solicite repeate business.

I am a little familiar with Access as well as outlook, so I understand database creation, mail merging, and the like. What I am ultimately looking for is how to set up the "behind-the-scenes" mechanics so that as the database grows the follow up will take care of itself.

Any and all help would be greatly appreciated, thanks.

 

[steveboydon]

It is possible, it will all be based on a query of when the last contact was.

The problem with automating outlook especially in a business is that VBA is often used to hijack and use email programs such as outlook to read address books and send out spam.

Any responsible network admin would disable the running of code and macros in outlook, especially from an external application. It may be possible to have it work in the opposite direction. For example, pull the records to want to merge from Access.

Steve