Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail from VBA not working anymore
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail from VBA not working anymore
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 wrote in message ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail from VBA not working anymore
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 -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail from VBA not working anymore
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 -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "ForSale " wrote in message ... 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 the code word for word and put it in a new workbook. i ran the original and it works, but doesn't work on the second workbook. what the world? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AddIn Analysis Pak not working anymore | Excel Worksheet Functions | |||
CTRL+SPACEBAR not working anymore | Excel Discussion (Misc queries) | |||
VLOOKUP not working anymore | Excel Worksheet Functions | |||
unselecting not working anymore? | Excel Discussion (Misc queries) | |||
it's not working anymore, please help! | Excel Programming |