View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default E-mail from VBA not working anymore

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

--
Regards
Frank Kabel
Frankfurt, Germany


Now everytime i try to send an e-mail from Excel i get the following
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 it
wouldn't work today?


---
Message posted from http://www.ExcelForum.com/