Open Specific Outlook Contact from Access

[Chris O''''Neill]

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

 

[Chris O''''Neill]

Opps! I left something out which may cause some folks to wonder why I'm
posting this here instead of staying over the the Access area...

dch3 requested that I reply here if wanted to see his code. As well, I
figured posting it here might bring some ideas from other folks conversant in
Access-Outlook interoperability.

Hope that clarifies things...

Regards, Chris

 

[Chris O''''Neill]

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

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

In a question I posted to the Access Programming Forum, dch3 replied:


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