VBA Code no working.

[jmk15315]

So I have an interesting, yet confusing question. I have a worksheet that has vba code for a given task, that works flawlessly. I have created a new, seperate worksheet, but I needed the same funtion as the VBA Code from the first file. Rather that retype the code, I did a copy/paste from file #1 to File #2. While the code still works in File #1, it will not work in File #2

The highlighted portion is where the code crashes.

I am using the spreadsheet on the same computer, so I do not understand why I would have this issue in one file, but not the other.

Thoughts?

 

[rollis13]

In the new file, did you add reference to Microsoft Outlook xx.x Object Library in Tools / References menu of the VBE pane ?

 

[jmk15315]

In the new file, did you add reference to Microsoft Outlook xx.x Object Library in Tools / References menu of the VBE pane ?

I did not. I am drawing a blank as to how I need to get to that screen.

 

[rollis13]

LINK

 

[jmk15315]

LINK

Thank you, I was having a senior moment there.

 

[rollis13]

You're welcome.