Hi,

We have Microsoft AX 4.0 running on SQL Server 2005. I am trying to get the email address which is used for sending out Invoices from the PRINTJOBSETTINGS column in SALESPRINTSETUP table. The PRINTJOBSETTINGS column is of Image data type. But it is not really an image. Can someone please help me how to  extract information from PRINTJOBSETTINGS? I have attached an image of the SALESPRINTSETUP column after I ran the following query.

SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), PRINTJOBSETTINGS)) FROM SALESPRINTSETUP

Thanks