In todays information world, it is very important to stay connected via emails. Emails can be used for many different purposes in your Visual Basic scripts.<\/p>\n
- \n
- Alerting when system thresholds or conditions are met<\/li>\n
- Notification when automated tasks complete or fail<\/li>\n
- Delivery of custom reports and messages to users.<\/li>\n<\/ul>\n
I have encapsulated the logic for\u00a0running\u00a0the\u00a0SMTP relay, via Collabortion Data Objects<\/a> (CDO), into a abstract class.<\/p>\n
The CDO Email class has the following required <\/span>properties.<\/p>\n
SMTP_SVR – The DNS name of the MS Exchange (mail) server
\nFROM_EMAIL – Any source email address that follows naming conventions.
\nTO_EMAIL – A valid destination email address.
\nMSG_SUBJECT – A string describing the subject of the message.
\nMSG_BODY – A textual or html string that contains the body of the message.<\/p>\nThe CDO Email class has the following optional <\/span>properties that allow the designer to send HTML message bodies, add multiple attachments, and set mail priority levels.<\/p>\n
CC_EMAIL – A valid destination (carbon copy) email address.
\nBCC_EMAIL – A valid destination (blind carbon copy) email address.
\nBODY_TYPE – Defaults to text. Is required if you want HTML body to be translated.
\nMSG_ATT = A tilda seperated string of full qualified file names to be attached to the message.
\nMSG_PRIOIRITY – A value indicating low (0), normal (1), or high (2) priority.<\/p>\nThis class contains two methods that can be called to do the following actions.<\/p>\n
LOAD_BODY- This method loads a given file as text and save it as the MSG_BODY property.
\nSEND_EMAIL – This method creates the message and sends it to the mail server.<\/p>\nThe table below has starter code that you can use in your next Visual Basic (VB) Script.<\/p>\n
\n\n
\n mod-cdo-email.vbs<\/a><\/td>\n CDO Email Class<\/td>\n<\/tr>\n \n tst-cdo-mail.vbs<\/a><\/td>\n Sample Program<\/td>\n<\/tr>\n \n emails.cmd<\/a><\/td>\n Batch Program<\/td>\n<\/tr>\n \n tst-cdo-mail.html<\/a><\/td>\n Sample HTML Message<\/td>\n<\/tr>\n \n Wikipedia Image<\/a><\/td>\n Sample Image Attachment<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/P><\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
\nThe output below was generated by the execution of the test program with two sub-routines.
\n<\/P><\/p>\n<\/p>\n
<\/p>\n
![\"\"](\"https:\/\/craftydba.com\/wp-content\/uploads\/2011\/06\/emails-by-importance-150x150.jpg\" "\\"emails-by-importance\\"")
<\/a><\/p>\n![\"\"](\"https:\/\/craftydba.com\/wp-content\/uploads\/2011\/06\/html-email-with-image-att-150x150.jpg\" "\\"html-email-with-image-att\\"")
<\/a>