Re: Reading data from Outlook forms

Matt

Many thanks, ".UserProperties("NameOfField")" looks exactly like what I was
looking for. I'll give this a go next week.

Thanks again
Dave O.

"Matt Williamson" <ih8spam@xxxxxxxxxxx> wrote in message
news:u90W3xx2FHA.3744@xxxxxxxxxxxxxxxxxxxxxxx
> Dave-
>
> All you need to do is determine what type of form it is and look for the
> property you want to extract in the object model. Custom fields can be
> extracted using .UserProperties("NameOfField") for the item in question.
>
> This program helped the process a great deal:
> http://www.dimastr.com/outspy/
>
> HTH
>
> Matt
>
>
> "Dave" <nobody@xxxxxxxxxxx> wrote in message
> news:Ozxgn%23w2FHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
>> What it is we have a custom form in Outlook which has some information
>> about sales visits, there are also two databases with other contact and
>> contract information, my mission (should I choose to accept it - this
>> message will self destruct etc...) is to merge all that data into a
>> single database and present it all through a nice unified VB front end.
>>
>> I've done most of it, all I need to do now is get the information out of
>> Outlook, the form is the only type of item in a specific single folder, I
>> don't need to iterate or recurse to the folder (although I worked out how
>> to do that) all I need to do is to iterate the fields of the wretched
>> form and get the few that I'm interested in.
>>
>> Best Regards
>> Dave O.
>>
>> P.S. Sorry about the duplicate post, our ISP was down for a bit but our
>> gateway must have cached the message and re-sent it when the ISP came
>> back up.
>>
>>
>>
>> "Matt Williamson" <ih8spam@xxxxxxxxxxx> wrote in message
>> news:uCieavw2FHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
>>> Dave-
>>>
>>> I've recently done a project that involved extracting contact and task
>>> data from custom outlook forms, so I have a good idea what you're trying
>>> to do. Give me more details on exactly what it is you want and I can
>>> probably help you get there. In my case, I specified the top level
>>> folder and had my code recurse into each of the subfolders checking for
>>> specific folder types and extracting individual details (name, email,
>>> address, etc) from each contact folder and writing them out to a comma
>>> delimited file for import into Excel.
>>>
>>> HTH
>>>
>>> Matt
>>>
>>> "Dave" <nobody@xxxxxxxxxxx> wrote in message
>>> news:enxE3Mu2FHA.3704@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Hi
>>>>
>>>> I need to extract some data from a custom form in Outlook, there are
>>>> several hundred of these so I don't want to do this by hand but I only
>>>> need to do it once so I am not too worried about elegance or
>>>> efficiency.
>>>>
>>>> So far I've worked out how to get the titles of each item in the folder
>>>> but no more. Presumably I need to enumerate the fields on the form and
>>>> then collect from the ones I want.
>>>>
>>>> This is (more or less) what I've got so far to read the titles from the
>>>> currently open Outlook folder:
>>>>
>>>> Dim OLK As Outlook.Application
>>>> Dim i As Integer
>>>> Set OLK = New Outlook.Application
>>>> For i = 1 To OLK.Explorers.Item(1).CurrentFolder.Items.Count
>>>> debug.print OLK.Explorers.Item(1).CurrentFolder.Items.Item(i)
>>>> Next
>>>>
>>>> Can anyone point me in the direction needed to get the information out?
>>>>
>>>> TIA
>>>> Dave O.
>>>>
>>>
>>>
>>
>>
>
>


.

Quantcast