Once a year I help out a local non profit promote their annual event. This is the third year for doing it, and I just wanted some peer review to see if you'd have recommendations to do it differently.
Right now, the whole thing is a full on DBA process, which requires my well rounded skills. I'd like to change this to a process where any end user could send out an eblast without it being a html developer + DBA required to do the grunt work.
Does anyone use a program for sending stuff out like this? How do YOU do it? homemade app? web page? off the shelf app? I'd like to hear some suggestions
Here's my current process, the gory details are not really needed as far as script examples, i think:
We've got a typical contact database with a few thousand contacts.
We have a meeting where non-technical people say what they want in the email, and i will create a nice looking html email, with images and nice design, blah blah, but with placeholders for find-and-replace for personalizing the emails.
ill stick the html into a table via a basic insert.
Later, when we are ready to actually send it out:
I select the html into a varchar(max) @HTMLBody for the body of the email.
I create a cursor to loop thru the rows of the contacts to be spammed....er asked for donations.
Find and replace placeholders to personalize the message to the contact int eh cursor ie REPLACE'[FirstName],@Firstname) for things like firstname/lastname/email/phone/etc.
each email is sent via sp_send_dbmail to send out individualized messages.
After it's all done,
I'll end up reviewing msdb.dbo.sysmail_allitems and sysmail_faileditems for progress and issues. Contsantly rerunning the same query to see the unsent items dwindle down to zero.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!