Ok, so I would like to create a couple of distro lists in outlook 2013 from data excel sheets. I am trying to use VBA to read and excel file with names in Col A and email addresses in Col B.
I dont do VBA with outlook normally, so I researched up some code. 


Please Login or Register  to view this content.

I get an error the objRcpnt.Resolve line

Please Login or Register  to view this content.
After looking on MS Office site i found that you cant run somehting like this with Outlook open. Fine, I close it and try again. Same fail...but this time the password login gui for outlook opens up near simulteneously with the error box. If i type in the password it doesnt miraculously move anything along, obviously.

Is there some way to allow this code to operate while Outlook is open or to work despite the password protection issue? I am open to any way to speed up the distro-making process, because there are several, they have overlapping members, about 2-3 dozen members a piece and people change often. I need a more efficient way to handle it, so if anyone has any awesome ideas, i would appreciate it greatly.

Thanks