Mail Queue Job

Mail Queue Job for Infor CRM

The Customer FX Mail Queue Job is a job for Infor CRM that implements an e-mail queue and allows sending e-mails by simply adding records to a MailQueue table.

If all you need is the ability to send e-mails from CRM, instead of implementing KnowledgeSync or TaskCentre this job will allow you to easily send emails from anywhere inside of CRM.

Using the Mail Queue Job

To use this job, simply perform the following steps:

1. Install the provided bundle Customer FX Mail Queue Job
2. Once installed, open the Job Service portal in Application Architect.
3. Right click the FX.MailQueue.Job under the Jobs tab and select “Add Schedule”.
4. Set the schedule to execute “every 1 minute“.
5. Under the SupportFiles tab of the Job Service portal, locate the file “FXMailQueue.config” and double-click it to edit.
6. Edit the file to add your SMTP settings, then save it.
7. Deploy the Job Service Portal.
8. Restart the windows service “Saleslogix Job Service”

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

var mail = Sage.Platform.EntityModel.Create<Sage.Entity.Interfaces.IMailQueue>();
mail.ToAddress = "some@email.com"; // can be mulitple recipients, comma-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.