Finding Outlook Meeting from Excel

Fouko

New member
Joined
Feb 8, 2012
Messages
5
Reaction score
0
Points
0
Hi,

Do you know a way to search and find an existing meeting in Outlook to add attendees from Excel ?

Someone give me this, but I don't know how to use it :
Code:
outlook.Getnamespace([COLOR=#ff0000]"MAPI"[/COLOR]).GetDefaultFolder(olFolderCalendar).Items

Thanks,

Fouko
 
Hi Fouko,

From there you'd need to either loop through the Outlook appointments or use a find method to find them.

I believe I have some code at work to cycle through appointments. I'll see if I can dig that out for you tomorrow.
 
Hi Fouko,

There's a similar question going on in this thread, and I've posted some code there. Rather than repeat myself here, have a look at that one and see if it helps. :)
 
Take a look at using the Restrict method. It will be much more efficient than looping through, what could be, hundreds or thousands of calendar items. Look it up, as you can't use on all properties, like the body, but you can on dates and times.

Zack
Sent from my mobile using Tapatalk
 
Back
Top