Hello everyone,
It seems that when the v8 Email Manager looks for a match between an incoming email and and email in the HelpMaster Pro database, it does a case sensitive search. This means that if the case is different in the email to what it is in the database, a match will not be established.
This oversight will be corrected in a future release of the Email Manager. As a work-around, you may like to run an SQL Script against your database to update all email addresses to lower case. As usual, please make a backup before doing any sort of bulk update, and do not alter this script in any way.
Here's the script. HelpMaster Pro v7.5, v8 and v9 only.
ALTER Table tblEntityValues Disable Trigger tblEntityValues_UpdateTrigger
Update tblEntityValues
Set DetailValue = Lower(DetailValue)
FROM tblEntityValues INNER JOIN
tblSystemCodes ON tblEntityValues.SystemCodeLink = tblSystemCodes.PKId INNER JOIN
tblSystemCodeCategories ON tblSystemCodes.CategoryLink = tblSystemCodeCategories.PKId
WHERE (tblSystemCodeCategories.SystemID = 'sys_email')
ALTER Table tblEntityValues Enable Trigger tblEntityValues_UpdateTrigger
Best regards,
Rod