Import from outlook issue - urgent

excelnoob

New member
Joined
Apr 2, 2014
Messages
2
Reaction score
0
Points
0
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
 

excelnoob

New member
Joined
Apr 2, 2014
Messages
2
Reaction score
0
Points
0
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
 
Top