Outlook and Access

  • Thread starter Thread starter Gitche Gumee
  • Start date Start date
G

Gitche Gumee

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?
 
Unfortunately, the field you need which is not exposed is <MessageClass>
which is being set to IPM.Note by default via the Append query even though
your target is a contact folder.

To change this - you'll have to go through the contact folder via code and
change the MessageClass to <IPM.Contact> (or <IPM.Contact.ACustomName> if a
custom form is being used as the default for the folder) but if you do that,
you might as well dispense with using the Append query and just write a
routine what will add the contacts directly. The Access/Outlook link is
limited in terms of what you can and can't do - always has been so this
isn't something specific to O'2007. Also pre-supposing that you want this
function to be part of some larger application so importing via Outlook is
not an option.

You may get other solutions that I'm not aware of in one of the Outlook or
Access programming newsgroups which is really where this question should be
posted. This group is primarily for end user contact related questions.

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
 
Back
Top