I have a list of contacts in my own database that I am accessing with a VB
program that I have written. I want to loop through this list and export them
to my Outlook 2007 contacts folder.

I am starting with the following code to access my Outlook folder:

Dim Contact As Outlook.ContactItem
Dim ContactList As Object
Dim ContactsFolder As Object
Dim OutlookApp As Object
Dim OutlookNamespace As Object

Set OutlookApp = GetObject(, "Outlook.Application")
Set OutlookNamespace = OutlookApp.GetNamespace("MAPI")
Set ContactsFolder = OutlookNamespace.GetDefaultFolder(olFolderContacts )
Set ContactList = ContactsFolder.Items

I need to find whether a contact is already in the ContactList based on the
CompanyName field. If it exists, I want to update certain fields in the
ContactItem. If it doesn't, I want to define a new ContactItem.

I have used collections very little, and so I'm not sure how to efficiently
find an item in the collection and know whether or not it exists. Thanks for
your help!

As Diane mentioned - code related questions should be posted in the
Outlook_Program_vba newsgroup - some very bright folks there that know
Outlook inside out. This group is primarily intended for Outlook users as it
relates to contacts. You should also check out the VB related newsgroups for
general programming topics.

But to get you started.......when you set your items you can include a
restriction on company name - that will give you all the contacts with the
same company and you'll need to determine from there if you're contact is in
there.:
Set ContactList = ContactsFolder.Items.Restrict("[CompanyName] = '" &
yourvalue & "'")

You may want to extend the restriction to include email address with the
company name to reduce the number of potential duplicates (not to mention
making sure that any duplicate is in fact related to the contact you want
to add or, for that matter, what you want to do if the same contact already
exists in the contact folder more than once or anything in between). Be
forewarned that the above can be a very slow way of doing things if you're
dealing with large data files and certainly may not be the most efficient of
approaches depending on the circumstances.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com




"Dan" wrote in message
...
I have a list of contacts in my own database that I am accessing with a VB
program that I have written. I want to loop through this list and export
them
to my Outlook 2007 contacts folder.

I am starting with the following code to access my Outlook folder:

Dim Contact As Outlook.ContactItem
Dim ContactList As Object
Dim ContactsFolder As Object
Dim OutlookApp As Object
Dim OutlookNamespace As Object

Set OutlookApp = GetObject(, "Outlook.Application")
Set OutlookNamespace = OutlookApp.GetNamespace("MAPI")
Set ContactsFolder = OutlookNamespace.GetDefaultFolder(olFolderContacts )
Set ContactList = ContactsFolder.Items

I need to find whether a contact is already in the ContactList based on
the
CompanyName field. If it exists, I want to update certain fields in the
ContactItem. If it doesn't, I want to define a new ContactItem.

I have used collections very little, and so I'm not sure how to
efficiently
find an item in the collection and know whether or not it exists. Thanks
for
your help!

Karl,

I'm sorry. I meant to post my question in the programming newsgroup and
didn't notice that I was in the wrong section.

Thanks for your suggestions. That helps to get me started, and I'll repost
my question in the other newsgroup to see if there are any other helpful
suggestions.

Dan

"Karl Timmermans" wrote:

As Diane mentioned - code related questions should be posted in the
Outlook_Program_vba newsgroup - some very bright folks there that know
Outlook inside out. This group is primarily intended for Outlook users as it
relates to contacts. You should also check out the VB related newsgroups for
general programming topics.

But to get you started.......when you set your items you can include a
restriction on company name - that will give you all the contacts with the
same company and you'll need to determine from there if you're contact is in
there.:
Set ContactList = ContactsFolder.Items.Restrict("[CompanyName] = '" &
yourvalue & "'")

You may want to extend the restriction to include email address with the
company name to reduce the number of potential duplicates (not to mention
making sure that any duplicate is in fact related to the contact you want
to add or, for that matter, what you want to do if the same contact already
exists in the contact folder more than once or anything in between). Be
forewarned that the above can be a very slow way of doing things if you're
dealing with large data files and certainly may not be the most efficient of
approaches depending on the circumstances.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com




"Dan" wrote in message
...
I have a list of contacts in my own database that I am accessing with a VB
program that I have written. I want to loop through this list and export
them
to my Outlook 2007 contacts folder.

I am starting with the following code to access my Outlook folder:

Dim Contact As Outlook.ContactItem
Dim ContactList As Object
Dim ContactsFolder As Object
Dim OutlookApp As Object
Dim OutlookNamespace As Object

Set OutlookApp = GetObject(, "Outlook.Application")
Set OutlookNamespace = OutlookApp.GetNamespace("MAPI")
Set ContactsFolder = OutlookNamespace.GetDefaultFolder(olFolderContacts )
Set ContactList = ContactsFolder.Items

I need to find whether a contact is already in the ContactList based on
the
CompanyName field. If it exists, I want to update certain fields in the
ContactItem. If it doesn't, I want to define a new ContactItem.

I have used collections very little, and so I'm not sure how to
efficiently
find an item in the collection and know whether or not it exists. Thanks
for
your help!