sql server programming: Dear All

I am new to SQL Server so if the question I ask is so obvious to you then I
apologise, but how can I create a distribution EMail (HTML with pictures)
extracting the data from a SQL Server database? Like Microsoft's MSDN Flash.
Is it done entirely through SQL Server and a web authoring tool such as
FrontPage or do you need another third party software package.

Can anyone point to an article on the internet that could assist me?

Thanks again...

Alastair MacFarlane

Hi,

[quoted text, click to view]

as far as I see it, HTML interpretation is something, which is done by the
receiver, NOT by the sender. Each HTML-text is pure ASCII. That means, you may
create each HTML-page with notepad and provide it as a "normal" ASCII-string

For creating HTML pages you need any ASCII-editor (as notepad) and the knowledge
of the HTML-structures which you can learn here for example

http://www.selfhtml.org/#en -- uups, sorry, thats a german link, i don´t know
a comparable english link, sorry.

Of course, packages like frontpage make the HTML-creation easier, but they are
not necessarry.

And the ASCII-Text easily can be stored in SQL-Server

For dealing with Mail in SQL-Server the following Webcast may be helpful

http://support.microsoft.com/default.aspx?scid=fh;EN-US;pwebcst&expand=87

or more exact

http://support.microsoft.com/default.aspx?scid=kb;EN-US;817509


--
mfg

Klaus Oberdalhoff(Access MVP) KObd@gmx.de
Info unter: http://www.freeaccess.de/KlausOberdalhoff.asp



[quoted text, click to view]