E-mail from VBA not working anymore

[ForSale]

Now everytime i try to send an e-mail from Excel i get the followin
error message:
Compile Error:
user-defined type not defined

and then it highlights:
olApp As Outlook.Application

i have several other workbooks that this works on, any idea why i
wouldn't work today

 

[Frank Kabel]

Hi
have you set a reference to the Outlook ob ject library?

 

[Paul Robinson]

Hi
Check that you have a reference to the OutLook Library. In the VB
Editor go to Tools, References and look for OutLook. If it is not
clicked, OutLook objects are not recognised, and assumed to then be a
user defined type.
regards
Paul

 

[ForSale]

yes, i have the reference. here's what's throwing me for a loop.
i have a workbook with that code that works. i opened it, copied th
code word for word and put it in a new workbook. i ran the origina
and it works, but doesn't work on the second workbook. what the world

 

[Dick Kusleika]

ForSale

The reference doesn't copy over just because you copy the code. The new
workbook doesn't have the reference set. If you would like to copy the code
to different workbooks, consider using late binding.

http://www.dicks-clicks.com/excel/olBinding.htm