Jeff Moden (3/28/2013)
OCTom (3/28/2013)
Where I work mass mailings are done using mail merge in MS Word. We set up a data source on the user PC pointing to the SQL table used for the info.If Word is not available to you Open Office is free and can be used in a similar manner (I've been told this but have not done it).
Tom
Youu beat me too it. I haven't done it in quite a while but Word would merge an address file with a documet file and create 1 document per address. If you were to do a little VBA macro to run an "export" proc from Word, you could make it as easy as the push of a button onscreen.
Yeah, MS Word 97 did a pretty good job for me at the time.
Newer versions, I believe, are capable of doing the same, pretty much.
Automated scheduling is a bit of a problem, but it's not required in this case.
For automated sends over different time zones all over the world sp_makewebtaks (SQL 2000) was very useful:
create template in an editor, leave placeholders for data and schedule a job to run it when you're asleep.
I believe it's still in operation till these days. 🙂
_____________
Code for TallyGenerator