thanks Ron

I have these hickups
1. If i go to Tools references is deactivated.
2. What do you mean by: Place a Checkmark before
Microsoft Outlook ? Object Library ? is the Excel
version number.
3. if i run macro sub Mail_ActiveSheet_Body the debugger
gives message "user - defined type not defined"

please help

Hi es

Please use the same thread

Alt-F11
Select your workbook on the left first
ToolsReferences
Search for Microsoft Outlook ? Object Library and check it
OK

There is also a example on my page for Late Binding (you don't have to use
ToolsReferences )


--
Regards Ron de Bruin
http://www.rondebruin.nl



"es" wrote in message ...
thanks Ron

I have these hickups
1. If i go to Tools references is deactivated.
2. What do you mean by: Place a Checkmark before
Microsoft Outlook ? Object Library ? is the Excel
version number.
3. if i run macro sub Mail_ActiveSheet_Body the debugger
gives message "user - defined type not defined"

please help

Ron de Bruin wrote:
Hi es

Please use the same thread

Web interface!


--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!