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
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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. :)
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
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
 
Top