View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Error creating email from Excel (Office 2003)

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