Results 1 to 2 of 2

Thread: Import from outlook issue - urgent

  1. #1

    Import from outlook issue - urgent



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

    Hello,

    First of all, thank you very much for the wondeful forum and help we got from it

    I used the excel file in the following thread: excelguru.ca/forums/ showthread.php?776-Copy-Outlook-Calendar-to-Excel

    the file works fine on my pc (xp/office 2007) and when we try it on another pc with the same configration, it gives an error messgae:

    outlook does not recognize one or more names
    80020009

    it happens on different pcs with the same configuration

    it is really weird, it blocks before having the warning to allow access to outlook for 1/2/5/10 minutes

    it blocks on the lines:

    Set objRecipient = olNS.CreateRecipient(strSharedMailboxName)
    objRecipient.Resolve
    Set myCalItems = olNS.GetSharedDefaultFolder(objRecipient, 9).Items '9=olFolderCalendar



    can you please help? I tried many things but always same issue

    this is quite urgent please, so all help is appreciated as I can't find from where comes the problem



    thanks a lot

  2. #2
    Hello

    if it may help, it works apparently fine on office 2010, maybe a references issue? but it work also on windows xp without any problems on my pc

Posting Permissions

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