Candy can export to Excel using two methods. DDE is used for older documents. New documents and reports use OLE AUTOMATION.
Using App-V Office can be virtualized. Effectively this means that the actual Office products, such as Excel, are not run natively on the userís machine. Rather they are run on the server and a host program makes Excel appear on the userís machine.
This makes using traditional methods to connect to Excel impossible.
This option is currently being investigated.
This will not work until Microsoft provides a method of connecting to Excel (or outlook).
An alternative is to export to Excel using CSV (XML can be used if it is going to be imported into Excel 2003).
If Outlook is virtualized then use BACKUP TO FILE rather than BACKUP TO EMAIL.