Adding contacts to Outlook from Access DB

[Gitche Gumee]

I was advised to post my question here.

Office 2007

Outlook Contacts is a linked table in Access. I'm trying to send contacts to
Outlook using an Access append query. That works, but the new Contact in
Outlook has the email icon, not the Contact icon.

What do I need to do to set that icon to Contact?

 

[Ken Slovak - [MVP - Outlook]]

Assuming that the contacts set that way have a MessageClass of
"IPM.Contact", you might need to set the PR_ICON_INDEX property to a value
of 512. The DASL property tag for that property (0x10800003) is
"http://schemas.microsoft.com/mapi/proptag/0x10800003".

That isn't a URL, it's a DASL property tag that can be used with the
PropertyAccessor object for a contact. Get PropertyAccessor for each contact
item and set that property to 512 using the PropertyAccessor.SetProperty()
method. Usage of that property and method are detailed in the Outlook 2007
VBA Object Browser Help file.