0

I'm looking for a program/script, better if it's OpenSource/Free, that can periodically send an email to a list of addresses that are in an Excel File or Access DB.

I know I could hack something together using VB and Blat or something like that, but I was looking for something already built.

Thanks a lot

1 Answer 1

1

JJarava,

It sounds like you're looking to do a basic mail merge? If the process is going to be user initiated then the steps to perform a merge are located can be found by googling mail merge.

I have't dug up a routine that does the entire process for you, but hopefully I can get you going down the right track. I would imagine that your ideal solution would be similar to the following:

  1. Programatically Create mail merge via excel/access
  2. Schedule intervals for the program to run

Assuming you're in a hacking mood then if you would like to automate most of the process here is a snippet for Access VBA, and two for Excel VBA here and here.

If you would like to automate the entire process (ie: scheduling, etc), then it may be a bit more involved. You can look at running a scheduled job to execute the process from windows or possibly look into using powershell to accomplish all of the above.

Hopefully this will start you off. Let me know if you're stuck and I'm sure we can cobble something together.

3
  • Sorry for the ugly links, I had too few points to attach more than one hyperlink. I will clean it up when I earn my big boy pants.
    – godel
    Oct 22, 2009 at 21:17
  • Ok, I fixed the links.
    – godel
    Oct 28, 2009 at 3:49
  • Hi, What I wanted to do is to automate a sending of some status messages and suchlike, so it's like a mail merge. Doing a mail merge with Word/Access is something I've done before, but I wanted to do it from a server, not "manually". I know I can do it via VBA, etc, just "digging around" to see if there was something pre-built I could use. Thanks anyhow for the pointers, they're useful. BR
    – JJarava
    Dec 29, 2009 at 10:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .