Create distribution list in Excel (late binding)

[matrix2280]

Hello,

I am trying to rewrite this macro so that I do not have to reference the Outlook reference library. From what I have found, i need to change the outlook Dims to Object, but now instead of Excel loading the distribution list window and adding the emails to the list, it only pulls up a blank outlook message window. Not sure what I am doing wrong here. The section below that is in bold is where it is showing a Message window instead of the distribution list window. I have also commented out the original Dims. The reason for the necessary change is that where I am referencing the Outlook 15 library, someone else is using a different version (newer) and every time they save the workbook, it looses the 15 references (Missing Microsoft Outlook 15.0 Object Library)

Any help would be greatly appreciated.

Here is the code

Please Login or Register  to view this content.

[AlphaFrog]

This should get you closer. I couldn't test it though. it's likely not perfect.

Please Login or Register  to view this content.

[matrix2280]

Thank you AlphaFrog. This worked perfectly!! I really appreciate your help on this.

[AlphaFrog]

Really? I'm kinda' surprised. I just eyeballed it and that rarely works 100%.

Anyways, you're welcome and thanks for the feedback.