[AccessD] Outlook and Access, Linking "SOLVED - Sort-Of"

John Skolits Support at CorporateDataDesign.com
Wed Jul 14 16:30:54 CDT 2004



I really wanted to do a linking but not all the fields are available. But If
is Use code and use
 Dim c As Outlook.ContactItem  

You can get the user field by using c.UserProperties(i). Where "i" is the
enumerated value of the fields you created. I created 2 fields so they are:
c.UserProperties(1) and c.UserProperties(2).

C .UserProperties(1).NAME    will give your field name. 

So I guess I'll just run an import routine on startup and load everyone into
my database that way.

John




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Wednesday, July 14, 2004 4:31 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Outlook and Access, Linking


Maybe someone has some code out there. I'd prefer a link so I don't have to
manually import or export new contact info between the two.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of StaRKeY
Sent: Wednesday, July 14, 2004 4:25 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Outlook and Access, Linking


Mmmzz as I recall you can get to those fields by using Outlook's
objectmodel, since the linking using Exchange() is some sort of default
link.

Custom fields are kept in a seperate 'table' I believe which is why you
don't see these... 

Regards, 
Eric Starkenburg 

-----Oorspronkelijk bericht----- 
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens John Skolits 
Verzonden: woensdag 14 juli 2004 21:59 
Aan: 'Access Developers discussion and problem solving' 
Onderwerp: [AccessD] Outlook and Access, Linking 

I added a custom field to my contacts form. When I link to my Outlook
Contacts folder with Access 2002 using Exchange() during the linking, it
doesn't show this new field. Any one know why?

John Skolits 



-- 
_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 



  _____  

avast! Antivirus <http://www.avast.com> : Uitgaande bericht is niet besmet. 


Virus Gegevensbestand (VPS): 0429-0, 12-07-2004
Getest op: 14-7-2004 22:24:43
avast! auteursrecht (c) 2000-2004 ALWIL Software.



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list