query9.query242.header=Anschreiben (GI): ERST-Spender ohne Folgespenden in einem Zeitraum (per Mail)
query9.query242.domains=1
query9.query242.database=1001
query9.query242.sql=select A.SPENDEORT,CONVERT(VARCHAR(10),A.SPENDEDAT,104) as SDAT,B.SPENDERX,B.NAME,B.VORNAME,CONVERT(VARCHAR(10),B.GEBDAT,104) as GDAT,B.SEX,B.TITEL,C.BLUTGR as AB0,C.RHFAKT,B.ADRESSE,B.PLZ,B.ORT,B.TELPRIV,B.TELPRIV2,B.TELDIENST,B.EMAIL,B.ARZTSTAT from SPENDE A,SPENDER B,BLUTMERKMAL C,TERMIN D where A.SPENDEDAT between ? and ? and A.SPENDEART='VB' and A.SPENDEORT in ('G') and A.SPENDETOTAL=1 and B.SPENDERX=A.SPENDERX and B.ARZTSTAT='ERST' and B.SPENDERART not like '%E%' and B.ADRESSE is not null and B.ADRESSE not like '%verzogen%' and B.EMAIL is not null and LEN(B.EMAIL)>0 and B.EMAIL not like 'kein%rie%' and B.EMAIL not like 'kein%brei%' and B.GEBDAT>DATEADD(year,-68,GETDATE()) and C.SPENDERX=A.SPENDERX and C.BLUTGR in ({Y}) and C.RHFAKT in ({Z}) and D.SPENDERX=A.SPENDERX and D.STORNODAT is null and D.TERMINDAT < GETDATE() order by A.SPENDEORT,A.SPENDEDAT,B.NAME,B.VORNAME,GDAT
query9.query242.sql.var1={Y}
query9.query242.sql.var1.title=AB0
query9.query242.sql.var1.pattern='0','A','A1','A2','B','AB','A1B','A2B'
query9.query242.sql.var2={Z}
query9.query242.sql.var2.title=RH
query9.query242.sql.var2.pattern='+','-'
query9.query242.sql.param=YES
query9.query242.sql.param.groups=1
query9.query242.excel.output.prefix=ERST_Spender_GI_ohne_Folgespenden_per_Mail
query9.query242.excel.template=
query9.query242.sheet=1
query9.query242.row.begin=1
query9.query242.col.begin=1
query9.query242.mail.template=C:\\SWLTOOLBOX\\MAIL\\Spender_ERST_GI.DEF
query9.query242.mail.UTFtoCP850=YES
query9.query242.mail.content.html=YES
query9.query242.mail.from=swl.mailkonto@mr.uk-gm.de
query9.query242.mail.name=Blutspende-Zentrale UKGM
query9.query242.mail.to=EMAIL
query9.query242.mail.subject=Blutspende rettet Leben
query9.query242.mail.button=Mails versenden
query9.query242.mail.tooltip=Spender in der Liste per Mail anschreiben
query9.query242.mail.button1=Mail versenden
query9.query242.mail.tooltip1=Mail an den Spender/die Spenderin nochmal versenden
query9.query242.mail.salutation.last_name=NAME
query9.query242.mail.salutation.middle_name=
query9.query242.mail.salutation.first_name=VORNAME
query9.query242.mail.salutation.sex=SEX
query9.query242.mail.salutation.title=TITEL
query9.query242.mail.pcheck=
query9.query242.mail.event=YES
query9.query242.mail.event.type=18
query9.query242.mail.event.subtype=1
query9.query242.mail.event.subject=SPENDERX
query9.query242.mail.event.flag=1
query9.query242.mail.event.flag0=0