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 (SELECT staff.Email  || '; ' FROM staff WHERE Staff.staffid =  UserStaffID ) || 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