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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
|
|||
|
|||
Error creating email from Excel (Office 2003)
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 |
#3
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error creating email from Excel (Office 2003)
Never mind, Ron. Thanks so much for chiming in. There were so many errors
that I abandoned Excel altogether, and wrote my data into a Word doc and used the mailing code there. Everything runs clean (I could do that because I just needed to send a text message - I didn't have to attach a workbook or worksheet). As long as it all works, I'm not going to bother digging into the other errors. I'd likely run afoul of the IT police! Ed "Ron de Bruin" wrote in message ... 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 |
Reply |
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) |