Forums

I am unable to get auto-response working correctly. Here is how I've configured SplendidCRM Community 5.5.4424.26771. It's running on Windows Server 2008 & IIS 7.

1. I created an IMAP email account... info@Demo.com.
2. I created an Email Template in SplendidCRM Community edition... Info Response
3. I created a MAILBOX (Admin, Inbound Email, Create Mailbox)... Info
4. In the Autoreply field I specified my template, Info Response
5. I filled in "From Name" and "From Email Address"
6. Once the mailbox was created, I tested it by clicking "Check Mail." It worked
7. From another email account, I sent info@Demo.com an email.
8. I went to Admin, Scheduler and clicked "Run" on the "Check Inbound Mail Messages" task.
9. My Lead was created automatically, but there was no reply to my original email message.

I would have expected a response to be emailed back to the sender. It should have included the text that I specified in the Info Response template which I created in step 4.

Question: Does this task work in Community Edition? I also plan to use it in Enterprise (but have not yet tested). Where is the code that deals with the auto-reply. Since it runs in the background, I'm not sure where to find it. It was not obvious to me. Any help would be appreciated.

Unfortunately, there are two issues...

FIRST, There is an error in spEMAILS_InsertInbound. @FILTER_DOMAIN is not handled correctly. Here's the fix.

SET @FILTER_DOMAIN = lower(ISNULL(@FILTER_DOMAINJ),''));

In the following line I've also done the same with @ACTIVITY_TYPE. Modify the check for IS NULL to the following

LEN(ISNULL(@ACTIVITY_TYPE,'')) = 0

After adding this fix, records are properly added to INBOUND_EMAIL_AUTOREPLY and EMAILMAN.

SECOND, the pollOutboundEmails task is not sending auto-reply emails scheduled by spEMAILS_InsertInbound. This is a bigger problem. The notes at the end of spEMAILS_InsertInbound read as follows: To have an auto-reply we just need to insert the inbound record and the auto-reply record. The rest is automatic. This is not the case. The failure to send stems from the view vwEMAILS_ReadyToSend. It doesn't check either one of the tables updated in the upstream process. It looks to me like pollOutboundEmails needs some additional logic.