2000000000
33393404-e29c-482b-8ff5-43e770c6a082
Online Contact Mgmt. Zoom Meeting 1 Day Reminders
Use this recipient group to sent out reminders for forthcoming contact management zoom meetings 1-2 days away
Connect4 Support
true
false
<Query QueryName="" QueryGUID="c0f0fa9a-59aa-4008-b037-dd338a8ca734" SchemaGUID="33393404-e29c-482b-8ff5-43e770c6a082" SchemaVer="534">
<Properties />
<Top>All</Top>
<ResultGrouping>0</ResultGrouping>
<Select>
<ReturnField>
<FieldName>Contact_Events.OnlineMeetingJoinURL</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>0</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
<ReturnField>
<FieldName>Contact_Events.MeetingStartTime</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>1</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
<ReturnField>
<FieldName>Person.EPrimaryEmailAddress</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>2</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
<ReturnField>
<FieldName>Person.PLastName</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>3</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
<ReturnField>
<FieldName>Person.PPrefName</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>4</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
<ReturnField>
<FieldName>Person.PID</FieldName>
<AggregationType>0</AggregationType>
<ReturnSetOrder>5</ReturnSetOrder>
<ReturnSetSortOrder>-1</ReturnSetSortOrder>
<ReturnSortDirection>0</ReturnSortDirection>
</ReturnField>
</Select>
<Where>
<ConditionGroup GroupName="baseGroup" Behavior="0">
<Condition>
<ComparisonFieldName>Contact_Events.HasOnlineMeetingSetup</ComparisonFieldName>
<ComparisonTypeName>is true</ComparisonTypeName>
<AggregationType>0</AggregationType>
<ConditionValues />
<ValueSourceType>0</ValueSourceType>
<ValueSourceTitle />
<DisplayConditionValues />
</Condition>
<Condition>
<ComparisonFieldName>Person.EPrimaryEmailAddress</ComparisonFieldName>
<ComparisonTypeName>is not null</ComparisonTypeName>
<AggregationType>0</AggregationType>
<ConditionValues />
<ValueSourceType>0</ValueSourceType>
<ValueSourceTitle />
<DisplayConditionValues />
</Condition>
<Condition>
<ComparisonFieldName>Contact_Events.MeetingStartTime</ComparisonFieldName>
<ComparisonTypeName>is between</ComparisonTypeName>
<AggregationType>0</AggregationType>
<ConditionValues>
<ConditionValue>1.00:00:00</ConditionValue>
<ConditionValue>1.23:58:00</ConditionValue>
</ConditionValues>
<ValueSourceType>2</ValueSourceType>
<ValueSourceTitle>9a9c9c8b-1b96-4c4d-a15c-33e110fccb05</ValueSourceTitle>
<ValueProviderGUID>9a9c9c8b-1b96-4c4d-a15c-33e110fccb05</ValueProviderGUID>
<DisplayConditionValues>
<DisplayConditionValue>Run Time Plus 1d</DisplayConditionValue>
<DisplayConditionValue>Run Time Plus 1d 23:58</DisplayConditionValue>
</DisplayConditionValues>
</Condition>
</ConditionGroup>
</Where>
</Query>
SELECT Person.PID AS Person_ID, (CASE
WHEN LEN(ISNull(PPrefName,''))>0 THEN PPrefName
WHEN LEN(ISNull(PPrefName,''))=0 AND LEN(ISNull(PFirstName,''))>0 THEN PFirstName
ELSE 'Community Member'
END) AS Preferred_Name, Person.PLastName AS Last_Name, Person.EPrimaryEmailAddress, Contact_Events.MeetingStartTime AS Online_Meeting_Start_Time, Contact_Events.OnlineMeetingJoinURL AS Online_Meeting_Join_URL FROM ( SELECT tbl103_ContactEvent.PCID, tbl103_ContactEvent.PCParentID, tbl103_ContactEvent.PID, tbl103_ContactEvent.PCDate, tbl103_ContactEvent.PCLoggedDate,
tbl103_ContactEvent.PCBy,
tbl_UserID.Name AS PCByName,
tbl103_ContactEvent.CreatedBy AS ContactCreatedBy,
LoggedByUsr.Name AS ContactCreatedByName,
CASE WHEN PCParentID > 0 THEN 1 ELSE 0 END AS PCIsFollowUp,
CASE WHEN tbl103_ContactEvent.PCByEyesOnly = 1 THEN 'Eyes Only' ELSE IsNull(tbl103_ContactEvent.PCSubject,'') END AS PCSubject,
CASE WHEN tbl103_ContactEvent.PCByEyesOnly = 1 THEN 'Eyes Only' ELSE tbl103_ContactEvent.PCNotes END AS PCNotes,
tbl103_ContactEvent.PCHeadCount,
tbl103_ContactEvent.PCComplete,
tbl103_ContactEvent.PCDurationMinutes, tbl103_ContactEvent.PCDurationHoursDecimal,
tbl103_ContactEvent.PCServiceType, RefSvcType.REName AS ServiceTypeName,
tbl103_ContactEvent.PCCategory, RefCategory.REName AS CategoryName,
tbl103_ContactEvent.PCLocationREID AS LocationID,
Reflocation.REName AS LocationName,
tbl103_ContactEvent.OID AS ContactOID,
ORG.OOrgName AS ContactOrgName,
tbl103_ContactEvent.PCContactUserType, CASE WHEN PCContactUserType = 0 THEN PCSystemType ELSE PCUserType END AS ContactTypeID,
RefUserType.REName AS ContactTypeName, DATEDIFF(day, GETUTCDATE(), tbl103_ContactEvent.PCDate) AS DaysTillContactDue,
DATEDIFF(day, tbl103_ContactEvent.PCLoggedDate, GETUTCDATE()) AS DaysSinceContactLogged,
CASE WHEN OLM.OMID IS NOT NULL THEN 1 ELSE 0 END AS HasOnlineMeetingSetup,
OLM.OMJoinURL AS OnlineMeetingJoinURL,
OLM.OMStartURL AS OnlineMeetingStartURL,
OLM.OMNumber AS OnlineMeetingNumber,
OLM.OMPassword AS OnlineMeetingPassword,
OLM.OMAccountName AS OnlineMeetingAccount,
JSONParse.start_time AS MeetingStartTime
FROM tbl_UserID RIGHT OUTER JOIN
tbl103_ContactEvent ON tbl_UserID.ID = tbl103_ContactEvent.PCBy
LEFT OUTER JOIN tbl_UserID LoggedByUsr ON tbl103_ContactEvent.CreatedBy = LoggedByUsr.ID
LEFT OUTER JOIN tbl_RefEntity RefUserType ON CASE WHEN PCContactUserType = 0 THEN PCSystemType ELSE PCUserType END = RefUserType.REID
LEFT OUTER JOIN tbl_RefEntity RefSvcType ON tbl103_ContactEvent.PCServiceType = RefSvcType.REID
LEFT OUTER JOIN tbl_RefEntity RefCategory ON tbl103_ContactEvent.PCCategory = RefCategory.REID
LEFT OUTER JOIN tbl_RefEntity RefLocation ON tbl103_ContactEvent.PCLocationREID = RefLocation.REID
LEFT OUTER JOIN tbl1_Organization ORG ON tbl103_ContactEvent.OID = ORG.OID
CROSS JOIN fn_DACLREFlagValues(@__UserID, '103Categories', 2) DACLFlag
LEFT OUTER JOIN tbl2_OnlineMeeting OLM on tbl103_ContactEvent.PCID = OLM.PCID
CROSS APPLY OPENJSON(OLM.OMConfig) WITH(start_time datetime '$.start_time') AS JSONParse
WHERE ((PCCategory is null)
or (RefCategory.REFlagValue & DACLFlag.FlagTotal = 0 )
or (RefCategory.REFlagValue & DACLFlag.FlagTotalAuthed > 0 )
)
) Contact_Events RIGHT OUTER JOIN dbo.v1_Personv2 Person ON Person.PID = Contact_Events.PID WHERE Contact_Events.HasOnlineMeetingSetup = 1 AND Person.EPrimaryEmailAddress is not Null AND Contact_Events.MeetingStartTime between cast('2022-05-29 17:53:31' as datetime) and cast('2022-05-30 17:51:31' as datetime)
false
2022-05-28T05:50:14
2022-05-28T05:50:14
1000
Connect4 Support
2118
* Persons with H'hold & Org & Related Info
false
2000000000
1021
Contact Mgmt Zoom 1 Day Reminders
Reminder: You have a Zoom meeting scheduled
Person.PPrefName,Contact_Events.PCSubject,Contact_Events.MeetingStartTime,Contact_Events.OnlineMeetingJoinURL,Contact_Events.OnlineMeetingNumber,Contact_Events.OnlineMeetingPassword
STEVESDELLLAPTO
Connect4 Support
1
false
2022-05-28T10:34:07
false
false
2022-05-28T10:50:14
2022-05-28T10:52:44
1000
Connect4 Support
2
false
true
2000000000
1015
"Sender Name" <sender@SenderOrg.org>
1016
<!DOCTYPE html><html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" lang="en"><head><title></title><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><!--[if mso]><xml><o:OfficeDocumentSettings><o:PixelsPerInch>96</o:PixelsPerInch><o:AllowPNG/></o:OfficeDocumentSettings></xml><![endif]--><style>
*{box-sizing:border-box}body{margin:0;padding:0}a[x-apple-data-detectors]{color:inherit!important;text-decoration:inherit!important}#MessageViewBody a{color:inherit;text-decoration:none}p{line-height:inherit}.desktop_hide,.desktop_hide table{mso-hide:all;display:none;max-height:0;overflow:hidden}@media (max-width:655px){.row-content{width:100%!important}.column .border,.mobile_hide{display:none}table{table-layout:fixed!important}.stack .column{width:100%;display:block}.mobile_hide{min-height:0;max-height:0;max-width:0;overflow:hidden;font-size:0}.desktop_hide,.desktop_hide table{display:table!important;max-height:none!important}}
</style></head><body style="background-color:#555;margin:0;padding:0;-webkit-text-size-adjust:none;text-size-adjust:none"><table class="nl-container" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;background-color:#555"><tbody><tr><td><table class="row row-1" align="center" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tbody><tr><td><table
class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;background-color:#fff;color:#333;width:635px" width="635"><tbody><tr><td class="column column-1" width="33.333333333333336%" style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-left:10px;padding-right:10px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="image_block"
width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td style="width:100%;padding-right:0;padding-left:0;padding-top:15px;padding-bottom:5px"><div align="center" style="line-height:10px"><a href="#" target="_blank" style="outline:none" tabindex="-1"><img src="https://gnosismail.s3.amazonaws.com/images/csctemplate-4f71aea0ead04a07b07601259beaac09/Branding/logo-placeholder.jpg"
style="display:block;height:auto;border:0;width:153px;max-width:100%" width="153" alt="Logo" title="Logo"></a></div></td></tr></table></td><td class="column column-2" width="66.66666666666667%" style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="text_block" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation"
style="mso-table-lspace:0;mso-table-rspace:0;word-break:break-word"><tr><td style="padding-bottom:25px;padding-left:10px;padding-right:10px;padding-top:25px"><div style="font-family:sans-serif"><div class="txtTinyMce-wrapper" style="font-family:Arial,Helvetica Neue,Helvetica,sans-serif;font-size:12px;mso-line-height-alt:14.399999999999999px;color:#555;line-height:1.2"><p style="margin:0;text-align:center;font-size:14px">
<span style="color:#d71920;font-size:24px;"><strong>Meeting Reminder</strong></span></p></div></div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table><table class="row row-2" align="center" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tbody><tr><td><table class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation"
style="mso-table-lspace:0;mso-table-rspace:0;background-color:#fff;color:#000;width:635px" width="635"><tbody><tr><td class="column column-1" width="100%" style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-top:0;padding-bottom:10px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="divider_block" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tr>
<td style="padding-bottom:5px;padding-left:10px;padding-right:10px"><div align="center"><table border="0" cellpadding="0" cellspacing="0" role="presentation" width="100%" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td class="divider_inner" style="font-size:1px;line-height:1px;border-top:1px solid #ad1b1e"><span> </span></td></tr></table></div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table><table class="row row-3" align="center" width="100%" border="0"
cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tbody><tr><td><table class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;background-color:#fff;color:#000;width:635px" width="635"><tbody><tr><td class="column column-1" width="100%"
style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-top:5px;padding-bottom:5px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="text_block" width="100%" border="0" cellpadding="10" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;word-break:break-word"><tr><td><div style="font-family:sans-serif"><div class="txtTinyMce-wrapper"
style="font-family:Arial,Helvetica Neue,Helvetica,sans-serif;font-size:12px;mso-line-height-alt:14.399999999999999px;color:#555;line-height:1.2"><p style="margin:0;font-size:14px"><span style="font-size:15px;">Dear «Person.Preferred_Name»,</span></p><p style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px">
<span style="font-size:15px;">We're writing to remind you of a zoom meeting for "«Contact_Events.Contact_Subject»" scheduled to start «Contact_Events.Online_Meeting_Start_Time».</span></p><p style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px"><span style="font-size:15px;">Please login to your session a couple of minutes before the scheduled start time using the join button below.</span></p><p
style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px"><span style="font-size:15px;">We are looking forward to being with you in this meeting. If you are unable to make this scheduled session for any reason, please contact us at your earliest opportunity.</span></p><p style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px">
<span style="font-size:15px;">Warmest regards,</span></p><p style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:14px"><span style="font-size:15px;">Your Support Team</span></p><p style="margin:0;font-size:14px"><span style="font-size:15px;"> </span></p></div></div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table><table
class="row row-4" align="center" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tbody><tr><td><table class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;background-color:#fff;color:#000;width:635px" width="635"><tbody><tr><td class="column column-1" width="100%"
style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-top:5px;padding-bottom:5px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="button_block" width="100%" border="0" cellpadding="10" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td><div align="center">
<!--[if mso]><v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="«Contact_Events.Online_Meeting_Join_URL»" style="height:42px;width:212px;v-text-anchor:middle;" arcsize="10%" stroke="false" fillcolor="#ad1b1e"><w:anchorlock/><v:textbox inset="0px,0px,0px,0px"><center style="color:#ffffff; font-family:Arial, sans-serif; font-size:16px"><![endif]-->
<a href="«Contact_Events.Online_Meeting_Join_URL»" target="_blank" style="text-decoration:none;display:inline-block;color:#ffffff;background-color:#ad1b1e;border-radius:4px;width:auto;border-top:1px solid #ad1b1e;font-weight:400;border-right:1px solid #ad1b1e;border-bottom:1px solid #ad1b1e;border-left:1px solid #ad1b1e;padding-top:5px;padding-bottom:5px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;text-align:center;mso-border-alt:none;word-break:keep-all;"><span style="padding-left:20px;padding-right:20px;font-size:16px;display:inline-block;letter-spacing:normal;"><span style="font-size: 16px; line-height: 2; word-break: break-word; mso-line-height-alt: 32px;">Join Zoom Meeting Now</span></span></a>
<!--[if mso]></center></v:textbox></v:roundrect><![endif]--></div></td></tr></table><table class="text_block" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;word-break:break-word"><tr><td><div style="font-family:sans-serif"><div class="txtTinyMce-wrapper" style="font-size:12px;mso-line-height-alt:14.399999999999999px;color:#555;line-height:1.2;font-family:Arial,Helvetica Neue,Helvetica,sans-serif"><p
style="margin:0;font-size:12px;text-align:center"><span style="font-size:9px;">(Meeting #: «Contact_Events.Online_Meeting_Number», Password: «Contact_Events.Online_Meeting_Password»)</span></p></div></div></td></tr></table><table class="divider_block" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td style="padding-bottom:5px;padding-left:10px;padding-right:10px;padding-top:5px"><div align="center"><table
border="0" cellpadding="0" cellspacing="0" role="presentation" width="100%" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td class="divider_inner" style="font-size:1px;line-height:1px;border-top:1px solid #ad1b1e"><span> </span></td></tr></table></div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table><table class="row row-5" align="center" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0">
<tbody><tr><td><table class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;background-color:#fff;color:#000;width:635px" width="635"><tbody><tr><td class="column column-1" width="100%" style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-top:5px;padding-bottom:5px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="text_block"
width="100%" border="0" cellpadding="5" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;word-break:break-word"><tr><td><div style="font-family:sans-serif"><div class="txtTinyMce-wrapper" style="font-family:Arial,Helvetica Neue,Helvetica,sans-serif;font-size:12px;mso-line-height-alt:14.399999999999999px;color:#555;line-height:1.2"><p style="margin:0;text-align:center;font-size:14px"><span style="font-size:11px;">«EmailFooter»</span></p></div></div></td></tr>
</table><table class="divider_block" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td style="padding-bottom:5px;padding-left:10px;padding-right:10px"><div align="center"><table border="0" cellpadding="0" cellspacing="0" role="presentation" width="100%" style="mso-table-lspace:0;mso-table-rspace:0"><tr><td class="divider_inner" style="font-size:1px;line-height:1px;border-top:1px solid #d71920"><span> </span>
</td></tr></table></div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table><table class="row row-6" align="center" width="100%" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0"><tbody><tr><td><table class="row-content stack" align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;color:#000;width:635px" width="635"><tbody><tr><td
class="column column-1" width="100%" style="mso-table-lspace:0;mso-table-rspace:0;font-weight:400;text-align:left;vertical-align:top;padding-top:5px;padding-bottom:5px;border-top:0;border-right:0;border-bottom:0;border-left:0"><table class="text_block" width="100%" border="0" cellpadding="10" cellspacing="0" role="presentation" style="mso-table-lspace:0;mso-table-rspace:0;word-break:break-word"><tr><td><div style="font-family:sans-serif"><div class="txtTinyMce-wrapper"
style="font-family:Arial,Helvetica Neue,Helvetica,sans-serif;font-size:12px;mso-line-height-alt:14.399999999999999px;color:#555;line-height:1.2"><p style="margin:0;font-size:12px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:12px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:12px;mso-line-height-alt:14.399999999999999px"> </p><p style="margin:0;font-size:12px;mso-line-height-alt:14.399999999999999px"> </p></div>
</div></td></tr></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table><!-- End --></body></html>
1016
{"page":{"body":{"container":{"style":{"background-color":"#555555"}},"content":{"computedStyle":{"linkColor":"#AD1B1E","messageBackgroundColor":"#FFFFFF","messageWidth":"635px"},"style":{"color":"#000000","font-family":"Arial, Helvetica Neue, Helvetica, sans-serif"}},"type":"mailup-bee-page-properties","webFonts":[]},"description":"","rows":[{"columns":[{"grid-columns":4,"modules":[{"descriptor":{"computedStyle":{"class":"center fixedwidth","width":"153.33333333333331px"},"image":{"alt":"Logo","height":"150px","href":"#","src":"https://gnosismail.s3.amazonaws.com/images/csctemplate-4f71aea0ead04a07b07601259beaac09/Branding/logo-placeholder.jpg","width":"250px"},"style":{"padding-bottom":"0px","padding-left":"0px","padding-right":"0px","padding-top":"0px","width":"100%"}},"locked":false,"type":"mailup-bee-newsletter-modules-image","uuid":"cc2a0caf-3b1e-4967-9701-b1b82a84e14f"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"5px","padding-left":"10px","padding-right":"10px","padding-top":"15px"},"uuid":"df00ee7f-02ab-4506-8af8-ee361135ab93"},{"grid-columns":8,"modules":[{"descriptor":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false},"style":{"padding-bottom":"10px","padding-left":"10px","padding-right":"10px","padding-top":"10px"},"text":{"computedStyle":{"linkColor":"#AD1B1E"},"html":"<div class=\"txtTinyMce-wrapper\" style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\" data-mce-style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\"><p style=\"text-align: center; line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"text-align: center; line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"color: rgb(215, 25, 32); line-height: 28px; font-size: 24px;\" data-mce-style=\"color: rgb(215, 25, 32); line-height: 28px; font-size: 24px;\"><strong>Meeting Reminder</strong></span></p></div>","style":{"color":"#555555","font-family":"inherit","line-height":"120%"}}},"locked":false,"type":"mailup-bee-newsletter-modules-text","uuid":"c466f2d0-10c5-49ad-a714-7aa435fbd496"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"15px","padding-left":"0px","padding-right":"0px","padding-top":"15px"},"uuid":"b89f59ec-a39e-44de-85f5-979ac5b536ae"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false,"rowColStackOnMobile":true},"style":{"background-color":"#FFFFFF","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#333","width":"635px"}},"locked":false,"type":"two-columns-4-8-empty","uuid":"4c2e933a-d5ac-4075-b6ce-c42739e37748"},{"columns":[{"grid-columns":12,"modules":[{"descriptor":{"computedStyle":{"align":"center"},"divider":{"style":{"border-top":"1px solid #AD1B1E","width":"100%"}},"style":{"padding-bottom":"5px","padding-left":"10px","padding-right":"10px","padding-top":"0px"}},"locked":false,"type":"mailup-bee-newsletter-modules-divider","uuid":"cb067bce-db52-4d37-a291-91daeaa68f60"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"10px","padding-left":"0px","padding-right":"0px","padding-top":"0px"},"uuid":"3bbe1afb-01c5-41ed-85ab-81a7751ffc34"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false,"rowColStackOnMobile":true},"style":{"background-color":"#FFFFFF","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#000000","width":"635px"}},"locked":false,"type":"one-column-empty","uuid":"b2048edc-de39-4738-810c-aaf39815151e"},{"columns":[{"grid-columns":12,"modules":[{"descriptor":{"computedStyle":{"hideContentOnMobile":false},"style":{"padding-bottom":"10px","padding-left":"10px","padding-right":"10px","padding-top":"10px"},"text":{"computedStyle":{"linkColor":"#AD1B1E"},"html":"<div class=\"txtTinyMce-wrapper\" style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\" data-mce-style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\"><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">Dear «Person.Preferred_Name»,</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">We're writing to remind you of a zoom meeting for \"«Contact_Events.Contact_Subject»\" scheduled to start «Contact_Events.Online_Meeting_Start_Time».</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">Please login to your session a couple of minutes before the scheduled start time using the join button below.</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">We are looking forward to being with you in this meeting. If you are unable to make this scheduled session for any reason, please contact us at your earliest opportunity.</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">Warmest regards,</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"> </p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\">Your Support Team</span></p><p style=\"line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 18px; font-size: 15px;\" data-mce-style=\"line-height: 18px; font-size: 15px;\"> </span></p></div>","style":{"color":"#555555","font-family":"inherit","line-height":"120%"}}},"type":"mailup-bee-newsletter-modules-text","uuid":"b5948cd0-ff6a-4cfd-bf45-23c1726b91cc"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"5px","padding-left":"0px","padding-right":"0px","padding-top":"5px"},"uuid":"a45b0307-05fb-4d0d-8141-6b44a898633d"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false,"rowColStackOnMobile":true},"style":{"background-color":"#FFFFFF","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#000000","width":"635px"}},"locked":false,"type":"one-column-empty","uuid":"157b70cc-bc80-46ee-9db5-eac5629b70d4"},{"columns":[{"grid-columns":12,"modules":[{"descriptor":{"button":{"href":"«Contact_Events.Online_Meeting_Join_URL»","label":"<div class=\"txtTinyMce-wrapper\" style=\"font-size: 14px; line-height: 28px;\" data-mce-style=\"font-size: 14px; line-height: 28px;\"><p style=\"font-size: 16px; line-height: 32px; word-break: break-word;\" data-mce-style=\"font-size: 16px; line-height: 32px; word-break: break-word;\">Join Zoom Meeting Now</p></div>","style":{"background-color":"#ad1b1e","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-radius":"4px","border-right":"0px solid transparent","border-top":"0px solid transparent","color":"#ffffff","font-family":"inherit","font-weight":"400","line-height":"200%","max-width":"100%","padding-bottom":"5px","padding-left":"20px","padding-right":"20px","padding-top":"5px","width":"auto"}},"computedStyle":{"height":42,"hideContentOnMobile":false,"width":212},"style":{"padding-bottom":"10px","padding-left":"10px","padding-right":"10px","padding-top":"10px","text-align":"center"}},"locked":false,"type":"mailup-bee-newsletter-modules-button","uuid":"0a36c13c-312b-4f9e-abe2-35aa3e5cbcc2"},{"descriptor":{"computedStyle":{"hideContentOnMobile":false},"style":{"padding-bottom":"0px","padding-left":"0px","padding-right":"0px","padding-top":"0px"},"text":{"computedStyle":{"linkColor":"#AD1B1E"},"html":"<div class=\"txtTinyMce-wrapper\" style=\"font-size: 12px; line-height: 14px;\" data-mce-style=\"font-size: 12px; line-height: 14px;\"><p style=\"font-size: 12px; text-align: center; line-height: 14px; word-break: break-word;\" data-mce-style=\"font-size: 12px; text-align: center; line-height: 14px; word-break: break-word;\"><span style=\"font-size: 9px; line-height: 10px;\" data-mce-style=\"font-size: 9px; line-height: 10px;\">(Meeting #: «Contact_Events.Online_Meeting_Number», Password: «Contact_Events.Online_Meeting_Password»)</span></p></div>","style":{"color":"#555555","font-family":"inherit","line-height":"120%"}}},"locked":false,"type":"mailup-bee-newsletter-modules-text","uuid":"743ecb57-7b0c-4d74-9811-cbf6a32cf1cb"},{"descriptor":{"computedStyle":{"align":"center"},"divider":{"style":{"border-top":"1px solid #AD1B1E","height":"0px","width":"100%"}},"style":{"padding-bottom":"5px","padding-left":"10px","padding-right":"10px","padding-top":"5px"}},"locked":false,"type":"mailup-bee-newsletter-modules-divider","uuid":"fd97639e-d429-4357-bd5e-94f690a5d90f"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"5px","padding-left":"0px","padding-right":"0px","padding-top":"5px"},"uuid":"d599ae39-965c-4dc5-90f3-2b2c33fb26b7"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false,"rowColStackOnMobile":true},"style":{"background-color":"#FFFFFF","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#000000","width":"635px"}},"locked":false,"type":"one-column-empty","uuid":"85a00ee5-3b74-4079-bfe8-c0430dbf8dcb"},{"columns":[{"grid-columns":12,"modules":[{"descriptor":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false},"style":{"padding-bottom":"5px","padding-left":"5px","padding-right":"5px","padding-top":"5px"},"text":{"computedStyle":{"linkColor":"#AD1B1E"},"html":"<div class=\"txtTinyMce-wrapper\" style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\" data-mce-style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\"><p style=\"text-align: center; line-height: 16px; font-size: 14px; word-break: break-word;\" data-mce-style=\"text-align: center; line-height: 16px; font-size: 14px; word-break: break-word;\"><span style=\"line-height: 13px; font-size: 11px;\" data-mce-style=\"line-height: 13px; font-size: 11px;\">«EmailFooter»</span></p></div>","style":{"color":"#555555","font-family":"inherit","line-height":"120%"}}},"locked":false,"type":"mailup-bee-newsletter-modules-text","uuid":"4abd1425-ebb1-43f6-82c1-a9a1667874b7"},{"descriptor":{"computedStyle":{"align":"center"},"divider":{"style":{"border-top":"1px solid #D71920","width":"100%"}},"style":{"padding-bottom":"5px","padding-left":"10px","padding-right":"10px","padding-top":"0px"}},"locked":false,"type":"mailup-bee-newsletter-modules-divider","uuid":"7be711eb-dacd-417d-a131-7b1c1ce763c9"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"5px","padding-left":"0px","padding-right":"0px","padding-top":"5px"},"uuid":"e4001737-2f12-480d-b213-4c13fa2d23af"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"hideContentOnDesktop":false,"hideContentOnMobile":false,"rowColStackOnMobile":true},"style":{"background-color":"#FFFFFF","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#000000","width":"635px"}},"locked":false,"type":"one-column-empty","uuid":"8f5bc53d-a2e6-46a7-afca-cc27fb1a8bbf"},{"columns":[{"grid-columns":12,"modules":[{"descriptor":{"computedStyle":{"hideContentOnMobile":false},"style":{"padding-bottom":"10px","padding-left":"10px","padding-right":"10px","padding-top":"10px"},"text":{"computedStyle":{"linkColor":"#AD1B1E"},"html":"<div class=\"txtTinyMce-wrapper\" style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\" data-mce-style=\"line-height: 14px; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 12px;\"><p style=\"line-height: 14px; font-size: 12px; word-break: break-word;\" data-mce-style=\"line-height: 14px; font-size: 12px; word-break: break-word;\"> </p><p style=\"line-height: 14px; font-size: 12px; word-break: break-word;\" data-mce-style=\"line-height: 14px; font-size: 12px; word-break: break-word;\"> </p><p style=\"line-height: 14px; font-size: 12px; word-break: break-word;\" data-mce-style=\"line-height: 14px; font-size: 12px; word-break: break-word;\"> </p><p style=\"line-height: 14px; font-size: 12px; word-break: break-word;\" data-mce-style=\"line-height: 14px; font-size: 12px; word-break: break-word;\"> </p></div>","style":{"color":"#555555","font-family":"inherit","line-height":"120%"}}},"type":"mailup-bee-newsletter-modules-text","uuid":"629c9791-43de-412d-92c0-2cc029ea2647"}],"style":{"background-color":"transparent","border-bottom":"0px solid transparent","border-left":"0px solid transparent","border-right":"0px solid transparent","border-top":"0px solid transparent","padding-bottom":"5px","padding-left":"0px","padding-right":"0px","padding-top":"5px"},"uuid":"6d11edf6-a770-4337-9715-bd4713ba1aa0"}],"container":{"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat"}},"content":{"computedStyle":{"rowColStackOnMobile":true},"style":{"background-color":"transparent","background-image":"none","background-position":"top left","background-repeat":"no-repeat","color":"#000000","width":"635px"}},"name":"One Column (Empty)","type":"one-column-empty","uuid":"01a48e7c-2769-4572-8943-316891b7ece9"}],"template":{"name":"template-base","type":"basic","version":"2.0.0"},"title":""},"comments":{}}
1454
false
false
false
false
2022-05-28T10:50:14
2022-05-28T10:50:14
1000
Connect4 Support
2000000000
2000000000
<__SourceCommsTypes>
1015
E-Mail Message
EmailMergeEngine
3.1
Connect4.Framework.Email.dll,Connect4.Framework.Email.cEmailEngine
Email
1016
1018
0
1
2
EPrimaryEmailAddress,PID,EIDPrimary,PFirstName|First_Name,PLastName|Last_Name
false
true
true
true
false
false
false
false
true
30
<__SourceCommsTypes>
1020
MSWord Mail-Merge
MSWordMerge
3.3
CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cMSWordEngine
Hardcopy
0
0
1021
2
3
AIDPrimary,HID
true
true
false
true
false
true
false
false
false
30
<__SourceCommsTypes>
1168
Mail File Generation
MailFileGeneration
3.9
CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cExportFileEngine
Postal Mail
0
2
AIDPrimary,HID
false
true
false
true
false
false
false
false
true
30
<__SourceCommsTypes>
1169
SMS Text Message
SMSTextMessage
3.11
Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cSMSTextEngine
SMS Text Msg.
1016
3
PID,TIDPhoneMobile,TPhoneMobile,THasSMS,TSMSDenied
false
true
true
true
false
false
false
false
false
30
<__SourceCommsTypes>
1174
Gnosis Report Design
GREPMergeEngine
3.13
Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine
1173
0
0
2
AIDPrimary,HID
false
true
true
true
false
false
false
false
false
30
<__SourceCommsTypes>
1265
RTF Mail-Merge
RTFMerge
3.15
CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine
HardCopy
1263
0
0
2
AIDPrimary,HID
false
true
false
true
false
false
false
false
false
30
<__SourceCommsTypes>
1272
Envelopes (Gnosis Rep Design)
GREPEnvelopes
3.13
Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine
N/A
1173
0
0
2
AIDPrimary,HID
false
true
true
true
false
false
false
false
false
30
<__SourceCommsTypes>
1276
Envelopes (for RTF Mail-Merge)
RTFEnvelopes
3.15
CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine
N/A
1263
0
0
2
AIDPrimary,HID
false
true
false
true
false
false
false
false
false
30
<__SourceCommsDataTypes>
1016
8
Plain Text
txt
3
<__SourceCommsDataTypes>
1018
8
HTML
htm
txt
3
<__SourceCommsDataTypes>
1021
8
MS Word Document
doc
3
<__SourceCommsDataTypes>
1173
8
Gnosis Report Format
repx
3
<__SourceCommsDataTypes>
1263
8
RTF
rtf
txt
3
<__SourceCommsDataTypes>
1454
8
Beefree
The beefree/pro/plugin json format (template) that the html is built from
beeJSON