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

Thanks for this timely post John.  We've been getting a lot of requests for custom Outlook forms lately which means it's only a matter of time before the form data will need to be analyzed or summarized.  Have you tried c.UserProperties("FieldName") to access your custom field data?

Does anyone know offhand if custom form fields act the same as adding a field to an existing form (in terms of data access)?

Thanks,

Jim DeMarco
Director Application Development
Hudson Health Plan


-----Original Message-----
From: John Skolits [mailto:Support at CorporateDataDesign.com]
Sent: Wednesday, July 14, 2004 5:31 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Outlook and Access, Linking "SOLVED - Sort-Of"




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


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


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************