|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: 2003, creating, email, error, excel, help, office |
|
|
Thread Tools | Display Modes |
|
#1
February 5th 07, 05:12 PM
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 
|
| Ads |
|
#2
February 5th 07, 05:23 PM
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
February 5th 07, 06:21 PM
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
February 5th 07, 06:25 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2007/Exchange 2003 error when creating multiple items | Tadwick | Outlook and VBA | 7 | February 23rd 07 07:33 PM |
| Import to Outlook 2003 from Excel 2003 - Translation Error | LC | Outlook - General Queries | 4 | January 22nd 07 09:50 PM |
| Error when trying to export outlook 2003 contacts into excel | susqmay | Outlook - Using Contacts | 2 | August 31st 06 02:45 PM |
| error importing excel calendar to outlook 2003 | SANMAN07 | Outlook - Calandaring | 1 | July 21st 06 02:08 PM |
| Outlook 2003: While importing contacts from Excel 2003, ISAM error | Juzar | Outlook - Using Contacts | 1 | April 10th 06 11:20 PM |
Linear Mode
