Creating contacts items from Access 2003

[JH]

Folks,

I am playing around with a contacts management database and trying to link
it to Outlook contacts. No problem linking the tables and viewing or editing
the contacts in access that are held in Outlook. The problem I have is that
when you try and create a new Outlook Contact via an Access form, it creates
it as a mail item, not a contact item.

Now I have posted on this before and got a very helpful suggestion which is
to programmatically create the new contact item - and this does work.

BUT it is tedious, and I feel that there must be some way of forcing access
to create a contact item not a mail item from a form.

I could trap all new entries created by the form and instead of allowing the
form to write them to the table I could write them myself - but this is just
repeating what outlook does already, there must be a way surely?!

John

 

[Sue Mosher [MVP-Outlook]]

How are you creating the item? You can't just add a row to the linked table. You need to use Outlook automation, specifically the Application.CreateItem method, to create a new item in Outlook, then set its properties and save it. If you are new to Outlook automation code, see http://www.outlookcode.com/d/vb.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers