View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Error creating email from Excel (Office 2003)

Hi Ed

Download the example workbooks on my site for Outlook and see if you
have problems when you test the examples

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ed" wrote in message ...
Hi, Ron. I ran all around your site and Dick's last week and could not get
anything to work except at home. Maybe there's something in the security
stuff here that's blocking it.
Ed

"Ron de Bruin" wrote in message
...
Hi Ed

If you use object use

CreateItem(0)

For more info look here
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ed" wrote in message
...
I did this at home using Win98SE and Office Pro 2000, and it worked fine.

' Create email
Dim OL As Object
Dim EmailItem As Object

Application.ScreenUpdating = False
Set OL = CreateObject("Outlook.Application")
Set EmailItem = OL.CreateItem(olMailItem)
With EmailItem

I'm trying to run down an inventory list and send late users a reminder
email. At home, it was fine. I get to work to use it, where I'm running
Windows XP Pro and Office 2003, and I get
Run-time error 40036
Application-defined or user-defined error
on the line
Set EmailItem = OL.CreateItem(olMailItem)

Can someone help straighten this out for me?

Thanks.
Ed