Setting up Messaging for GMail

Add "EnableSSL", "UserName" and "Password" to the XML field of DeliveryTypeDetail.Settings using the following script

UPDATE tblDeliveryTypeDetail SET Settings = REPLACE(CONVERT(nvarchar(max), Settings), '</Settings>', '<EnableSSL Caption="Enable SSL" Type="CheckBox"></EnableSSL></Settings>') WHERE DeliveryTypeID IN (SELECT DeliveryTypeID FROM tblDeliveryType WHERE tblDeliveryType.Name IN ('Incoming Email', 'Outgoing Email')) AND CONVERT(nvarchar(max), Settings) NOT LIKE '%<EnableSSL Caption="Enable SSL" Type="CheckBox"%'

GO

UPDATE tblDeliveryTypeDetail SET Settings = REPLACE(CONVERT(nvarchar(max), Settings), '</FromAddress>', '</FromAddress><UserName Caption="Username" Type="TextBox" Required="True" MaxLength="50"></UserName>') WHERE DeliveryTypeID IN (SELECT DeliveryTypeID FROM tblDeliveryType WHERE tblDeliveryType.Name = 'Outgoing Email') AND CONVERT(nvarchar(max), Settings) NOT LIKE '%<UserName Caption="Username" Type="TextBox"%'

GO

UPDATE tblDeliveryTypeDetail SET Settings = REPLACE(CONVERT(nvarchar(max), Settings), '</UserName>', '</UserName><Password Caption="Password" Type="PasswordBox" Required="True" MaxLength="50"></Password>') WHERE DeliveryTypeID IN (SELECT DeliveryTypeID FROM tblDeliveryType WHERE tblDeliveryType.Name = 'Outgoing Email') AND CONVERT(nvarchar(max), Settings) NOT LIKE '%<Password Caption="Password" Type="PasswordBox"%'

Gmail account setting

Enable POP at Gmail account setting/POP Download

Server and port

    • For incoming email, set server value "pop.gmail.com", port value "995"

    • For outgoing email, set server value "smtp.gmail.com", port value "587"