USP_FAFDEFAULTCOMMUNICATIONTEMPLATES
Perform creation of default communication templates.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @CLIENTSITESID | int | IN | |
| @USERID | int | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_FAFDEFAULTCOMMUNICATIONTEMPLATES
(
@EVENTID uniqueidentifier,
@CLIENTSITESID int,
@USERID int,
@CHANGEAGENTID uniqueidentifier = null
)
as
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
begin try
declare @EMAILTEMPLATEID uniqueidentifier = null
declare @ISPREVIOUSEVENT int = 1
declare @PREVIOUSEVENTVALUE uniqueidentifier
select @PREVIOUSEVENTVALUE = PRIORYEAREVENTID from EVENTEXTENSION
where EVENTID= @EVENTID
if @PREVIOUSEVENTVALUE is null
set @ISPREVIOUSEVENT = 0
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Thank you for your gift',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>Thank you for your generous donation. Because of your donation, and gifts from others, I raised <img src="insertField.field?id=640&nmode=0&name=Participant+total+amount+raised+to+date&type=15" style="cursor: move;" title="Participant total amount raised to date" data-runat="server" data-fieldid="640" data-attribid="0" data-fieldName="Participant total amount raised to date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> so far toward my <img src="insertField.field?id=635&nmode=0&name=Participant+target+fundraising+goal&type=15" style="cursor: move;" title="Participant target fundraising goal" data-runat="server" data-fieldid="635" data-attribid="0" data-fieldName="Participant target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> goal.</p>
<p>I will participate in the <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" data-runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" data-runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>Thanks again for your support.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='BFA1EDF5-70CC-4F68-90B5-6404535F85A8',
@ISDEFAULTFORTASK=1;
--- 5.1 recruit previous members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Join me in my fundraising efforts',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>Last year’s <img src="insertField.field?id=2000&nmode=0&name=Previous+event+name&type=15" style="cursor: move;" title="Previous event name" runat="server" data-fieldid="2000" data-attribid="0" data-fieldName="Previous event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> was a success because of support from people like you. This year, I’m participating in <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, and would greatly appreciate your support again.</p>
<p>I started a fundraising <img src="insertField.field?id=1436&nmode=0&name=Group+type+name&type=15" style="cursor: move;" title="Group type name" runat="server" data-fieldid="1436" data-attribid="0" data-fieldName="Group type name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" runat="server" data-fieldid="1430" data-attribid="0" data-fieldName="Group name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, and hope you’ll consider joining our group and help us reach our <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" runat="server" data-fieldid="1515" data-attribid="0" data-fieldName="Group total amount goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> goal. To join <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" runat="server" data-fieldid="1430" data-attribid="0" data-fieldName="Group name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, visit <img src="insertField.field?id=1440&nmode=0&name=Group+page+URL+with+tracking&type=15" style="cursor: move;" title="Group page URL with tracking" runat="server" data-fieldid="1440" data-attribid="0" data-fieldName="Group page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and click the <strong>Join my</strong> button in the page to register for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>I’m also hoping you’ll ask everyone you know to support you and <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. Use the participant tools to ask your friends, family, and colleagues to support <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" runat="server" data-fieldid="1430" data-attribid="0" data-fieldName="Group name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> either through donation or participation in <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>As always, your support means a lot to me and will make a world of difference.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='915ACAF1-03CF-4119-A2A9-2B747877A97B',
@ISDEFAULTFORTASK=1;
---5.2. Recruit prospects as members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Join me in my fundraising efforts',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>I’m writing to ask you to join me in supporting <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. As you may be aware, <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> uses events such as <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to raise awareness and generate support.</p>
<p>I’m excited about <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, and hope you’ll join me by registering for this event. To participate and help us, please visit <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and select register at the top of the page.</p>
<p>Together, we can make a difference.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='4381BC96-7888-4F63-A022-D443AFD43730',
@ISDEFAULTFORTASK=1;
---5.3. Follow up- ask again (join)
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I need your help',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>I’m following up on an email I sent to you on behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to be held on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. As I mentioned in the previous email, <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> use events such as these to raise awareness. Your support will make a world of difference.</p>
<p>I hope you’ll join me by registering to participate in this event. To register, please visit <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and select register at the top of the page.</p>
<p>If I can answer any questions about <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, don’t hesitate to contact me via phone or email.</p>
<p>Regards,<strong> </strong></p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>
<p><img src="insertField.field?id=2280&nmode=0&name=My+My+phone+number&type=15" style="cursor: move;" title="My phone number" data-runat="server" data-fieldid="2280" data-attribid="0" data-fieldName="My phone number" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>
<p><img src="insertField.field?id=2285&nmode=0&name=My+email&type=15" style="cursor: move;" title="My email" data-runat="server" data-fieldid="2285" data-attribid="0" data-fieldName="My email" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='5C9C50EB-0F11-4F93-82F4-9F640914EE43',
@ISDEFAULTFORTASK=1;
---5.4. Solicit previous donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'We appreciate your generosity',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>Thank you again for your thoughtful donation of <img src="insertField.field?id=1410&nmode=0&name=Contact+last+year+donation+amount&type=15" style="cursor: move;" title="Contact last year donation amount" runat="server" data-fieldid="1410" data-attribid="0" data-fieldName="Contact last year donation amount" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> for <img src="insertField.field?id=2000&nmode=0&name=Previous+event+name&type=15" style="cursor: move;" title="Previous event name" runat="server" data-fieldid="2000" data-attribid="0" data-fieldName="Previous event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. We couldn’t do what we do without donors like you. The event was a great success Thanks in part, to you.</p>
<p>I realize that in today’s economy, we’re more mindful of how (and where) we spend our money. I wouldn’t ask for your support again if it wasn’t for a good cause.</p>
<p>Can you give again <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to show your support for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />?</p>
<p>Our goal this year is to raise <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" runat="server" data-fieldid="1515" data-attribid="0" data-fieldName="Group total amount goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. To make your generous contribution, visit <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and enter the amount you want to contribute. <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> will take place on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>Thanks again for your support.</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='DC524E0B-5B62-4312-A474-4DDD321BBB5F',
@ISDEFAULTFORTASK=1;
---5.5. Solicit Prospects as donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I need your help',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p><img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> is putting together <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to raise money.</p>
<p>I’m writing because I need your help. I’m participating in <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> this year, and my goal is to raise <img src="insertField.field?id=635&nmode=0&name=Participant+target+fundraising+goal&type=15" style="cursor: move;" title="Participant target fundraising goal" runat="server" data-fieldid="635" data-attribid="0" data-fieldName="Participant target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. I realize that in today’s economy, asking you to stretch your dollars even further is a monumental request. But, I’m hoping we can count on your support.</p>
<p>To make your generous contribution, visit <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and enter the amount you want to contribute. The only way we can continue to make a difference is through support of donors like you.</p>
<p>I really appreciate your generous contribution.</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='3C9948AF-68A0-4C05-B707-53B41416976E',
@ISDEFAULTFORTASK=1;
---5.6. Follow Up - ask again (give)
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I need your help',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>I’m following up on an email I sent to you on behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to be held on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>Without a doubt, it is because of support from people like you that we can continue to make a difference in the lives of so many others. I’ve started my fundraising with a personal donation, and would greatly appreciate your support in helping me reach my fundraising goal of <img src="insertField.field?id=635&nmode=0&name=Participant+target+fundraising+goal&type=15" style="cursor: move;" title="Participant target fundraising goal" runat="server" data-fieldid="635" data-attribid="0" data-fieldName="Participant target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>Please visit my personal page at <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> to make your donation today.</p>
<p>Thank you for taking the time to read this email, and for your kind support.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='F1BA1497-C8FA-49FE-B2F7-A10A75B37D26',
@ISDEFAULTFORTASK=1;
--- 5.7. Encourage members to solicit new donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Send email to ask for support',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>Thank you for your commitment to support <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. You set a personal goal to raise <img src="insertField.field?id=1413&nmode=0&name=Contact+target+fundraising+goal&type=15" style="cursor: move;" title="Contact target fundraising goal" runat="server" data-fieldid="1413" data-attribid="0" data-fieldName="Contact target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. To date, you have raised <img src="insertField.field?id=1411&nmode=0&name=Contact+raised+to+date&type=15" style="cursor: move;" title="Contact raised to date" runat="server" data-fieldid="1411" data-attribid="0" data-fieldName="Contact raised to date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>We understand it is a little harder for people to give today because of the economy. But, don’t let it stop your solicitation efforts. Reach out to your contacts. Invite them to make an online donation.</p>
<p>The <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> is quickly approaching. Contact your potential donors today.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='528F5466-252C-4D9B-A171-6679865ABD99',
@ISDEFAULTFORTASK=1;
--- 5.9. Congratulate team members on gift (and remind to thank donors)
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Congratulations for a job well done',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p>Good job on getting that donation! To date, you have raised <img src="insertField.field?id=1411&nmode=0&name=Contact+raised+to+date&type=15" style="cursor: move;" title="Contact raised to date" runat="server" data-fieldid="1411" data-attribid="0" data-fieldName="Contact raised to date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. Your personal fundraising goal is <img src="insertField.field?id=1413&nmode=0&name=Contact+target+fundraising+goal&type=15" style="cursor: move;" title="Contact target fundraising goal" runat="server" data-fieldid="1413" data-attribid="0" data-fieldName="Contact target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>Send your donor an email right away as a gesture of your appreciation. To get started with the email, click the Thank all donors button on your personal dashboard. The sample email is ready for you to send.</p><p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='AF06A84E-4297-4DC7-A751-3E67CB89EA9D',
@ISDEFAULTFORTASK=1;
--- 5.10. Help underperforming members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I?m here to help you reach your goal',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p><img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> is fast approaching. Your personal fundraising goal is <img src="insertField.field?id=1413&nmode=0&name=Contact+target+fundraising+goal&type=15" style="cursor: move;" title="Contact target fundraising goal" runat="server" data-fieldid="1413" data-attribid="0" data-fieldName="Contact target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. To date, you have raised <img src="insertField.field?id=1411&nmode=0&name=Contact+raised+to+date&type=15" style="cursor: move;" title="Contact raised to date" runat="server" data-fieldid="1411" data-attribid="0" data-fieldName="Contact raised to date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, and recruited <img src="insertField.field?id=1415&nmode=0&name=Contact+participants+recruited&type=15" style="cursor: move;" title="Contact participants recruited" runat="server" data-fieldid="1415" data-attribid="0" data-fieldName="Contact participants recruited" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />.</p>
<p>To ramp up your fundraising efforts, you may want to take a look at your dashboard to see who you need to contact and what you need to do to draw more people to your personal page so they can support you and <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. Also, periodically monitor your fundraising progress on your personal dashboard to stay on top of your fundraising activities so that you can meet your fundraising goal.</p>
<p>I’m here to help you. Contact me if you have questions.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>
<p><img src="insertField.field?id=2280&nmode=0&name=My+phone+number&type=15" style="cursor: move;" title="My phone number" data-runat="server" data-fieldid="2280" data-attribid="0" data-fieldName="My phone number" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>
<p><img src="insertField.field?id=2285&nmode=0&name=My+email&type=15" style="cursor: move;" title="My email" data-runat="server" data-fieldid="2285" data-attribid="0" data-fieldName="My email" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='5EC41D37-D0E2-41D5-8A71-7F6FB984A26B',
@ISDEFAULTFORTASK=1;
--- 5.11. Ask members to recruit more members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Ask previous members and contacts to join',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p><img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> is fast approaching. Your personal recruiting goal is <img src="insertField.field?id=1414&nmode=0&name=Contact+participants+to+recruit&type=15" style="cursor: move;" title="Contact participants to recruit" runat="server" data-fieldid="1414" data-attribid="0" data-fieldName="Contact participants to recruit" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />, and you have recruited <img src="insertField.field?id=1415&nmode=0&name=Contact+participants+recruited&type=15" style="cursor: move;" title="Contact participants recruited" runat="server" data-fieldid="1415" data-attribid="0" data-fieldName="Contact participants recruited" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to date.</p>
<p>You need to recruit more people. Send them email and ask them to join <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. To help you get started, click the Invite now button in your personal dashboard. The sample email is ready for you to send to your contacts.</p>
<p>I’m here to help you. Contact me if you have questions.</p>
<p>Regards,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>
<p><img src="insertField.field?id=2280&nmode=0&name=My+phone+number&type=15" style="cursor: move;" title="My phone number" data-runat="server" data-fieldid="2280" data-attribid="0" data-fieldName="My phone number" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='DAFC2DAB-6160-419A-992F-B4CA63E32AA0',
@ISDEFAULTFORTASK=1;
--- 5.12. Recruit team leaders
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Please join us in our efforts',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" />,</p>
<p>I’ve singed up to be the company leader for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> and I need your help. As company leader, it’s my job to recruit company team captains for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> to help us reach our company goals. With your help we hope to have <img src="insertField.field?id=1571&nmode=0&name=Group+number+of+teams+goal&type=15" style="cursor: move;" title="Group number of teams goal" data-runat="server" data-fieldid="1571" data-fieldname="Group number of teams goal" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> teams, <img src="insertField.field?id=1560&nmode=0&name=Group+number+of+team+members+goal&type=15" style="cursor: move;" title="Group number of team members goal" data-runat="server" data-fieldid="1560" data-fieldname="Group number of team members goal" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> team members and raise <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" />. Will you join our efforts and lead your department as team captain?</p>
<p>As a <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> team captain, your role is to recruit fellow employees to join your team. <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> is a great event to support <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" data-runat="server" data-fieldid="1990" data-fieldname="Event organization name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> and this year we’re hoping to make a huge impact, but your participation is crucial.</p>
<p>Please visit our company page to sign up your team: <img src="insertField.field?id=1439&nmode=0&name=Group+page+URL&type=15" style="cursor: move;" title="Group page URL" data-runat="server" data-fieldid="1439" data-fieldname="Group page URL" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="False" data-isloop="False" />. Thank you for consideration and I hope you’ll join our efforts to raise <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> for <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" />.</p>
<p>Thank you,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-searchable="0" data-attribid="0" data-htmlencode="True" data-isloop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='92B60774-136A-4C96-BB40-D787D78BB12E',
@ISDEFAULTFORTASK=1;
--- 5.13. Remind leaders to ask new donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Send email to ask for donations',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for being <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-="" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> team leader. I really appreciate your commitment to <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-="" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />. As a team leader, we need your help to get everyone excited and fundraising. If we all work together we’ll be able to reach our <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> company goal.</p>
<p>Did you know that participants who personalize their webpage are more successful fundraisers? It’s true. Your reasons for participating will inspire others to join or donate. Get started today! Login to your <img src="insertField.field?id=372&nmode=0&name=Event+login+link+begin&type=15" style="cursor: move;" title="Event login link begin" data-runat="server" data-fieldid="372" data-fieldname="Event login link begin" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />fundraising headquarters<img src="insertField.field?id=373&nmode=0&name=Event+login+link+end&type=15" style="cursor: move;" title="Event login link end" data-runat="server" data-fieldid="373" data-fieldname="Event login link end" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />.</p>
<p><strong>My Fundraising Task List:</strong></p>
<ol> <li>Personalize my webpage by uploading a photo and sharing my reasons for supporting <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-="" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />.</li> <li>Upload my gmail, yahoo and hotmail contacts into my address book.</li> <li>Send emails asking for donations. Start off by using one of the pre-written messages and add you’re why involved.</li> </ol>
<p>If you need help with your team, feel free to reach out to me – I’m here to help. Thank you for taking on a leadership role with our team.</p>
<p>Keep up the good work,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='F05FD1BA-F4F2-4923-A585-D11CAB73BE5D',
@ISDEFAULTFORTASK=1;
--- 5.14. Remind leaders to ask prior event donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Ask prior event donors to donate',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for being a <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> team leader? Need a quick tip to reach your fundraising goal? A great way to reach your goal is to connect with contacts who donated to you last year. These donors know that <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> is important to you and will want to support your fundraising efforts again this year.</p>
<p>Login to your headquarters and check your dashboard to view your donors from prior events. Click <strong>Ask Now</strong> and send them an email asking for their support again this year.</p>
<p>If you need help with your fundraising, feel free to reach out to me – I’m here to help. Thank you for taking on a leadership role with our team.</p>
<p>Keep up the good work,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='8365FF3D-DEF9-476D-98E0-98B3DD976672',
@ISDEFAULTFORTASK=1;
--- 5.15. Thank company donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Thank you for your gift',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for the generous donation you made to our <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> fundraising efforts! Your contribution has brought our fundraising results to a total of <img src="insertField.field?id=1520&nmode=0&name=Group+total+amount+raised+to+date&type=15" style="cursor: move;" title="Group total amount raised to date" data-runat="server" data-fieldid="1520" data-fieldname="Group total amount raised to date" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> – which counts toward our overall <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> goal of raising <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />.</p>
<p>On behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" data-runat="server" data-fieldid="1990" data-fieldname="Event organization name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />, thank you for making a difference!</p>
<p>Thank you,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='D831EA10-BCF7-49DF-9DF5-169C2C4B407B',
@ISDEFAULTFORTASK=1;
--- 5.16. Ask leaders to recruit more members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Remind prior event members and contacts to join',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you being a <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> team leader! Need help recruiting members for your team? Here’s a quick tip. A great way to reach your recruitment goal is to reconnect with last year’s team members. Ask them to join your team again this year. Share your favorite team memory from last year’s event to remind team members of the fun they’ll have again this year at <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />.</p>
<p>Login to your <img src="insertField.field?id=372&nmode=0&name=Event+login+link+begin&type=15" style="cursor: move;" title="Event login link begin" data-runat="server" data-fieldid="372" data-fieldname="Event login link begin" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />headquarters<img src="insertField.field?id=373&nmode=0&name=Event+login+link+end&type=15" style="cursor: move;" title="Event login link end" data-runat="server" data-fieldid="373" data-fieldname="Event login link end" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> and check your team dashboard. The dashboard will tell you who was on your team last year, but has not again this year. Click <strong>Ask to join</strong> and send them an email.</p>
<p>If you need help building your team, feel free to reach out to me – I’m here to help. Thank you for your support and keep up the good work!</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='01100966-85DB-4A89-B05F-653BD719727C',
@ISDEFAULTFORTASK=1;
--- 5.17. Help team leaders reach their goal
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I''m here to help you reach your goal',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for being a <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> team leader! You are crucial in helping <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> reach our <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> company goal. But, you’re not alone; I’m here to help you with your team. Here are a few key tips that are sure to boost your team results. Please share these with your team members.</p>
<p><strong><img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> Fundraising Task List:</strong></p>
<ol> <li><strong>Personalize your webpage</strong> by uploading a photo and sharing your reasons for supporting <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-="" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />.</li> <li><strong>Upload your gmail, yahoo and hotmail contacts</strong> into your address book.</li> <li><strong>Send emails</strong> asking for donations. Start off by using one of the pre-written messages and add you’re why involved.</li> <li><strong>Get started today! Login to your <img src="insertField.field?id=372&nmode=0&name=Event+login+link+begin&type=15" style="cursor: move;" title="Event login link begin" data-runat="server" data-fieldid="372" data-fieldname="Event login link begin" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />headquarters<img src="insertField.field?id=373&nmode=0&name=Event+login+link+end&type=15" style="cursor: move;" title="Event login link end" data-runat="server" data-fieldid="373" data-fieldname="Event login link end" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />.<br /></strong></li> </ol>
<p><strong></strong>Every email you send makes a difference. Every tweet and Facebook update you post gets the word out. And every time you receive a donation, you’re making a difference!</p>
<p>If you need help with any of these suggestions, feel free to reach out to me - I’m here to help.</p>
<p>Thank you for being a <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> leader and keep up the good work!</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='3F013D73-F08D-4F3C-947C-931AAC0B84A9',
@ISDEFAULTFORTASK=1;
--- 5.18. Thank your team leaders
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Thanks for being a part of my team',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for being a team leader! I really appreciate all your hard work in helping <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" /> make a difference in our community.</p>
<p>On behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" data-runat="server" data-fieldid="1990" data-fieldname="Event organization name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />, thank you for your support and helping to make <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-="" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> a huge success!</p>
<p>Thank you,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='3995B401-600B-4C0D-9741-471B90E76925',
@ISDEFAULTFORTASK=1;
--- 5.19. Thank team donors
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Thank you for your gift',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for the generous donation you made to our <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> fundraising efforts! Your contribution has brought our fundraising results to a total of <img src="insertField.field?id=1520&nmode=0&name=Group+total+amount+raised+to+date&type=15" style="cursor: move;" title="Group total amount raised to date" data-runat="server" data-fieldid="1520" data-fieldname="Group total amount raised to date" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> – which counts toward our overall <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> goal of raising <img src="insertField.field?id=1515&nmode=0&name=Group+total+amount+goal&type=15" style="cursor: move;" title="Group total amount goal" data-runat="server" data-fieldid="1515" data-fieldname="Group total amount goal" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />.</p>
<p>On behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" data-runat="server" data-fieldid="1990" data-fieldname="Event organization name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />, thank you for making a difference!</p> <p>Thank you,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='783506F7-4407-4442-8044-D637FFDDF1E3',
@ISDEFAULTFORTASK=1;
--- 5.20. Thank your team members
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'Thanks for being a part of my team',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" data-runat="server" data-fieldid="1400" data-fieldname="Contact first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" data-runat="server" data-fieldid="1405" data-fieldname="Contact last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />,</p>
<p>Thank you for being a part of <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />. Your hard work and support helped us raise <img src="insertField.field?id=1520&nmode=0&name=Group+total+amount+raised+to+date&type=15" style="cursor: move;" title="Group total amount raised to date" data-runat="server" data-fieldid="1520" data-fieldname="Group total amount raised to date" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />! I hope you had a great time being on <img src="insertField.field?id=1430&nmode=0&name=Group+name&type=15" style="cursor: move;" title="Group name" data-runat="server" data-fieldid="1430" data-fieldname="Group name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> and supporting <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" />.</p>
<p>On behalf of <img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" data-runat="server" data-fieldid="1990" data-fieldname="Event organization name" data-fieldtype="15" data-attribid="0" data-htmlencode="True" data-searchable="0" data-isloop="False" />, thank you for your support and helping to make <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" data-runat="server" data-fieldid="305" data-fieldname="Event name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> a huge success!</p>
<p>Thank you,</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" data-runat="server" data-fieldid="2270" data-fieldname="My first name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" data-runat="server" data-fieldid="2275" data-fieldname="My last name" data-fieldtype="15" data-isloop="False" data-htmlencode="True" data-attribid="0" data-searchable="0" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='E22B132E-518F-4E46-8B22-91BA15722D3B',
@ISDEFAULTFORTASK=1;
--- 5.21. Send a new message
exec dbo.USP_DATAFORMTEMPLATE_ADD_PARTICIPANTCOMMUNICATIONTEMPLATES_3
@SUBJECT=N'I need your help',
@USERID=@USERID,
@CLIENTSITEID=@CLIENTSITESID,
@CONTENTHTML=N'<p>Dear <img src="insertField.field?id=1400&nmode=0&name=Contact+first+name&type=15" style="cursor: move;" title="Contact first name" runat="server" data-fieldid="1400" data-attribid="0" data-fieldName="Contact first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=1405&nmode=0&name=Contact+last+name&type=15" style="cursor: move;" title="Contact last name" runat="server" data-fieldid="1405" data-attribid="0" data-fieldName="Contact last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />,</p>
<p><img src="insertField.field?id=1990&nmode=0&name=Event+organization+name&type=15" style="cursor: move;" title="Event organization name" runat="server" data-fieldid="1990" data-attribid="0" data-fieldName="Event organization name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> is putting together <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> on <img src="insertField.field?id=320&nmode=0&name=Event+start+date&type=15" style="cursor: move;" title="Event start date" runat="server" data-fieldid="320" data-attribid="0" data-fieldName="Event start date" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> at <img src="insertField.field?id=315&nmode=0&name=Event+location&type=15" style="cursor: move;" title="Event location" runat="server" data-fieldid="315" data-attribid="0" data-fieldName="Event location" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> to raise money.</p>
<p>I’m writing because I need your help. I’m participating in <img src="insertField.field?id=305&nmode=0&name=Event+name&type=15" style="cursor: move;" title="Event name" runat="server" data-fieldid="305" data-attribid="0" data-fieldName="Event name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> this year, and my goal is to raise <img src="insertField.field?id=635&nmode=0&name=Participant+target+fundraising+goal&type=15" style="cursor: move;" title="Participant target fundraising goal" runat="server" data-fieldid="635" data-attribid="0" data-fieldName="Participant target fundraising goal" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" />. I realize that in today’s economy, asking you to stretch your dollars even further is a monumental request. But, I’m hoping we can count on your support.</p>
<p>To make your generous contribution, visit <img src="insertField.field?id=612&nmode=0&name=Participant+page+URL+with+tracking&type=15" style="cursor: move;" title="Participant page URL with tracking" runat="server" data-fieldid="612" data-attribid="0" data-fieldName="Participant page URL with tracking" data-fieldType="15" data-htmlEncode="False" data-searchable="0" data-isLoop="False" /> and enter the amount you want to contribute. The only way we can continue to make a difference is through support of donors like you.</p>
<p>I really appreciate your generous contribution.</p>
<p><img src="insertField.field?id=2270&nmode=0&name=My+first+name&type=15" style="cursor: move;" title="My first name" runat="server" data-fieldid="2270" data-attribid="0" data-fieldName="My first name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /> <img src="insertField.field?id=2275&nmode=0&name=My+last+name&type=15" style="cursor: move;" title="My last name" runat="server" data-fieldid="2275" data-attribid="0" data-fieldName="My last name" data-fieldType="15" data-htmlEncode="True" data-searchable="0" data-isLoop="False" /></p>',
@CHANGEAGENTID=@CHANGEAGENTID,
@EVENTID=@EVENTID,
@FAFTASKID='051AAAD9-C4C9-4204-8441-CD40E1C783C1',
@ISDEFAULTFORTASK=1;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;