Outlook and Access

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?
 
K

Karl Timmermans

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding contacts to Outlook from Access DB 1
Strange icon next to contact 5
where address book / contact list located 2
Outlook 6 to Outlook 2007 Contacts NOT populating 4
What does a post icon next to a contact mean? 2
Deleting Contacts - Contacts v/s GAL Contacts 1
Contacts for mobile devices in Exchange 0
Import emails addresses to my email address book in Outlook 1

Top