This is an old revision of the document!
Install and Configure EWS (Exchange Web Service) Send Mail
1) Firstly you need to have the following SQL Function in your IQX database:
ALTER FUNCTION "pears"."EmailProviderDetails"() RETURNS long VARCHAR BEGIN DECLARE rv long VARCHAR; DECLARE crlf CHAR(5); SET crlf = "char"(13)+"char"(10); -- RETURN null; -- if not using EWS SET rv = 'EWS'+crlf; -- mandatory for EWS SET rv = string(rv,(SELECT list(NUMBER,';' ORDER BY pt.name ASC) FROM Phone AS p KEY JOIN PhoneType AS pt WHERE p.WhoID = UserStaffID AND p.Who = 'U' AND pt.Capabilities = 'E'),crlf); -- one or more sender addresses separated by ; Use userstaffid to look up valid ones for logged in user. -- set rv=rv+'IQXEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. SET rv = rv+'IQEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. SET rv = rv+'<ExchangeServerUrl>https://titanic2.iqx.co.uk/EWS/Exchange.asmx</ExchangeServerUrl>'+crlf; -- All remaining lines are inserted into the <ServerDetails> block. SET rv = rv+'<ExchangeVersion>2010</ExchangeVersion>'+crlf; SET rv = rv+'<ExchangeServicePack></ExchangeServicePack>'+crlf; RETURN rv END
2) Add the following files to your IQX main program folder.
1) IQXEWS.exe 2) Microsoft.Exchange.WebServices.dll 3) IQXEWS.pfx
Error Reporting
Any error that occurs is written to the *.err file. This file can be found in the same folder as the files above