May 29, 2003 at 5:21 am
I have to create a newsletter for e-mail broadcast and I was planning on using SQL Server's own sp_MakeWebTask and sp_RunWebTask to generate the personalised newsletter.
As a proof of concept I've got it producing the files I want and then using xp_cmdshell to xcopy files to the webserver's mailroot\pickup directory. This is working fine in an internal development environment.
The bit I'm not sure on is what should go in the header of the file?
So far I have the bare bones as described in the mail.chm help file.
How do I cope with recipients who can't receive HTML?
How is the SQL Server Central newsletter sent out and how does this cope with the HTML issue?
Grateful for any help I can get on this.
May 29, 2003 at 6:05 am
We've used a few different things to do the mail, CDO at one point and now looking at Lyris. Ideally you want to abstract yourself from the mail format if you can. We basically build a template, then the template gets some minor (for now anyway) personalization.
You know, I don't know if we support a text option. I'll send the thread to Brian, he can add more.
Andy
May 29, 2003 at 6:39 am
Hi David, we're about to convert to Lyris ourselves. It and many other newsletter software tools (we use G-Lock software right now) can send out a dual-message in the same message. One is for the clients with no HTML the other for HTML. One thing to watch out for is Outlook 2003 will not allow some HTML items like images.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply