I have a workbook which is distributed to many users. I'd like to
build into it a procedure which would automatically save the Wb,
attach it to an email and send it back to me.

One of the difficulties I've found is that I can't guarantee that all
users have an Outlook Object Library selected. Hence when the
procedure starts with the usual declaration:-

Dim oOutlookObj as Outlook.Application

the user gets the error message 'Compile error: User-defined type not
defined'

Leaving aside the illogicality of that statement, is there any way
that the Object Library can be attached programatically? i.e the
equivalent of manually selecting Tools References and then clicking
the Outlook Object Library in the VBA window

TIA


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________