Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

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.

share|improve this answer
    
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 '09 at 21:17
    
Ok, I fixed the links. –  godel Oct 28 '09 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 '09 at 10:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.