Results 1 to 3 of 3
  1. #1
    kid_flow
    Guest

    Reference Outlook Custom Form field in Excel Fn (Excel 97/Outlook 97)

    This may be a lil tricky... I'll try to be as clear as I can.

    I have created a custom MS Outlook 97 form that has several fields which require data. The form has a tab on it so it's really like 2 pages. The 1st page I'm using as a header where all the common data is entered. On the 2nd tab I have inserted an Excel 97 spreadsheet. I would like to write functions in my excel spreadsheets that will take data entered into the header fields on the 1st tab and write them to specified cells in the worksheet.

    I would have no problem writing these functions if it was all in Excel or Access. I just don't know how to reference the Outlook custom fields within the Excel functions. (Since it's not as simple as refering to A1)

    Does anyone have any suggestions? I'm all ears.

    P.S. I suspect it can be done since I've seen a program 'OAXFer' which populates Access databases with data contained in Outlook custom forms.

    Perhaps I'm naive in hoping it's as simple as knowing how to refernce the Outlook custom field.

    We'll soon see.

    Thanx in advance.

    K-Flow

  2. #2
    kid_flow
    Guest

    Re: Reference Outlook Custom Form field in Excel Fn (Excel 97/Outlook 97)

    Any takers at all? Maybe I'm asking alot.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Reference Outlook Custom Form field in Excel Fn (Excel 97/Outlook 97)

    I'm not sure what you are really trying to do, but you would probably have to set up a reference to your actual Outlook project in Excel, as well as probably Outlook itself.

    Have you tried the Outlook Forum ? - It may be worth a try.

    Sorry that I could be of no further help.

    Andrwe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •