Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error while creating excel sheet in office 2007 using mhtml | Excel Programming | |||
can i email an excel spreadsheet from office 2003 to a mac user | New Users to Excel | |||
I have Office 2003. Why can't I read an old excel email attachment | Excel Discussion (Misc queries) | |||
comile error for sheet in office 2000 but not office 2003?? | Excel Programming | |||
Help with Compile Error in Excel Office 2003 | Excel Discussion (Misc queries) |