Getting Started
Open AdmissionsEmailer.exe
If you don't already have an emails.csv file in the same folder as AdmissionsEmailer.exe you will be able to generated a Template csv file.
Click on the Generate CSV Template button
The program will generate a CSV template and save it in the same folder as the program is in. Click OK to acknowledge the prompt that a CSV was generated in the folder.
Excel will open with the Templates Fields listed. Add the information for each field below the template fields. Each row represents a single email that is sent.
ToEmails |
Required. Enter the email address(es) that you want the email to be sent to, similar to the TO line in outlook. If sending to more than one email address for the person, separate them with a pipe character: | . Keep in mind these will all be on the to line, and see each other. Useful for when a single person has multiple email addresses. |
ToName | Required. Enter the full name of the person you are sending to. Only enter one name. |
FromEmail | Required. Email address that it is from. Email address must be verified in sendgrid before using. |
FromName | Required. Name of the person or entity that you are sending from, for example UWW Admissions |
Reply-To | Required. Email address you would want people to reply to when they click reply. Helpful if you want to receive replies to your email. Can be the same as FromEmail. |
BCC | Optional. Email address you want to BCC for the email. Only use one here. Helpful to keep sent messages. |
Attachments | Optional. File path(s) to the attachment(s) you want to include. If multiple attachments, separate them with a pipe character: | Total size of all file attachments should not exceed 19MB |
TemplateID | Required. Sendgrid template ID number. Find this by logging into Sendgrid.com and going to Email API -> Dynamic templates |
[TemplateField1] | These fields should be named exactly the same as the template fields in the Sendgrid template (case-sensitive). Put each one in a separate column. These are your message's merge fields. |
Command Line Arguments
You can optionally specify the csv location via command line argument. When you do this the program will automatically email people in the CSV, without requiring you to click the start button.
AdmissionsEmailer.exe [c:\pathtocsv\csvfile.csv]
The csv file should be in the same format as above. This is helpful so that other programs can generate a csv and kick off the emailing process automatically.
Comments
0 comments
Please sign in to leave a comment.