FX.MailQueue.Job

A Job for Infor CRM that allows sending e-mails by simply adding records to a MailQueue table

Installation

1. To install, simply download and install the bundle Customer FX Mail Queue Job
2. Locate the "FXMailQueue.config" file in the root of the Job Service portal's Support Files
3. Double-click the FXMailQueue.config to open it. Edit the file to add your SMTP settings, then save
4. Deploy the Job Service Portal

Usage

To use, simply add a record to the MailQueue table. This can be done directly in SQL or using the entity model. For example:

var mail = Sage.Platform.EntityModel.Create<Sage.Entity.Interfaces.IMailQueue>();
mail.ToAddress = "some@email.com"; // can be multiple recipients, comma or semi-colon delimited 
mail.FromAddress = "another@email.com";
mail.Subject = "Test Email";
mail.Body = "This is a test e-mail";

// optional, record as a note on a contact 
mail.RecordForContactId = "CXXXX0000001";

// optional, attach a file
mail.AttachmentPath = @"C:\SomeFolder\SomeFile.pdf";

// optional, delay sending until a specific date/time
mail.DelayUntil = DateTime.Now.AddMinutes(30);

mail.Save();
// now the mail will be sent

There is also an entity business rule on the MailQueue entity called MailQueueProcessed. This business rule will be executed for each e-mail processed, allowing you to add custom logic to the processing of each e-mail.

Note: If an error occurs when sending the e-mail, the MailQueue record will be updated with the error details and the job will attempt to send it again on it's next execution. If the email is sent successfully, the MailQueue record will be deleted.