Covid Screening Email Sending Info

MIS Department Policy & Procedure 

Scheduled send of Covid screening email using Mailsend1.16.exe

1. The Covid screening emails for the general staff and for the fire staff are performed by two scheduled tasks on Colpotter.

2. General staff is scheduled for 6:00am and Fire staff at 6:05am every day.

3. The batch files that run in the tasks are stored in the MIS I: drive and the location is referenced in the batch files running from Colpotter as E:\DATA2\Department\D_Dat\Net\SysAdmin\Mailsend\CovidNotice

4. Two batch files exist. CovidNoticeSend-Main.bat and CovidNoticeSend-Fire.bat

5. Both of these call an executable file called Mailsend1.16.exe with parameters.

6. There is a newer version Mailsend1.20b.exe available to download but I am not using it at this time due to the requirement for SMTP authentication.

7. If there is a need to change the URL for either of the Google Forms that is included in these emails, you would simply edit the appropriate BAT file using my favorite application NOTEPAD and replace the URL. Note that the -M message section that contains the URL is in quotes.

8. This version of Mailsend only supports a single line of text in the message body.

9. Note-the third line of this batch file is a single line.

10. The command line parameters used are

    1. -d (this is the internal domain rh.gov)

    2. -smtp (the email server running on WhatsUp2 server)

    3. -t (addresses to send to)

    4. -f (from address)

    5. -sub (subject line in quotes)

    6. -M (single line message body in quotes)

Batch Files

CovidNoticeSend-Main.bat

REM Batch file to send COVID notice emails to main building groups

REM This batch file runs as a scheduled task on Colpotter each morning at 6am

"E:\DATA2\Department\D_Dat\Net\SysAdmin\Mailsend\CovidNotice\mailsend1.16.exe" -d rh.gov -smtp 172.20.2.32 -t bldgcityhall@rocheserhills.org,bldggarage@rochesterhills.org,bldgremote@rochesterhills.org -f notifications@rochesterhills.org -sub "COVID Screening" -M "Please complete your daily COVID screening. https://docs.google.com/forms/d/e/1FAIpQLSdAPX5JDe7gnXyHsHCPxgRw5fYNPDUEVGq-8IFfYXDFMcIgWQ/viewform"

CovidNoticeSend-Fire.bat

REM Batch file to send COVID notice emails to main building groups

REM This batch file runs as a scheduled task on Colpotter each morning at 6:05am

"E:\DATA2\Department\D_Dat\Net\SysAdmin\Mailsend\CovidNotice\mailsend1.16.exe" -d rh.gov -smtp 172.20.2.32 -t firedept@rochesterhills.org -f notifications@rochesterhills.org -sub "COVID Screening" -M "Please complete your daily COVID screening. https://docs.google.com/forms/d/e/1FAIpQLSe9HZy409hAW6wUxG3iHr6NABsSfYb26Tt9SF2sW5eqq_tPmQ/viewform"

Mailsend1.16.exe command line parameters

E:\DATA2\Department\D_Dat\Net\SysAdmin\Mailsend\CovidNotice>mailsend1.16.exe -help

Version: @(#) mailsend v1.16

Copyright: GNU GPL. It is illegal to use this software for Spamming

(Compiled with OpenSSL 1.0.0g 18 Jan 2012)

usage: mailsend [options]

Where the options are:

 -smtp hostname/IP*    - of the SMTP server

 -port SMTP port       - SMTP port

 -d    domain          - domain name for SMTP HELO/EHLO

 -t    to,to..*        - email address/es of the recipient/s

 -cc   cc,cc..         - Carbon copy address/es

 +cc                   - don't ask for Carbon Copy

 -bc   bcc,bcc..       - Blind carbon copy address/es

 +bc                   - don't ask for Blind carbon copy

 +D                    - don't add Date header

 -f    address*        - email address of the sender

 -sub  subject         - subject

 -l    file            - a file containing the email addresses

 -attach file,mime_type,[i/a] (i=inline,a=attachment)

                       - attach this file as attachment or inline

 -cs   character set   - for text/plain attachments (default is us-ascii)

 -M    "one line msg"  - attach this one line text message

 -name "Full Name"     - add name in the From header

 -v                    - verbose mode

 -V                    - show version info

 -w                    - wait for a CR after sending the mail

 -rt  email_address    - add Reply-To header

 -rrr email_address    - request read receipts to this address

 -ssl                  - SMTP over SSL

 -starttls             - Check for STARTTLS and if server supports, do it

 -auth                 - Try CRAM-MD5,LOGIN,PLAIN in that order

 -auth-cram-md5        - use AUTH CRAM-MD5 authentication

 -auth-plain           - use AUTH PLAIN authentication

 -auth-login           - use AUTH LOGIN authentication

 -user username        - username for ESMTP authentication

 -pass password        - password for ESMTP authentication

 -example              - show examples

 -ehlo                 - force EHLO

 -info                 - show SMTP server information

 -help                 - shows this help

 -q                    - quiet

The options with * must the specified