Guide: Background Process Emails in Cargas Energy

Summary:

Cargas Energy allows users to email customers statements and invoices. The system adds emails to the Microsoft SQL Server Database Mail service (legacy) or the updated MailKit/OAuth2 solution, which then sends messages through your email server to customers.

Environment:

• All Versions

Guide:

Use the links below to set up, troubleshoot, and analyze background process emails.

Technical setup and configuration

Technical

Database email profile

Get email server settings

Troubleshooting background process emails

Troubleshooting

Database email log

Email Throttling

Gmail Error: The SMTP Server Requires a Secure Connection or the Client was not Authenticated

Helpful scripts for background process emails

Helpful Scripts (overview)

Email history for customer account

Get a log of all mail sent to mail server on a particular day

Create a table that holds emails that are in the queue to send

Update emails with attachments that already sent successfully as sent @ 10/2/18 2:22 PM

Check for emails left that have an attachment that never sent in the past - but does not exist more than once

Get list of email addresses sent to on a particular day