<!---
Name:        promo_email.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: Promotional E-Mail Generator
Created:     4/15/01
--->

<!--- Get Merchandise Info from database --->
<CFQUERY NAME="GetMerchInfo" DATASOURCE="ows">
  SELECT FilmID, MerchName, MerchDescription, MerchPrice
  FROM Merchandise
  ORDER BY FilmID
</CFQUERY>


<!--- Create HTML E-Mail --->
<CFMAIL TO="dealers@ows.com"
        FROM="store@ows.com"
        SUBJECT="Merchandise Currently Available"
        SERVER="mail.ows.com"
        PORT=25
        TYPE="HTML">

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
    <TITLE>Available Merchandise from OWS Online Store</TITLE>
</HEAD>

<BODY>

Greetings from Orange Whip Studios!

Here is a list of the merchandise currently available from the online store at Orange Whip Studios. To order any of these items, go to <a href="http://www.ows.com/store">http://www.ows.com/store</a>.

<!--- Display merchandise info --->
<TABLE BORDER="1">
<TR>
 <TH>Item Name</TH>
 <TH>Description</TH>
 <TH>Price</TH>
</TR>
<CFOUTPUT QUERY="GetMerchInfo">
<TR> 
 <TD>#GetMerchInfo.MerchName#</TD>
 <TD>#GetMerchInfo.MerchDescription#</TD>
 <TD># DollarFormat (GetMerchInfo.MerchPrice) #</td>
</TR>
</CFOUTPUT>
</TABLE>

</BODY>
</HTML>

</cfmail>
