VB6 SP6 - Retrieving Outlook 2003 data

[stjulian]

I have to create an interface which will compare an Outlook 2003 sub-folder
of emails to a customer database (in FoxPro) and report a list of those
emails not already a customer.

I have already attatched Microsoft Outlook to an Access database as a linked
table for testing. I would like to do the same with VB6 SP6. However, I have
noticed that (in Access) the "From:" column only shows the sender's name and
not his email address.

Is there VB6 sample code available to enable the use of Outlook as a data
source, revealing the email address of the sender? And, how do I choose the
correct Outlook folder?

Julian

 

[Kevin8237]

I'd look into a current version of visual studio, they have an extension that
helps work with Office applications like Outlook.

 

[Roady [MVP]]

Check http://www.outlookcode.com or check with the developers down the hall
in outlook.program_vba