Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jobe
Starting Member
10 Posts |
 Posted - 2003-10-31 : 12:38:31
|
| Hi,I am trying to find some better tools for email creation. I am constantly setting up new scripts for sending large email jobs which I schedule to run often. These emails invariable need to get data from SQL server, intelligently create the email based on the results, and log the results. I often need to generate attachments (excel and even word in some cases).Working in an all Windows environment, I have been successful scripting this using VBScript and a commercial email component. I then use a job scheduler, and run the scripts through Windows Script Host. It works fine, but it is a very manual process.I was just wondering what other tools people use for these types of jobs? I couldn’t find anything in my searches that was powerful enough.Please note: This is NOT Spam I am sending, all business/corporate emails, generally status update type stuff. |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-10-31 : 13:25:43
|
| I've been running through some of the same problems on SQLTeam.com for the newsletter. And my budget is way, way limited.I just installed AspNetEmail (http://www.aspnetemail.com/). It does require .NET though. You can download a sample app (RapidMailer) to send emails based on email addresses in a database. I was able to use the app without mods to send out the newsletter.Overall I was very happy with it.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-01 : 03:06:58
|
If you want something more scalable, you might want to check out WhatCounts http://www.whatcounts.com . They have a developers API too, but I not quite sure how much it helps with your requirement of attaching dynamically generated files.OwaisEDIT: Say Graz, this ASPNetEmail thing is pretty good!
Where there's a will, I want to be in it. |
|
|
|
jobe
Starting Member
10 Posts |
Posted - 2003-11-04 : 10:17:00
|
Thanks for the tips guys, but it seems like they are pretty much what I am doing now.I use [url]http://www.aspemail.com/[/url] right now, with some VBScript. I have found it to be very good overall. It has its own email queing, so I dont have to purchase a 3rd party email tool like in aspnetemail (Imail). It looks like aspnetemail might be a little more sophisticated, but what I was really looking for was a more sophisticated version of this program:[url]http://www.mach5.com/products/mailer/index.php[/url]But you guys might want to check it out, its got some great features. I might go with it for some of my email needs.WhatCounts looks cool, but like overkill for now. Oh well, I will get along ok with my scripts.And, graz, love the sig. |
|
|
|
|
|
|
|
|
Searching for Email Tools?