| Template Name | From Address | Email System | Email Template Name & Link | Email Template | Email Delivery Criteria | Technical Email Delivery/Criteria | Merge Fields | Notes |
|---|
| 2YR Request Info | CornellMBA@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | 2YR Request Info X2YR_Request_Info | | Lead record type = Admissions Lead Source = Web2Lead Program of Interest = Two-year Ithaca MBA | Admissions Lead Processing and Email flow | vCampaignID vEmailTemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| Event Registration Confirmation |
| Salesforce | MBA Linvio Event Registration Confirmation MBA_Linvio_Event_Registration_Confirmation | |
|
| vApplicant vApplicantLeadId vApplicationId vCustomer vEmailTemplateName vFirstName vRecipientAddressList vRichTextFormatBody vSalesforce vSenderAddress vSenderType vSubject |
|
| 2YR Application Create | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers send Email through Salesforce | AdmApp Create JGSM | | Email contains '@' Consortium = FALSE App Create Email Sent = FALSE Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Application Create Communication Flow
| vEmailTemplateName vFirstName vInstitution vRecipientAddressList vRichTextFormatBody vSalesforce vSenderAddress vSenderType vSubject |
|
| Recommender Request / Resend Request | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers send Email through Salesforce | AdmApp RecommendRequest toRecommender JGSM AdmApp_RecommendRequest_toRecommender_JGSM | | First Name / Last Name / ApplicationId / Email is not blank Date Request Sent is not Today (can only send 1x / day) Recommendation Received is False Initial Email Sent is not blank Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Recommender Management (from Recommendation record creation), AdmApp Recommender Request for Applicant (when applicant presses the Resend Recommendation button in the application), AdmApp Recommender Request (when Admissions staff uses the Resend Request button on the Recommendation record).
| vApplicant vApplicantMessage vContactURL vEmailTemplateName vInstitution vProgram vRecommender vRecipientAddressList vRichTextFormatBody vSalesforce vSenderAddress vSenderType vSubject vURL |
|
| Recommender Reminder to Submit Request |
|
| AdmApp_RecommendReminder_to_Recommend_JGSM | |
|
| vApplicant vCampaignID vEmailTemplateName vInstitution vIsOperational vPardot vProgram vRecommender vRecipientAddressSingle vSenderAddress vSenderAlias vSubject vURL |
|
| Recommender Received to Applicant | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | AdmApp RecommendReceived toApplicant JGSM | | First Name / Last Name / ApplicationId / Email is not blank Recommendation Received = TRUE Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Recommender Management
| vApplicant vCampaignId vContactURL vEmailtemplateName vFirstName vInstitution vIsOperational vPardot vProgram vRecipientAddressSingle vRecommender vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Recommender Received to Recommender | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | AdmApp RecommendReceived toRecommender JGSM AdmApp_RecommendReceived_toRecommender_JGSM | | First Name / Last Name / ApplicationId / Email is not blank Recommendation Received = TRUE Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Recommender Management
| vApplicant vContactURL vEmailTemplateName vInstitution vProgram vRecommender vRecipientAddressList vRichTextFormatBody vSalesforce vSenderAddress vSenderType vSubject |
|
| App Fee Waiver | mba@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | MBA App Fee Waiver Email App_Fee_Waiver_Email | | Attended = TRUE Receives App Fee Waiver = TRUE OR Admissions Event__c = TRUE | Record Triggered Flows: Admissions Application Communication Flow (manual app fee waiver entry)
Pardot Email template for automated app fee waiver from event attendance: MBA - App Fee Waiver Email | vCalculatedGY vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
App Fee Paid Payment Confirmation (including Deposits) | mba@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | MBA Payment Confirmation Template MBA_Payment_Confirmation_Template | | Application Fee Paid = TRUE Program = 'Two-year Ithaca MBA' Waive Application Fee != TRUE | Admissions Application Communication Flow | vAmount vCampaignId vCustomer vDescription vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject vTransaction |
|
| Application Submit 2YR | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | AdmApp Submit JGSM | | Email contains '@' Consortium = FALSE Submit Email Sent = FALSE Program = 'Two-year Ithaca MBA' Internal Status = 'Submitted' | Record Triggered Flow: Admissions Application Communication Flow | vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Consortium Submit | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Application Submit Consortium (Consortium_Submit) | | Email contains '@' Consortium = TRUE Submit Email Sent = FALSE Program = 'Two-year Ithaca MBA' Internal Status = 'Submitted' | Record Triggered Flow: Admissions Application Communication Flow | vAppOwnerEmail vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Invite to Interview and Email Appt Invite | mba@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | SUMO_Interview_Invite_ALL_Program
Mailchimp: SUMO Interview Invite Template | | Wait 1 Day from Candidate Feedback Recommendation = 'Invite to Interview' Status = 'Complete' Interview_Invite_Sent = FALSE Interviewer Preference != 'Schedule Manually' Interview Invite Email Sent Date is not populated Interview Emails Sent = FALSE | Record Triggered Flow: Admissions MBA Interview Invite Email Trigger
| vApplicant vApplicantLeadId vApplicationId vCampaignId vCustomer vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject
|
|
| Schedule Interview Reminder | mba@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | SUMO_Reminder_Interview_Invite_ALL_Program | | Wait 5 Days after Interview Invite Sent from Candidate Feedback Recommendation = 'Invite to Interview' Status = 'Complete' Interview Emails Sent = FALSE Interview Invite Sent = TRUE Interview Invite Email Sent Date != NULL Application Interview 1 Date/Time = NULL | Record Triggered Flow: Admissions MBA Interview Invite Email Trigger
| vApplicant vApplicantLeadId vApplicationId vCampaignId vCustomer vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Interview Instructions - Zoom | meetwithadmissions@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Skype_Instructions (Zoom Instructions - Pre MBA Interview)
Zoom Interview Instructions MBA (Mailchimp) | | 2 Days before Interview Date SUMO Scheduling Process Name = 'MBA Admissions Interview' Interview Instructions Email Sent = FALSE Status != 'Canceled' Appointment (Event) Record has an Application in the Related To field Service contains 'Interview' Location = 'Video Conference' | Autolaunched Flow: Admissions MBA Meeting Instructions Subflow (Launched from SUMO Appointment Updates Record Triggered Flow) | vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Interview Instructions - On-Campus | meetwithadmissions@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | On_Campus_Instructions | | 2 Days before Interview Date SUMO Scheduling Process Name = 'MBA Admissions Interview' Interview Instructions Email Sent = FALSE Status != 'Canceled' Appointment (Event) Record has an Application in the Related To field Service contains 'Interview' Location = 'On-Campus' | Autolaunched Flow: Admissions MBA Meeting Instructions Subflow (Launched from SUMO Appointment Updates Record Triggered Flow)
| vCampaignId vDescription vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Consultation Instructions | meetwithadmissions@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Admissions_Consultation_Instructions | | 1 Day after Consultation scheduled SUMO Scheduling Process Name = 'Cornell Admissions MBA Consultation' Consultation Instructions Email Sent = FALSE Status != 'Canceled' | Autolaunched Flow: Admissions MBA Meeting Instructions Subflow (Launched from SUMO Appointment Updates Record Triggered Flow) 1 Day after Consultation Scheduled: SUMO_AdditionalInfo.Adm_Consultation_Instruction_Email_Sent = FALSE, whoId != NULL, whoId type = Lead, SUMO_AdditionalInfo.Service.ServiceName contains 'Consultation' | vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Financial Aid Information | CornellMBA@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Financial Info | | Student Loan Additional Financial Aid = 'Yes' Internal Status = 'Submitted' Financial Planning Email Sent = FALSE Program != 'Johnson Cornell Tech MBA' | Record Triggered Flow: Admissions Application Communication Flow
| vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Test Waiver Approved | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | MBA_Test_Waiver | | Email contains '@' Program = 'Two-year Ithaca MBA' Test Waiver Approved = 'Yes' Test Waiver = 'Yes' | Record Triggered Flow: Admissions Application Communication Flow
| vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Test Waiver Denied | mba@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | MBA_Test_Waiver_Denied_Email | | Email contains '@' Program = 'Two-year Ithaca MBA' Test Waiver Approved = 'No' Test Waiver = 'Yes' | Record Triggered Flow: Admissions Application Communication Flow | vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Post Interview Next Steps | meetwithadmissions@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Post MBA Interview Next Steps Post_MBA_Interview_Next_Steps | | 2 Days after Interview 1 Date/Time Interview 1 Status = 'Completed' OR Interview 1 Status = 'Completed - No Report' Post-Interview Email Sent = FALSE Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Application Communication Flow
| vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| Decision (2YR) | no-reply@johnson.cornell.edu | Apex code sends SF email template through PardotEmailHandler | AdmApp Decision JGSM | | Internal Status is a decision status Publish Now = 'Publish NOW' Decision Email Sent = FALSE Decision Email Sent Date is NULL
| DecisionLetters ApexClass |
|
|
| Payment Confirmation | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | MBA_Payment_Confirmation_Template | | Email contains '@' Deposit Transaction Number is Populated (1-5) Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Application Communication Flow | vAmount vCampaignId vCustomer vDescription vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject vTransaction |
|
| MBA Feedback Survey | no-reply@johnson.cornell.edu | Salesforce email template, flow triggers PardotEmailHandler | Admissions Feedback Survey Email (Admissions_Feedback_Survey_Email) | | Internal Status = 'Not Entering' OR 'Canceled' OR 'Withdraw' Apply Year is This Year OR Last Year Program = 'Two-year Ithaca MBA' | Record Triggered Flow: Admissions Application Communication Flow
| vApplicantLeadId vApplicationId vAppOwnerName vCampaignId vEmailtemplateName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSenderReplyTo vSubject |
|
| MBA Checklist Emails | jcb-salesforce@business.cornell.edu(?) | Salesforce apex code (checklist code) to applicant email address |
| | Checklist mdt has 'send email' set for that checklist item. |
|
|
|
| Visa App Submitted |
| Flow |
| |
|
| vCampaignId vContactURL vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| Visa App Incomplete |
| Flow | Visa_Application_Incomplete_Email | |
|
| vCampaignId vContactURL vDescription vEmailtemplateName vFirstName vIsOperational vPardot vProgram vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| VisaApp Sent to ISSO |
| Flow | Visa_Application_Sent_to_Global_Learning_Office_Email | |
|
| vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| VisaApp Sent to Student |
| Flow | Visa_Application_Sent_to_Student_Email | |
|
| vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| DJ Registration Confirmation |
| ? | DJ RSVP Confirm Attending | |
|
|
|
|
| DJ Registration Changed |
|
| DJ Registration Changed | |
|
|
|
|
| DJ Confirm Not Attending |
|
| DJ RSVP Confirm Not Attending | |
|
|
|
|
| DJ Bus Seats Confirmation |
| Flow | DJ Bus Seats Confirmed | |
| DJ Charter Bus Management | vApplicant vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|
| DJ Bus Seats Waitlist |
| Flow | DJ Bus Seats Waitlist | |
| DJ Charter Bus Management | vApplicant vCampaignId vEmailtemplateName vFirstName vIsOperational vPardot vRecipientAddressSingle vSenderAddress vSenderAlias vSubject |
|