Compile error - I need advice on what wrong please

[nje]

Good Morning
I have attached a sample worksheet which is more or less complete except for one compile error (User defined type not defined)
I want to be able to email the worksheet to other committee members but I get the compile error. the email button I'm using is on he right hand sheet.
I use the same code in another workbook and it works perfectly. Unfortunately I haven't a clue what I'm meant to be changing because it all looks alright to me.
Could someone take a look please and advise what I need to change, its probably obvious but unfortunately not to me.

Thanks

[BadlySpelledBuoy]

In the VB Editor window click on "Tools / References". Scroll down the list and put a tick next to "Microsoft Outlook 14.0 Object Library" then click OK.
Now test and see if it works as expected.

BSB

[nje]

BadlyspelledBouy. - Thanks very much, that did the did the trick. So simple, but yet so hard when you don't know. Thanks again.

[BadlySpelledBuoy]

One of those "only easy when you know where to look" moments I'm afraid.

Happy to help. Glad you have it sorted now

Thanks for the rep.

BSB

[bakerman2]

No need for all those variables or References.

Please Login or Register  to view this content.