Results 1 to 4 of 4

Thread: Finding Outlook Meeting from Excel

  1. #1

    Finding Outlook Meeting from Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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("MAPI").GetDefaultFolder(olFolderCalendar).Items
    Thanks,

    Fouko

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,208
    Articles
    57
    Blog Entries
    14
    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, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,208
    Articles
    57
    Blog Entries
    14
    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.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    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
    Regards,
    Zack Barresse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •