<Cfset three = #dateadd('d',-7,currentdatetime)#>

<cfquery name="getsites" datasource="cityguide">
select *
from mediakit
where date(datetime) = '#dateformat(three,'yyyy-mm-dd')#'
</cfquery>



<cfoutput query="getsites">
#getsites.email#


<CFMAIL
TO="#getsites.email#"
SUBJECT="Follow-up on information request"

        FROM="Publisher-NYMetroParents <[email protected]>"
SERVER="127.0.0.1"
type="html">
Dear #name#,
<p>
We received your inquiry about advertising opportunities on NYMetroParents' magazines and websites.
I am following up to make sure you got great service and received all the information you need to make
a decision. If you did not get the information you want or have additional questions, don't hesitate to
contact me directly.
<p>
David L. Miller<br>
Publisher<br>
(646) 736-3618<br>
[email protected]
<p>
Here are a few highlights about us.
<p>
* We are the largest local publisher of parenting media in the US<br>
* We reach about 1,000,000 area parents every month<br>
* Our calendars feature about 1,000 family events every month<br>
* We have about 750 advertisers in our media every month<br>
<p>
A/E #assignedto#

</cfmail>



</cfoutput>