<cfquery name="getfirst" dataSource="#ds#">
	select * from newwriteupmaster
	where 1 = 1
	and emailreps = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
	
	
	<cfloop from ="1" to="#getfirst.recordcount#" index="i">


<cfquery name="getstuff" datasource="#ds#">
 select distinct ParentsListings.salesperson
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
  issueguidecat.mags like '%#getfirst.mags[i]#%'
<Cfif #getfirst.catnumber[i]# does not contain ','>
 and issueguide.catid = #getfirst.catnumber[i]#
<cfelse>
 and issueguide.catid IN (#getfirst.catnumber[i]#)

</Cfif> 
 and issueguidecat.issue = '#dateformat(getfirst.month[i],'mmmm yyyy')#'
<!--- and ParentsListings.salesperson = '[email protected]'
--->
 </cfquery>
 
 
 <Cfoutput query="Getstuff">
<cfset fromme = 'Heather Gambaro <[email protected]>'>
	
	<Cfset sendtosales = '#getstuff.salesperson#'>
<Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected]'> 
	</Cfif>
	 <Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected],[email protected]'> 
	</Cfif>
	
<Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected],[email protected]'> 
	</Cfif>
	

	 <CFMAIL
TO="#sendtosales#"
SUBJECT="Final Call To Check Your #getfirst.month[i]# #getfirst.mags[i]# #getfirst.directory[i]# Write-Up List"
        FROM="#fromme#"
   SERVER="127.0.0.1"
type="html">
<p>
Here is your current list of clients receiving a 90-word write-up in the #getfirst.month[i]# #getfirst.mags[i]# #getfirst.directory[i]# directory. Please confirm that as of now, these are all of your clients running in the directory. 
<p>
<a href="http://www.cityguideny.com/admin/writeupspreadsheet.cfm?issue=#dateformat(getfirst.month[i],'mmmm yyyy')#&mags=#getfirst.mags[i]#&salesperson=#getstuff.salesperson#&catid=#getfirst.catnumber[i]#">Click Here</a>	
<p>	
Please also send any omissions or additions to Heather Gambaro 
([email protected]) or Erin  ([email protected]).
<p>
You must send it to Heather or Erin by 
<cfset newdate = dateadd('d',-1,getfirst.firstemail[i])>
#dateformat(newdate,'m/d/yyyy')# so we can make sure they make it in print this month. 
<p>
Thanks, <br>
The Traffic Department

</cfmail>
</cfoutput> 
 
	</cfloop>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	<cfquery name="getfirst" dataSource="#ds#">
	select * from newwriteupmaster
	where 1 = 1
	and firstemail = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
	
	
	<cfloop from ="1" to="#getfirst.recordcount#" index="i">


<cfquery name="getstuff" datasource="#ds#">
 select distinct ParentsListings.id,ParentsListings.contactemail,ParentsListings.email,ParentsListings.name,ParentsListings.region,issueguide.id as issueguideid,ParentsListings.salesperson
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
  issueguidecat.mags like '%#getfirst.mags[i]#%'
<Cfif #getfirst.catnumber[i]# does not contain ','>
 and issueguide.catid = #getfirst.catnumber[i]#
 <cfelse>
 and issueguide.catid IN (#getfirst.catnumber[i]#)
</Cfif> 
 and issueguidecat.issue = '#dateformat(getfirst.month[i],'mmmm yyyy')#'
  and issueguide.writeup = ''
order by rand()

<!--- and ParentsListings.salesperson = '[email protected]'
--->

 </cfquery>
 
 
 <Cfoutput query="Getstuff">

<cfif #getstuff.contactemail# is not ''>
	<cfset emailto = '#getstuff.contactemail#'>
<cfelse>
<cfset emailto = '#getstuff.email#'>	
</cfif>

<Cfif parameterexists(getstuff.salesperson) and #getstuff.salesperson# eq '[email protected]'>
<cfset emailto = rereplace(emailto,' ','','ALL')>

<Cfset emailto = '#emailto#,[email protected]'>
</Cfif>

<cfif isvalid ('email',#emailto#) or #emailto# contains 'croteman'> 
	
	
	
	
<cfquery name="eGetstuff" datasource="#ds#">
select *
from issueguide
where id = #getstuff.issueguideid#
</cfquery>
<Cfquery name="eGetmorestuff" dataSource="#ds#">
SELECT * FROM issueguidecat WHERE issueguideid = #getstuff.issueguideid#
</cfquery>
      <Cfquery name="eGetregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where id = #egetstuff.catid#
order by catname
</CFQUERY>

<Cfset lastmonth = dateadd('m',-1, currentdatetime)>
<Cfset lastmonth = dateformat(lastmonth,'m')>
<cfquery name="egetprevious" dataSource="#ds#">
select issueguide.id,issueguide.writeup,issueguidecat.mags,issueguidecat.issuemy,issueguidecat.issue
from issueguide inner join issueguidecat on issueguide.id = issueguidecat.issueguideid
where issueguide.pkid = #eGetstuff.pkid#
 and issueguide.writeup <> ''
and issueguide.id <> #getstuff.issueguideid#
order by issueguide.id desc
limit 0,12
</cfquery>

<Cfquery name="eGetname" datasource="#ds#">
select *
from ParentsListings
where id = #eGetstuff.pkid#
</Cfquery>

<!--bcc = "[email protected]"
--->
 #name#: Your #getfirst.month[i]# #getfirst.mags[i]# #getfirst.directory[i]# Parent Write-Up is Due"
<p>
	
	<cfset monthme = #dateformat(getfirst.month[i],'mmmm yyyy')#>
	<Cfif #getfirst.mags[i]# eq 'RP'>
<cfset magme = "Rockland">
<cfelseif #getfirst.mags[i]# eq 'BAP'>
<cfset magme = "Big Apple">
<cfelseif #getfirst.mags[i]# eq 'WP'>
<cfset magme = "Westchester">
<cfelseif #getfirst.mags[i]# eq 'BP'>
<cfset magme = "Brooklyn">
<cfelseif #getfirst.mags[i]# eq 'QP'>
<cfset magme = "Queens">
<cfelseif #getfirst.mags[i]# eq 'FP'>
<cfset magme = "Fairfield">
<cfelseif #getfirst.mags[i]# eq 'NP'>
<cfset magme = "Nassau">
<cfelseif #getfirst.mags[i]# eq 'SP'>
<cfset magme = "Suffolk">
<cfelse>
<cfset magme = "#getfirst.mags[i]#">
</Cfif>


<cfset fromme = 'Heather Gambaro <[email protected]>'>

	 <CFMAIL
TO="#emailto#"
SUBJECT="Please Submit Your #monthme# #magme# #getfirst.directory[i]# Parent Write-Up"
        FROM="#fromme#"
SERVER="127.0.0.1" bcc = "[email protected]"
type="html">
<p>

Dear #name#, 
<p>
The #monthme# 

<Cfif #getfirst.mags[i]# eq 'RP'>
Rockland
<cfelseif #getfirst.mags[i]# eq 'BAP'>
Big Apple
<cfelseif #getfirst.mags[i]# eq 'WP'>
Westchester
<cfelseif #getfirst.mags[i]# eq 'BP'>
Brooklyn
<cfelseif #getfirst.mags[i]# eq 'QP'>
Queens
<cfelseif #getfirst.mags[i]# eq 'FP'>
Fairfield
<cfelseif #getfirst.mags[i]# eq 'NP'>
Nassau
<cfelseif #getfirst.mags[i]# eq 'SP'>
Suffolk
<cfelse>
#getfirst.mags[i]#
</Cfif>

 Parent 
 
 edition is getting ready for publication. You are entitled to a 90-word write-up, showcasing your business in the directory. This is a free bonus as part of your advertising package! We would like to include your copy in the directory.


<p>
Please submit your write-up by: #dateformat(getfirst.harddeadline[i],'m/d/yyyy')#.  
<p>

To submit a write-up please click on the link next to the write-up you would like to run. To submit a new write-up please click here: <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#">http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#</a><p>


<Cfif #egetprevious.recordcount# gte 1> 


To pick-up a write-up that you've run before, please review this page to select the write-up you'd like to continue to run in the #monthme# directory: 
<p>

<cfloop from="1"  to="#egetprevious.recordcount#" index="z">


#egetprevious.issue[z]# - <Cfif #egetprevious.mags[z]# eq 'RP'>
Rockland
<cfelseif #egetprevious.mags[z]# eq 'BAP'>
Big Apple
<cfelseif #egetprevious.mags[z]# eq 'WP'>
Westchester
<cfelseif #egetprevious.mags[z]# eq 'BP'>
Brooklyn
<cfelseif #egetprevious.mags[z]# eq 'QP'>
Queens
<cfelseif #egetprevious.mags[z]# eq 'FP'>
Fairfield
<cfelseif #egetprevious.mags[z]# eq 'NP'>
Nassau
<cfelseif #egetprevious.mags[z]# eq 'SP'>
Suffolk
<cfelse>
#egetprevious.mags[z]#
</Cfif> Parent<Br>
<br>
#egetprevious.writeup[z]#<br>
TO PICKUP <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#&pickup=#egetprevious.id[z]#">CLICK HERE</a><br>
--------------------------------------------------------------------------------
<br><br>
</cfloop>
</cfif>

<p>

Sincerely, 
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]

</cfmail>
</cfif>
</cfoutput> 
 
	</cfloop>
	
	
	
	
	
	
	
	

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
<!-- Second Email -->

	
	<cfquery name="getfirst" dataSource="#ds#">
	select * from newwriteupmaster
	where 1 = 1
	and secondemail = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
	
	
	<cfloop from ="1" to="#getfirst.recordcount#" index="i">


<cfquery name="getstuff" datasource="#ds#">
 select distinct ParentsListings.id,ParentsListings.contactemail,ParentsListings.email,ParentsListings.name,ParentsListings.region,issueguide.id as issueguideid,ParentsListings.salesperson
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
  issueguidecat.mags like '%#getfirst.mags[i]#%'
<Cfif #getfirst.catnumber[i]# does not contain ','>
 and issueguide.catid = #getfirst.catnumber[i]#
 <cfelse>
 and issueguide.catid IN (#getfirst.catnumber[i]#)

</Cfif> 
 and issueguidecat.issue = '#dateformat(getfirst.month[i],'mmmm yyyy')#'
 and issueguide.writeup = ''
<!--- and ParentsListings.salesperson = '[email protected]'
--->

 </cfquery>
 
 
 <Cfoutput query="Getstuff">

<cfif #getstuff.contactemail# is not ''>
	<cfset emailto = '#getstuff.contactemail#'>
<cfelse>
<cfset emailto = '#getstuff.email#'>	
</cfif>

<Cfif parameterexists(getstuff.salesperson) and #getstuff.salesperson# eq '[email protected]'>
	<cfset emailto = rereplace(emailto,' ','','ALL')>

<Cfset emailto = '#emailto#,[email protected]'>
</Cfif>

<cfif isvalid ('email',#emailto#) or #emailto# contains 'croteman'> 
	#name# - #emailto#<br>	
	
<cfquery name="eGetstuff" datasource="#ds#">
select *
from issueguide
where id = #getstuff.issueguideid#
</cfquery>
<Cfquery name="eGetmorestuff" dataSource="#ds#">
SELECT * FROM issueguidecat WHERE issueguideid = #getstuff.issueguideid#
</cfquery>
      <Cfquery name="eGetregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where id = #egetstuff.catid#
order by catname
</CFQUERY>

<Cfset lastmonth = dateadd('m',-1, currentdatetime)>
<Cfset lastmonth = dateformat(lastmonth,'m')>

<cfquery name="egetprevious" dataSource="#ds#">
select issueguide.id,issueguide.writeup,issueguidecat.mags,issueguidecat.issuemy,issueguidecat.issue
from issueguide inner join issueguidecat on issueguide.id = issueguidecat.issueguideid
where issueguide.pkid = #eGetstuff.pkid#
 and issueguide.writeup <> ''
and issueguide.id <> #getstuff.issueguideid#
order by issueguide.id desc
limit 0,12
</cfquery>

<Cfquery name="eGetname" datasource="#ds#">
select *
from ParentsListings
where id = #eGetstuff.pkid#
</Cfquery>

<cfset monthme = #dateformat(getfirst.month[i],'mmmm yyyy')#>
	<Cfif #getfirst.mags[i]# eq 'RP'>
<cfset magme = "Rockland">
<cfelseif #getfirst.mags[i]# eq 'BAP'>
<cfset magme = "Big Apple">
<cfelseif #getfirst.mags[i]# eq 'WP'>
<cfset magme = "Westchester">
<cfelseif #getfirst.mags[i]# eq 'BP'>
<cfset magme = "Brooklyn">
<cfelseif #getfirst.mags[i]# eq 'QP'>
<cfset magme = "Queens">
<cfelseif #getfirst.mags[i]# eq 'FP'>
<cfset magme = "Fairfield">
<cfelseif #getfirst.mags[i]# eq 'NP'>
<cfset magme = "Nassau">
<cfelseif #getfirst.mags[i]# eq 'SP'>
<cfset magme = "Suffolk">
<cfelse>
<cfset magme = "#getfirst.mags[i]#">
</Cfif>

<cfif #magme# is not 'Queens'>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
<cfelse>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
</Cfif>

	 <CFMAIL
TO="#emailto#"
SUBJECT="We Need Your #monthme# #magme# #getfirst.directory[i]# Parent Write-Up"
        FROM="#fromme#"
            SERVER="127.0.0.1"
bcc = "[email protected]"

type="html">
<p>

Dear #name#, 
<p>
Write-ups are close to being processed for the #monthme# #getfirst.directory[i]# directory in 
<Cfif #getfirst.mags[i]# eq 'RP'>
Rockland
<cfelseif #getfirst.mags[i]# eq 'BAP'>
Big Apple
<cfelseif #getfirst.mags[i]# eq 'WP'>
Westchester
<cfelseif #getfirst.mags[i]# eq 'BP'>
Brooklyn
<cfelseif #getfirst.mags[i]# eq 'QP'>
Queens
<cfelseif #getfirst.mags[i]# eq 'FP'>
Fairfield
<cfelseif #getfirst.mags[i]# eq 'NP'>
Nassau
<cfelseif #getfirst.mags[i]# eq 'SP'>
Suffolk
<cfelse>
#getfirst.mags[i]#
</Cfif> Parent.

We are hoping to include your complimentary write-up in this month's issue! Please submit your 90-word write-up by #dateformat(getfirst.harddeadline[i],'m/d/yyyy')# to make sure we get you in front of parents' eyes this month!

<p>

To submit a write-up please click on the link next to the write-up you would like to run. To submit a new write-up please click here: <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#">http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#</a><p>


<Cfif #egetprevious.recordcount# gte 1> 


To pick-up a write-up that you've run before, please review this page to select the write-up you'd like to continue to run in the #monthme# directory: 
<p>

<cfloop from="1"  to="#egetprevious.recordcount#" index="z">


#egetprevious.issue[z]# - 

<Cfif #egetprevious.mags[z]# eq 'RP'>
Rockland
<cfelseif #egetprevious.mags[z]# eq 'BAP'>
Big Apple
<cfelseif #egetprevious.mags[z]# eq 'WP'>
Westchester
<cfelseif #egetprevious.mags[z]# eq 'BP'>
Brooklyn
<cfelseif #egetprevious.mags[z]# eq 'QP'>
Queens
<cfelseif #egetprevious.mags[z]# eq 'FP'>
Fairfield
<cfelseif #egetprevious.mags[z]# eq 'NP'>
Nassau
<cfelseif #egetprevious.mags[z]# eq 'SP'>
Suffolk
<cfelse>
#egetprevious.mags[z]#
</Cfif> Parent<Br>

#egetprevious.writeup[z]#<br>
TO PICKUP <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#&pickup=#egetprevious.id[z]#">CLICK HERE</a><br>
--------------------------------------------------------------------------------
<br><br>
</cfloop>

</Cfif>

<p>

Sincerely, 
<cfif #magme# is not 'Queens'>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
<cfelse>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
</Cfif>

</cfmail>
</cfif>
</cfoutput> 
 
	</cfloop>	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	<!---
	
<!-- Third Email -->

	
	<cfquery name="getfirst" dataSource="#ds#">
	select * from newwriteupmaster
	where 1 = 1
	and thirdemail = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
	
	
	<cfloop from ="1" to="#getfirst.recordcount#" index="i">


<cfquery name="getstuff" datasource="#ds#">
 select distinct ParentsListings.id,ParentsListings.contactemail,ParentsListings.email,ParentsListings.name,ParentsListings.region,issueguide.id as issueguideid,ParentsListings.salesperson
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
  issueguidecat.mags like '%#getfirst.mags[i]#%'
<Cfif #getfirst.catnumber[i]# does not contain ','>
 and issueguide.catid = #getfirst.catnumber[i]#
 <cfelse>
 and issueguide.catid IN (#getfirst.catnumber[i]#)

</Cfif> 
  and issueguide.writeup = ''

 and issueguidecat.issue = '#dateformat(getfirst.month[i],'mmmm yyyy')#'
<!--- and ParentsListings.salesperson = '[email protected]'
--->

 </cfquery>
 
 
 <Cfoutput query="Getstuff">

<cfif #getstuff.contactemail# is not ''>
	<cfset emailto = '#getstuff.contactemail#'>
<cfelse>
<cfset emailto = '#getstuff.email#'>	
</cfif>
<Cfif parameterexists(getstuff.salesperson) and #getstuff.salesperson# eq '[email protected]'>
<cfset emailto = rereplace(emailto,' ','','ALL')>

<Cfset emailto = '#emailto#,[email protected]'>
</Cfif>


<cfif isvalid ('email',#emailto#) or #emailto# contains 'croteman'> 
	
	
<cfquery name="eGetstuff" datasource="#ds#">
select *
from issueguide
where id = #getstuff.issueguideid#
</cfquery>
<Cfquery name="eGetmorestuff" dataSource="#ds#">
SELECT * FROM issueguidecat WHERE issueguideid = #getstuff.issueguideid#
</cfquery>
      <Cfquery name="eGetregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where id = #egetstuff.catid#
order by catname
</CFQUERY>

<Cfset lastmonth = dateadd('m',-1, currentdatetime)>
<Cfset lastmonth = dateformat(lastmonth,'m')>

<cfquery name="egetprevious" dataSource="#ds#">
select issueguide.id,issueguide.writeup,issueguidecat.mags,issueguidecat.issuemy,issueguidecat.issue
from issueguide inner join issueguidecat on issueguide.id = issueguidecat.issueguideid
where issueguide.pkid = #eGetstuff.pkid#
 and issueguide.writeup <> ''
and issueguide.id <> #getstuff.issueguideid#
order by issueguide.id desc
limit 0,12
</cfquery>

<Cfquery name="eGetname" datasource="#ds#">
select *
from ParentsListings
where id = #eGetstuff.pkid#
</Cfquery>

<cfset monthme = #dateformat(getfirst.month[i],'mmmm yyyy')#>
	<Cfif #getfirst.mags[i]# eq 'RP'>
<cfset magme = "Rockland">
<cfelseif #getfirst.mags[i]# eq 'BAP'>
<cfset magme = "Big Apple">
<cfelseif #getfirst.mags[i]# eq 'WP'>
<cfset magme = "Westchester">
<cfelseif #getfirst.mags[i]# eq 'BP'>
<cfset magme = "Brooklyn">
<cfelseif #getfirst.mags[i]# eq 'QP'>
<cfset magme = "Queens">
<cfelseif #getfirst.mags[i]# eq 'FP'>
<cfset magme = "Fairfield">
<cfelseif #getfirst.mags[i]# eq 'NP'>
<cfset magme = "Nassau">
<cfelseif #getfirst.mags[i]# eq 'SP'>
<cfset magme = "Suffolk">
<cfelse>
<cfset magme = "#getfirst.mags[i]#">
</Cfif>

<cfif #magme# is not 'Queens'>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
<cfelse>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
</Cfif>

	 <CFMAIL
TO="#emailto#"
SUBJECT="Submit Your #monthme# #magme# #getfirst.directory[i]# Parent Write-Up ASAP"
        FROM="#fromme#"
             SERVER="127.0.0.1"
bcc = "[email protected]"

type="html">
<p>

Dear #name#, 

<p>
We've tried to contact you a couple of times to submit your write-up for the <Cfif #getfirst.mags[i]# eq 'RP'>
Rockland
<cfelseif #getfirst.mags[i]# eq 'BAP'>
Big Apple
<cfelseif #getfirst.mags[i]# eq 'WP'>
Westchester
<cfelseif #getfirst.mags[i]# eq 'BP'>
Brooklyn
<cfelseif #getfirst.mags[i]# eq 'QP'>
Queens
<cfelseif #getfirst.mags[i]# eq 'FP'>
Fairfield
<cfelseif #getfirst.mags[i]# eq 'NP'>
Nassau
<cfelseif #getfirst.mags[i]# eq 'SP'>
Suffolk
<cfelse>
#getfirst.mags[i]#
</Cfif> Parent  #monthme# #getfirst.directory[i]# directory, but haven't received it yet! 

<p>
	
If you want your write-up in our magazine, we need your 90-word write-up by #dateformat(getfirst.harddeadline[i],'m/d/yyyy')# to make sure we get you in front of parents' eyes this month!

<p>

To submit a brand new 90-word write-up, please click this link to enter your text, which will then be sent to our directory editor for approval: <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#">http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#</a><p>


<Cfif #egetprevious.recordcount# gte 1> 

To pick-up a write-up that you've run before, please review this page to select the write-up you'd like to continue to run in the #monthme# directory: 
<p>

<cfloop from="1"  to="#egetprevious.recordcount#" index="z">


#egetprevious.issue[z]# - <Cfif #egetprevious.mags[z]# eq 'RP'>
Rockland
<cfelseif #egetprevious.mags[z]# eq 'BAP'>
Big Apple
<cfelseif #egetprevious.mags[z]# eq 'WP'>
Westchester
<cfelseif #egetprevious.mags[z]# eq 'BP'>
Brooklyn
<cfelseif #egetprevious.mags[z]# eq 'QP'>
Queens
<cfelseif #egetprevious.mags[z]# eq 'FP'>
Fairfield
<cfelseif #egetprevious.mags[z]# eq 'NP'>
Nassau
<cfelseif #egetprevious.mags[z]# eq 'SP'>
Suffolk
<cfelse>
#egetprevious.mags[z]#
</Cfif> Parent<Br>
<br>
#egetprevious.writeup[z]#<br>
TO PICKUP <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#&pickup=#egetprevious.id[z]#">CLICK HERE</a><br>
--------------------------------------------------------------------------------
<br><br>
</cfloop>

</cfif>
<p>

Sincerely, 
<cfif #magme# is not 'Queens'>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
<cfelse>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
</Cfif>

</cfmail>
</cfif>
</cfoutput> 
 
	</cfloop>	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	---->
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
<!-- Final Email -->

	
	<cfquery name="getfirst" dataSource="#ds#">
	select * from newwriteupmaster
	where 1 = 1
	and thirdemail = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
	
	
	<cfloop from ="1" to="#getfirst.recordcount#" index="i">


<cfquery name="getstuff" datasource="#ds#">
 select distinct ParentsListings.id,ParentsListings.contactemail,ParentsListings.email,ParentsListings.name,ParentsListings.region,issueguide.id as issueguideid,ParentsListings.salesperson
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
  issueguidecat.mags like '%#getfirst.mags[i]#%'
<Cfif #getfirst.catnumber[i]# does not contain ','>
 and issueguide.catid = #getfirst.catnumber[i]#
 <cfelse>
 and issueguide.catid IN (#getfirst.catnumber[i]#)

</Cfif> 
	  and issueguide.writeup = ''

 and issueguidecat.issue = '#dateformat(getfirst.month[i],'mmmm yyyy')#'
<!--- and ParentsListings.salesperson = '[email protected]'
--->

 </cfquery>
 
 
 <Cfoutput query="Getstuff">

<cfif #getstuff.contactemail# is not ''>
	<cfset emailto = '#getstuff.contactemail#'>
<cfelse>
<cfset emailto = '#getstuff.email#'>	
</cfif>


<cfif isvalid ('email',#emailto#) or #emailto# contains 'croteman'> 
	
	
<cfquery name="eGetstuff" datasource="#ds#">
select *
from issueguide
where id = #getstuff.issueguideid#
</cfquery>
<Cfquery name="eGetmorestuff" dataSource="#ds#">
SELECT * FROM issueguidecat WHERE issueguideid = #getstuff.issueguideid#
</cfquery>
      <Cfquery name="eGetregions" datasource="#ds#">
SELECT *
FROM ParentsListingsCatMain
where id = #egetstuff.catid#
order by catname
</CFQUERY>

<Cfset lastmonth = dateadd('m',-1, currentdatetime)>
<Cfset lastmonth = dateformat(lastmonth,'m')>

<cfquery name="egetprevious" dataSource="#ds#">
select issueguide.id,issueguide.writeup,issueguidecat.mags,issueguidecat.issuemy,issueguidecat.issue
from issueguide inner join issueguidecat on issueguide.id = issueguidecat.issueguideid
where issueguide.pkid = #eGetstuff.pkid#
 and issueguide.writeup <> ''
and issueguide.id <> #getstuff.issueguideid#
order by issueguide.id desc
limit 0,12
</cfquery>

<Cfquery name="eGetname" datasource="#ds#">
select *
from ParentsListings
where id = #eGetstuff.pkid#
</Cfquery>

<cfset monthme = #dateformat(getfirst.month[i],'mmmm yyyy')#>
	<Cfif #getfirst.mags[i]# eq 'RP'>
<cfset magme = "Rockland">
<cfelseif #getfirst.mags[i]# eq 'BAP'>
<cfset magme = "Big Apple">
<cfelseif #getfirst.mags[i]# eq 'WP'>
<cfset magme = "Westchester">
<cfelseif #getfirst.mags[i]# eq 'BP'>
<cfset magme = "Brooklyn">
<cfelseif #getfirst.mags[i]# eq 'QP'>
<cfset magme = "Queens">
<cfelseif #getfirst.mags[i]# eq 'FP'>
<cfset magme = "Fairfield">
<cfelseif #getfirst.mags[i]# eq 'NP'>
<cfset magme = "Nassau">
<cfelseif #getfirst.mags[i]# eq 'SP'>
<cfset magme = "Suffolk">
<cfelse>
<cfset magme = "#getfirst.mags[i]#">
</Cfif>

<cfif #magme# is not 'Queens'>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
<cfelse>
<cfset fromme = 'Alice Van Dyke <[email protected]>'>
</Cfif>

<Cfset sendtosales = '#getstuff.salesperson#'>
<Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected]'> 
	</Cfif>
<Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected],[email protected]'> 
	</Cfif>
	
<Cfif #sendtosales# eq '[email protected]'>
	<Cfset sendtosales = '[email protected],[email protected]'> 
	</Cfif>
	

#emailto#,#sendtosales# - 
#name# Last Call To Get Your Write-Up in #monthme# #magme# #getfirst.directory[i]# Magazine<p>
	
	
	 <CFMAIL
TO="#emailto#,#sendtosales#"
SUBJECT="#name#: Your #monthme# #magme# #getfirst.directory[i]# Parent Write-Up is Due"
        FROM="#fromme#"
            SERVER="127.0.0.1"
bcc = "[email protected]"

type="html">
<p>

Dear #name#, 


The #monthme# issue of <Cfif #getfirst.mags[i]# eq 'RP'>
Rockland
<cfelseif #getfirst.mags[i]# eq 'BAP'>
Big Apple
<cfelseif #getfirst.mags[i]# eq 'WP'>
Westchester
<cfelseif #getfirst.mags[i]# eq 'BP'>
Brooklyn
<cfelseif #getfirst.mags[i]# eq 'QP'>
Queens
<cfelseif #getfirst.mags[i]# eq 'FP'>
Fairfield
<cfelseif #getfirst.mags[i]# eq 'NP'>
Nassau
<cfelseif #getfirst.mags[i]# eq 'SP'>
Suffolk
<cfelse>
#getfirst.mags[i]#
</Cfif> Parent is going to press soon. We would like to include a 90-word write-up, highlighting your business in the directory. This is an important part of your advertising package. Since our magazines are on tight deadlines with our printer, write-ups must be in by tomorrow at noon to be included. 
Thank you for your submission.

<p>

To submit a write-up please click on the link next to the write-up you would like to run. To submit a new write-up please click here: <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#">http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#</a><p>


<Cfif #egetprevious.recordcount# gte 1> 


To pick-up a write-up that you've run before, please review this page to select the write-up you'd like to continue to run in the #monthme# directory: 
<p>

<cfloop from="1"  to="#egetprevious.recordcount#" index="z">


#egetprevious.issue[z]# - <Cfif #egetprevious.mags[z]# eq 'RP'>
Rockland
<cfelseif #egetprevious.mags[z]# eq 'BAP'>
Big Apple
<cfelseif #egetprevious.mags[z]# eq 'WP'>
Westchester
<cfelseif #egetprevious.mags[z]# eq 'BP'>
Brooklyn
<cfelseif #egetprevious.mags[z]# eq 'QP'>
Queens
<cfelseif #egetprevious.mags[z]# eq 'FP'>
Fairfield
<cfelseif #egetprevious.mags[z]# eq 'NP'>
Nassau
<cfelseif #egetprevious.mags[z]# eq 'SP'>
Suffolk
<cfelse>
#egetprevious.mags[z]#
</Cfif> Parent<Br>
 <br>
#egetprevious.writeup[z]#<br>
TO PICKUP <a href="http://www.nymetroparents.com/addwriteup.cfm?id=#getstuff.issueguideid#&pickup=#egetprevious.id[z]#">CLICK HERE</a><br>
--------------------------------------------------------------------------------
<br><br>
</cfloop>




</cfif>
<p>

Sincerely, 
<cfif #magme# is not 'Queens'>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
<cfelse>
Alice Van Dyke, Directories Editor , NYMetroParents<br>
[email protected]
</Cfif>

</cfmail>
</cfif>
</cfoutput> 
 
	</cfloop>