Schedule an Appointment email using Data Extension

%%[
Set @EmailDE = "5-22_Master"
Set @SubjectLine ="It's time to schedule a check-up for your family! Schedule online now."
Set @Preheader = "Can we help you schedule an appointment?"
Set @Header = "Prevention is the best medicine."
Set @MessageBody = "Make sure your family is happy & healthy with twice a year check-ups.
Your family will love our fun offices and friendly doctors. Schedule a convenient appointment now!"
Set @Callout = "Schedule an Appointment"
Set @BelowCallout = "If you have any questions or need help scheduling an appointment,
please call us at (800) 872-7280."

Set @HeroText = "WE HAVEN'T SEEN YOU IN A WHILE..."
Set @HeroImage = "http://image.e.example.com/lib/fe9713707565077471/m/2/lapsed-hero-touch1-a1.jpg"
Set @ButtonColor = '#00A96C'
Set @CalloutColor = '#00A96C'

If @HeroImage =="" OR EMPTY(@HeroImage) THEN
SET @HeroImage = "http://image.e.example.com/lib/fe9713707565077471/m/2/lapsed-hero-touch-4.jpg"
ENDIF

IF @ButtonColor == "" OR EMPTY(@ButtonColor) THEN
SET @ButtonColor = "#00A96C"
ENDIF

IF @CalloutColor == "" OR EMPTY(@CalloutColor) THEN
SET @CalloutColor = "#00A96C"
ENDIF

Set @Campaign = "Capacity_"
Set @SendDate = Format(Now(),"MMddyyyy")
Set @CampaignID = Concat(@Campaign,@SendDate)
Set @FamilyID = FamilyID
Set @HOHID = HOHID
Set @PatientID = PatientID
Set @HoHFirstName = HoHFirstName
Set @FamilyTotal = Rowcount(Lookuprows(@EmailDE,"FamilyID",@FamilyID))
Set @FamilyRecords = LookupOrderedRows(@EmailDE,0,"EmailAddress","FamilyID",@FamilyID)
Set @ApptClinicID = ClinicID

IF @ApptClinicID == "71" THEN
SET @ApptClinicID = "109"
ELSEIF @ApptClinicID == "42" THEN
SET @ApptClinicID = "99"
ELSEIF @ApptClinicID == "" OR EMPTY(@ApptClinicID) THEN
SET @ApptClinicID = LookUp("b_patient_data","PrimaryClinicId","FamilyID",@FamilyID)
ENDIF

@linkPatientIDs = ''

for @i = 1 to Rowcount(@FamilyRecords) do

Set @row = Row(@FamilyRecords,@i)
Set @PatientID = Field(@row,"PatientID")

IF @i > 1 THEN
Set @linkPatientIDs = Concat(@linkPatientIDs,',',@PatientID)
ELSE
Set @linkPatientIDs = @PatientID
ENDIF

next @i

IF Rowcount(@FamilyRecords) > 1 THEN

Set @RescheduleURL = Concat("https://www.example.com/l/reschedule_appointment?",'pid=',@linkPatientIDs,
'&cid=',@ApptClinicID,'&hid=',@HOHid,'&mid=',@CampaignID,'&utm_source=AdHoc&utm_campaign=capacity
&utm_medium=email&utm_content=schedule')
ELSE
Set @RescheduleURL = Concat("https://www.example.com/l/reschedule_appointment?",'pid=',@PatientID,
'&cid=',@ApptClinicID,'&hid=',@HOHid,'&mid=',@CampaignID,'&utm_source=AdHoc&utm_campaign=capacity
&utm_medium=email&utm_content=schedule')
ENDIF

Set @ClinicLocalURL = Lookup("ll_clinic_data","localURL","CRMFacilityID",@ApptClinicID)
Set @ClinicInfoURL = Concat("http://www.example.com",@ClinicLocalURL,"?&utm_campaign=capacity
&utm_medium=email&utm_content=schedule")

Var @MobileURL, @mobile
Set @MobileValidation = LookUp("SMS_All_Subs_De","SMS_Opt_In","HOHID",@HOHID)
Set @CellPhone = LookUp("SMS_All_Subs_De","Phone","HOHID",@HOHID)
Set @DoNotText = LookUp("SMS_All_Subs_De","DoNotText","HOHID",@HOHID)
Set @MobileURL = "http://pages.e.example.com/page.aspx?QS=1550dccf35ce5f74ea9e42019db4e7018b15
c2490b670c7da9a317b483a9cceb"
Set @mobile = Concat(@MobileURL,'&fid=',@Familyid,'&hid=',@HOHid,'&pid=',@PatientId,
'&cid=',@ApptClinicID,'&cph=',@CellPhone)
]%%
<!doctype html>
<html>
<head>
<meta charset="UTF-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title></title>
<style type="text/css">
body {
Margin: 0;
padding: 0;
min-width: 100%;
font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; -webkit-font-smoothing: antialiased;
mso-line-height-rule: exactly;
‑webkit‑text‑size‑adjust: 100%; -ms-text-size-adjust: 100%;
}
table {
border-spacing: 0;
color: #595959;
font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; mso-table-lspace: 0px;
mso-table-rspace: 0px;
}
img {
border: 0;
}
.ExternalClass * {
line-height: 100%;
}
.appleLinksWhite, .appleLinksWhite a {
color: #ffffff;
text-decoration: none;
}
.appleLinksGrey, .appleLinksGrey a {
color: #595959;
text-decoration: none;
}
span.MsoHyperlink {
mso-style-priority: 99;
color: inherit;
}
span.MsoHyperlinkFollowed {
mso-style-priority: 99;
color: inherit;
}
a {
text-decoration:none;
}
a[x-apple-data-detectors] {
color:inherit !important;
text-decoration:none !important;
font-size:inherit !important;
font-family:inherit !important;
font-weight:inherit !important;
line-height:inherit !important;
}
.wrapper {
width: 100%;
table-layout: fixed;
-webkit-text-size-adjust: 100%;
-ms-text-size-adjust: 100%;
}
.outer {
Margin: 0 auto;
width: 100%;
max-width: 600px;
}
.full-width-image img {
width: 100%;
max-width: 600px;
height: auto;
}
.inner {
padding-bottom: 10px;
padding-right: 10px;
padding-left: 10px;
padding-top: 10px;
}
@media screen and (max-width: 400px) {
.centered {
width: 100% !important;
text-align: center !important;
Margin: 0 auto !important;
}
.nopadding {
width: 100% !important;
text-align: center !important;
Margin: 0 auto !important;
padding-left: 20px !important;
padding-right: 20px !important;
}
.left-align {
text-align: left !important;
}
.mobile-hide {
display: none !important;
}
}
</style>


</head>
<body style="Margin:0; padding-top:0; padding-bottom:0; padding-right:0; padding-left:0; min-width:100%; background-color:#f5f3f0; -webkit-font-smoothing:antialiased; mso-line-height-rule:exactly; font-family:Arial, sans-serif; " >
<center class="wrapper" style="width: 100%; table-layout: fixed; -webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%;">
<table style="background-color: #f5f3f0;" width="100%" bgcolor="#f5f3f0" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table class="outer" style="border-spacing: 0; font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #595959; Margin: 0 auto; width: 100%; max-width: 600px;" align="center" bgcolor="#f5f3f0" border="0" cellpadding="0" cellspacing="0">
<div style="max-width: 600px !important;">
<tr>
<td style="padding: 0;">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" align="center" bgcolor="#f5f3f0">
<table class="one-column" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="100%" style="border-spacing:0;max-width: 600px;">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
<tr>
<td align="center" valign="top"><a href="%%=RedirectTo(@HeroLink)=%%" target="_blank"><img src="%%=v(@HeroImage)=%%" width="580" title="%%=v(@HeroText)=%%" alt="%%=v(@HeroText)=%%" style="border:none;display:block;"></a></td>
</tr>
</table>
<table class="one-column" style="background-color: #ffffff;padding:20px 15px 15px 15px;" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="text-align: center;">
<table style="border-spacing: 0;" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table align="center" style="border-spacing: 0;" width="100%" border="0" cellpadding="0" cellspacing="0">
%%[IF NOT EMPTY(@Header) THEN]%%
<tr>
<td style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #323232;font-size: 20px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 15px 30px 0 30px;font-weight:bold;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@Header)=%%</span></td>
</tr>
%%[ENDIF]%%
<tr>
<td style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #323232;font-size: 16px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 15px 30px 5px 30px;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@MessageBody)=%%</span></td>
</tr>
</table>
</td>
</tr>
%%[IF NOT EMPTY(@Callout) THEN]%%
<tr>
<td style="text-align: center;padding: 0 20px;">
<center>
<table align="center" width="100%">
<tr>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="0" style="Margin:0 auto;">
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="100%" style="font-size: 20px; line-height: 20px;"> 
</td>
</tr>
</table>
<table align="center" class="transparent" style="Margin: 0 auto;" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="330" height="40" align="center" style="background-color: %%=v(@ButtonColor)=%%;border-radius: 3px; -webkit-border-radius: 3px; -moz-border-radius: 3px;"><a href="%%=RedirectTo(@RescheduleURL)=%%" title="%%=v(@Callout)=%%" target="_blank" style="mso-padding-alt: 5px 10px; width: 300px; display: block; text-decoration: none; text-align: center;font-weight: bold; font-size: 17px; font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #ffffff; mso-line-height-rule: exactly; line-height: 17px; text-transform: uppercase; padding-top: 12px;padding-right: 10px; padding-bottom: 12px; padding-left: 10px;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@Callout)=%%</span></a></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
</table>
</td>
</tr>
%%[ENDIF]%%
%%[IF NOT EMPTY(@BelowCallout) THEN]%%
<tr>
<td align="center" style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: %%=v(@CalloutColor)=%%;font-size: 18px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 0 30px 0 30px;-webkit-font-smoothing: antialiased;text-align: center;font-weight: bold;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;color: %%=v(@CalloutColor)=%%;text-decoration:none;">%%=v(@BelowCallout)=%%</span>
</td>
</tr>
%%[ENDIF]%%
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="100%" style="font-size: 20px; line-height: 20px;"> 
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table class="one-column" style="background-color: #ffffff;" width="100%" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#ffffff">
<tr>
<td width="100%" align="center" valign="top" style="padding:25px 20px; color:#515151; font-family:Arial, Helvetica, sans-serif; font-size:11px; line-height: 150%;">To unsubscribe from future emails <a href="%%subscription_center_url%%" target="_blank" style="color:#515151;text-decoration:underline;">click here</a>.
<br />
<br />
<span class="appleLinksGrey">%%Member_Addr%%, %%Member_City%%, %%Member_State%%, %%Member_PostalCode%%, %%Member_Country%%
<br />
<br />
© %%=Format(Now(),"yyyy")=%%</span>. All rights reserved. <a href="https://www.example.com/privacy" target="_blank" style=" text-decoration:underline; color:#515151;">Privacy Statement</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
<custom name="opencounter" type="tracking">
</body>
</html>