Open Specific Outlook Contact from Access

Thank you, Eric, for your help! MUCH appreciated!

I've managed to figure out code to create a user-defined field for a contact
item, but it appears it's putting the field in the folder collection instead
of the attaching it to the item. I'm going to have to play around with that
s'more and see what I'm doing wrong.

Also, I've done some preliminary reading on the AdvancedSearch method, as I
want to use it to search multiple folders in case the contact item has been
moved. The AdvancedSearch method seems *very* complex, so it might take me
awhile to figure it out. However, that looks to be the best way to deal with
my issue.

Btw, I've decided the idea of using Outlook Reminders to trigger an Access
event is not useful. I have all the info I need already in Access, so I've
decided to use it to trigger the reminder within Access. Without going into
all the code detail, my routine is in the Form_Open event of my application's
main menu (so it runs whenever the user starts the app). Using DAO, it looks
in the tblEvents table for
any reminders for that day and pops-up a MsgBox showing the reminder details.

Anyway, thanks again for your help! I think I'm pointed in the right
direction, now, although it might be a bit of a bumpy ride due to the
complexities of the AdvancedSearch method. If I need any further help,
I'll post a new thread.

Regards, Chris

"Eric Legault [MVP - Outlook]" wrote:

> Custom properties are added to Outlook items in code using
> UserProperties.Add. They are usually added when designing a custom form.
> Looking for an item via a custom property value usually involves using the
> AdvancedSearch method for looking in multiple folders or the Items.Find
> method for a single folder.
>
> To access reminders, look at the Application.Reminders collection. If you
> want to actually trap when a reminder occurs, declare an Outlook Application
> object variable using the WithEvents keyword so you can use the
> Application_Reminder event.
>
> --
> Eric Legault [MVP - Outlook]
> MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
> & WSS 3.0 Application Development)
> President
> Collaborative Innovations
> -> Try Picture Attachments Wizard 2.0 For Microsoft Outlook <-
> -> Take your SharePoint content offline <-
> -> More info: http://www.collaborativeinnovations.ca <-
> Blog: http://blogs.officezealot.com/legault
>
> "Chris O''''Neill" <ChrisONeill.TakeThisOut@discussions.microsoft.com> wrote in message
> news:8F5432F3-0C71-4634-B2D0-307911163AE9@microsoft.com...
> > In a question I posted to the Access Programming Forum, dch3 replied:
> >
> >>The EntryID and StoreID can change if the item is moved to another folder
> >> or if its parent is moved. In the past, I've created a custom property on
> >> the Outlook Side and set it to the primary ID of the record that I was
> >> working with. I then used the primary ID to locate the item again.
> >
> > I'd be interested in the code, especially if it helps locate the file even
> > if it has been moved. I'm very interested in seeing how you can create a
> > custom property on the Outlook side from Access. (Or did I misunderstand
> > that?)
> >
> > Btw, I'd also be interested in learning how to pull Reminder/ToDo items
> > from
> > Outlook from Access and trigger alerts in Access. Can you help me there?
> >
> > Thanks, so much, for your help...
> >
> > Regards, Chris
> >