<cfinclude template="/header.cfm">


<Cfif parameterexists(url.send)>

<CFMAIL
TO="#form.theirs#"

SUBJECT="#form.subject#"
 FROM="NYMetroParents <[email protected]>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
<p>
#form.HTMLPreviewTextArea#
</cfmail>


<font face=verdana size=-1>
<Center>
<p>
<br />
<font face=verdana size=+1>Thank You  - Your Message Has Been Sent!
<p>
<a href="school2019csv.cfm?gridit=on">Back...</a>
<cfelse>


<cfquery name="getstart" dataSource="#ds#">
	select * from school2019form
	where id = #url.id#
</cfquery>

<cfquery name="Getpt2" dataSource="#ds#">
	select catname,categorytext,typer,reg from school2019formcats inner join school2019catmap
	on 	school2019formcats.catid = school2019catmap.ID
	where school2019formcats.campid = #url.id#
</cfquery>


<cfif #getpt2.reg# eq 'NYC'>
	<cfset typer = 'NYC'>
<cfelse>
<cfset typer = 'Sub'>
</cfif>

<p>
<cfFORM  action="school2019email.cfm?send=on&id=#url.id#" method="post">
      <table  cellspacing=5 cellpadding=5>


  	  <tr>
	  <td valign=top>
	  <b><font SIZE="-1" FACE="verdana" >To E-Mail:</font></b>
	  </td>
	  <td>
<cfquery name="Getmail" dataSource="#ds#">
	select email from davlersales
	where full = '#getstart.accountrep#'
</cfquery>
<cfinput NAME="theirs" SIZE="45"  required="yes" message="Please enter their email address."

value="#getmail.email#"



><br />
  </td></tr>

  <tr>
	  <td>
	  <b><font SIZE="-1" FACE="verdana" ><b>Subject:</b></font>
	  </td>
	  <td>
<cfoutput>
<input NAME="Subject" SIZE="100" value="#getstart.businessname# At-a-Glance preschool Guide Information for #getstart.region#">
</cfoutput>
	  </td></tr><tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana"><b>Message:</b></font> <br>
<script src="https://cdn.ckeditor.com/4.11.1/full/ckeditor.js"></script>

        <textarea name=HTMLPreviewTextArea cols="80" rows="25" wrap="VIRTUAL">
You're in our March Preschool and Nursery School directory, which means you can also be included in an at-a-glance chart in print.
<p>

In an effort to make this as easy as possible for you, below you'll find the information we have on file for you, including contact information and the categories you selected last year. If you have any changes, please send them and we will update the information we have on file, otherwise please let us know if what we have is good to publish.
<p>
	<cfoutput>
<B>Name:</B> #getstart.businessname#<br>
<B>Address:</B> #getstart.address#<br>
<B>City:</B> #getstart.city#<br>
<B>State:</B> #getstart.state#<br>
<B>Zip:</B> #getstart.zip#<br>
<B>Web:</B> #getstart.website#<br>
<B>Phone:</B> #getstart.phone#<br>
<B>Region:</B> #getstart.region#<br>
<B>Rep:</B> #getstart.accountrep#<br>
<B>Email:</B> #getstart.email#<br>
<B>Microsite:</B> #getstart.micrositelink#<br>
</cfoutput>
<p>
	<b><font color="RED">ENTRIES</font></b>
<p>
<Cfoutput query="getpt2">
	<b>#catname#</b><br>
	#categorytext#<br>
</Cfoutput>
<p>
If you would like to add any new categories, please see the options below and let us know which to add:
<p>


<b>Services</b><Br>
            Transportation<Br>

            Snacks / Meals<Br>

            Late Pickup<Br>



<Br><Br>
<B>Programs</B><Br>
Academic Enrichment<Br>

            Arts and Crafts<Br>

            Cooking<Br>

            Dance / Music / Theater<Br>

            Martial Arts
<Br>
            Music <Br>

            STEAM / Robotics / Coding<Br>

            Sports<Br>

            Special Needs<Br>

            Mommy-and-Me

 


<br>
	<p>
	If you have any questions, don't hesitate to ask!<p>

Best,<br>
The NYMetroParents Team


 </textarea>

 		<script>
			CKEDITOR.replace( 'HTMLPreviewTextArea' );
		</script>

      </td>
    </tr>
</td>
</tr>
	 </table>
 <center><input type="submit" Value="Send Email">
</cfform>
</cfif>