Use Excels Analysis ToolPak in Outlook

[sara.ridley]

Hi

I have written a procedure in Outlook which takes some info from e-mails, transfers the info to an Excel workbook then runs a macro in excel that inserts some formulae to calculate some stuff.

I have the reference to Excel in Outlooks References.

All fine EXCEPT when any of the formuale contain functions contained within the Analysis Toolpack Addin for excel. Then I just get Name? returned. The Excel macro works fine when it is run from Excel but not when it is run from Outlook. So I am guessing I need to add a reference in Outlook which will enable this.

Can anyone help?

Thanks