User-defined type not defined when copying macro from one workbook to another

Hi All,

I have tried to copy over a macro from a different workbook that works absolutely fine, but when I pasted the code below into a module of my new workbook I get the error Compile error: User-defined type not defined on the line:

Please Login or Register  to view this content.

The macro prepares and populates a new email with specified text and part of the workbook pasted into the email. I don't understand why this worked perfectly well in the old workbook, but by transferring it into the new one it stops functioning? The full code is blow:

Please Login or Register  to view this content.

Good afternoon Mogles

You are missing a reference. In your original workbook, from the VBE go to Tools > References and note which ones are ticked.
In your new workbook, do the same and you will probably find that one is missing. Find it, tick it, and you should be good to go.

As you're doing something with e-mail it will probably be the Outlook Object Library (just a guess).

HTH

DominicB

You must select the appropriate reference (for Outlook) in "Tool \ References" (vba editor, alt+f11) in the new workbook.