LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
Ed Ed is offline
external usenet poster
 
Posts: 399
Default HELP: Error creating email from Excel (Office 2003)

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error while creating excel sheet in office 2007 using mhtml Sharad Birajdar[_2_] Excel Programming 0 February 2nd 07 05:47 AM
can i email an excel spreadsheet from office 2003 to a mac user trishia50 New Users to Excel 1 December 1st 06 04:51 AM
I have Office 2003. Why can't I read an old excel email attachment Kevin Excel Discussion (Misc queries) 1 May 17th 06 07:55 PM
comile error for sheet in office 2000 but not office 2003?? Bob Aylward[_2_] Excel Programming 1 December 13th 05 07:36 PM
Help with Compile Error in Excel Office 2003 Julian Cann Excel Discussion (Misc queries) 2 April 4th 05 02:35 AM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"