<Cfset three = #dateadd('d',-3,currentdatetime)#>
<Cfoutput>
#three#
</Cfoutput>

<cfquery name="getsites" datasource="cityguide">
select *
from ListingsRequests
where date(entrydate) = '#dateformat(three,'yyyy-mm-dd')#'
and mag = 2
</cfquery>

<cfoutput query="getsites">
select *
from ListingsRequests
where date(entrydate) = '#dateformat(three,'yyyy-mm-dd')#'
and mag = 2


<Cfif #getsites.tablename# eq 'Events'>
<Cfquery name="getname" dataSource="cityguide">
select NAME,id,nympregion,contactemail  as region from ActivityPlanner
where id = #getsites.itemid#
</cfquery>
<cfset linkme = 'http://www.nymetroparents.com/2015neweventinfo.cfm?id=#getname.id#'>
<Cfelse>
<Cfquery name="getname" dataSource="cityguide">
select NAME,seo_friendly,region,inquiryemail as contactemail from ParentsListings
where id = #getsites.itemid#
</cfquery>
<cfset linkme = 'http://www.nymetroparents.com/listing.cfm?cat=#getname.seo_friendly#'>

</cfif>



<cfif parameterexists(getname.contactemail) and #getname.contactemail# is
not '' and #getname.contactemail# contains '@'>
<CFMAIL
TO="#getname.contactemail#"
SUBJECT="Reminder--customer's question"
        FROM="NYMP <[email protected]>"
        bcc="[email protected]"
SERVER="127.0.0.1"
type="html">
<p>
    		<img src="https://www.nymetroparents.com/images/logo.png">
<p></p>
<Cfif #getsites.nymptag# eq 'Virtual Camp Fair'>
    
    Camp Director,<Br>
We are just following up to remind you to connect with this family who expressed interest in learning about your camp. It is possible this family reached out to other camps as well, so don’t miss this opportunity.
<Br><Br>
Let us know if there is anything else we can help with.
<Br><Br>
Your partners at NYMetroParents
<Cfelse>

Dear NYMetroParents Client,
<p>
Here is an inquiry that came in from an interested parent 3 days ago.  We hope you have been able to connect with the family and introduced yourself to them.  If you haven't been able to reach them yet, here is reminder to make one more effort to connect with this parent who expressed interest in you.  Good luck in working with the prospective customer.
 <p>
Your NYMetroParents Partners</Cfif>

<p>

<cfif #getsites.nymptag# is not ''>Interest: #getsites.nymptag#<p></cfif>

Name: #getsites.firstname# #getsites.lastname#
<p>
E-Mail: #getsites.contactemail#<p>
<cfif #getsites.contactphone# is not ''>Phone: #getsites.contactphone#<p></cfif>
<cfif #getsites.requestdate# is not ''>Dates of Interest:
#getsites.requestdate#<p></cfif>


Question: #getsites.contactquestion#

</cfmail>
</cfif>



<CFMAIL
TO="#getsites.contactemail#"
bcc = "[email protected]"
SUBJECT="Checking on inquiry to #getname.name#"
        FROM="NYMP <[email protected]>"
                bcc="[email protected]"

SERVER="127.0.0.1"
type="html">
<Table width="500">
	<Tr><Td>
		<img src="https://www.nymetroparents.com/images/logo.png">
		<p><font face="verdana">

<Cfif #getsites.nymptag# eq 'Virtual Camp Fair'>

Dear Parent,
<p></p>
We are following up you see if you heard from #getname.name# when you sent in the form on the On Demand Virtual Camp Fair. Please click this <A href="http://www.nymetroparents.com/followup.cfm?email=#getsites.contactemail#&id=#getsites.id#">Camp Contact Experience link</a> to let us know the outcome.
<p></p>
Also check back to the Virtual Camp Fair to see if there are new camps on who might be a good fit for your child. 
<p>
<a href="https://www.nymetroparents.com/nyc-virtual-camp-fair/">New York City Virtual Camp Fair</a><br>
<a href="https://www.nymetroparents.com/long-island-virtual-camp-fair/">Long Island Virtual Camp Fair</a><br>
<a href="https://www.nymetroparents.com/westchester-rockland-virtual-camp-fair/">Westchester / Rockland Virtual Camp Fair</a><br>
</p>


<Cfelse> 

Dear #firstname# #lastname#,
<p>
We at NYMetroParents are committed to helping you "<i>make the best decisions for your family.</i>"
<p>
	Did you hear back from <a href="#linkme#">#getname.name#</a> from your inquiry on #dateformat(entrydate, 'mmmm dd, yyyy')#? If you did we would like to know if you were satisfied. If not, let us know and we will encourage them to reach out to you ASAP.
 <p>
Please <A href="http://www.nymetroparents.com/followup.cfm?email=#getsites.contactemail#&id=#getsites.id#">click on this link</A> and give us feedback. (it is only 1 question)

<p>
Your friends at NYMetroParents.com
</cfif>
</Td></Tr></Table>
</cfmail>


</cfoutput>