Re: Using an Excel *** in a custom outlook form

From: Sue Mosher [MVP-Outlook] (suemvp_at_outlookcode.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 15:39:11 -0500

Lookup worked for me in a small test here. Can you provide exact steps to
reproduce the problem?

FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_forms 

-- 
Sue Mosher, Outlook MVP
Author of
     Microsoft Outlook Programming - Jumpstart for
     Administrators, Power Users, and Developers
     http://www.outlookcode.com/jumpstart.aspx
"Prem Iyangar" <PremIyangar@discussions.microsoft.com> wrote in message 
news:6562B1E2-3E20-4339-9451-6E2C8BF3305F@microsoft.com...
>I designed a form in Outlook 2003 and inserted an excel *** in it with a
> bunch of formulas in it. Everything works fine except for a LOOKUP 
> function.
> The same lookup function works in an excel spread*** outside the form, 
> but
> does not work in the form. It gives an error that says the formula you 
> types
> contains an error.
> Any help is highly appreciated.
> Thanks,
> Prem.