PHP and MS SQL Server 7.0

I would like to use PHP to open a connection to a MS SQL server, query the database, and then use the query results to generate dynamic content for a mass HTML e-mail campaign. Is it possible to execute PHP scripts in an HTML file or must the file have a .php extension? I'm limited by the software my employer uses (UnityMail, maybe someone's familiar with it?) which requires that the HTML code for the message body be pasted into a client-side form that the software then uses to generate the message and deliver it to the list of recipients. Any help is greatly appreciated! Cheers, Michael Morrison Valparaiso University http://www.therainforestsite.com/ http://www.thehungersite.com/