Reading forms data from Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bill Le May (blemay0_at_mchsi.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 12:19:58 -0500

I want to build a chart in Excel, based on data from a Public Folder
containing Outlook forms. So, I want to cycle through Outlook form items in
an Exchange folder and look at
custom Values. What is the syntax in Excel for accessing the values? In the
code
snippet below, I'm cycling through Outlook form items in a folder named PCN
Queue. I need the syntax to access a Value called "PCN Number" associated
with the Outlook form.

Thanks for any help.

    Set ns = GetNamespace("MAPI")
    Set Inbox = ns.GetDefaultFolder(olFolderInbox)
    Set PCNFolder = Inbox.Folders("PCN Queue")

    For Each Item In PCNFolder.Items

        MsgBox (Item. ) <--- Need this code

    Next Item

Relevant Pages

  • Re: Reading forms data from Excel
    ... > I want to build a chart in Excel, based on data from a Public Folder ... > containing Outlook forms. ... I want to cycle through Outlook form items ... What is the syntax in Excel for accessing the values? ...
    (microsoft.public.office.developer.outlook.forms)
  • Re: Outlook 2k3: Missing item when task to exporting to excel
    ... Hi can'I do it from Outlook form or do I have to do it from Excel From? ... headers but it still won't do anything for custom fields. ... I use the mileage value to put Customed task ID when I export to excel ...
    (microsoft.public.outlook.program_vba)
  • Need code to send a form
    ... I frequently use VB code in Excel (with much help from these discussion ... forums) but this is my first real try at creating an Outlook form. ... fire this thing off, and how to set the subject line. ...
    (microsoft.public.outlook.program_forms)
  • Default folder to Public folder when Exporting outlook form data to excel
    ... I am trying to get a code for exporting data from an outlook form to ... default to export a certain folder. ... Dim olNamespace As Outlook.Namespace ... Dim wsSheet As Worksheet ...
    (microsoft.public.outlook)
  • Custom form could not be opened.
    ... When a user creates a Time-Off request that is located in the Organization ... Folder and the manager approves it and then ... Outlook will use an Outlook form ...
    (microsoft.public.outlook.program_forms)