ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   email 2 (https://www.excelbanter.com/excel-discussion-misc-queries/10395-email-2-a.html)

es

email 2
 
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

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




Gordon

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!


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com