Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
Houm,
Outlook express is set as your default mail handler, change this to Outlook proper, and things should be cured. HTH Neil www.nwarwick.co.uk "Houm" wrote: Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
Hi, Thanks. But Where can I change the default? -----Original Message----- Houm, Outlook express is set as your default mail handler, change this to Outlook proper, and things should be cured. HTH Neil www.nwarwick.co.uk "Houm" wrote: Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
Hi,
I share the same problem: how can you know in VBA what the default email handler is? Thanks Jos Vens "Neil" schreef in bericht ... Houm, Outlook express is set as your default mail handler, change this to Outlook proper, and things should be cured. HTH Neil www.nwarwick.co.uk "Houm" wrote: Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
You normally set this within Outlook, usually when you start Outlook and the
E-mail handler within it will ask you if you wish to make Outlook the default, obviously you will answer yes to this. However, you MAY be able to do this in VBA, using the following code. Dim objOutlook As Object Dim objmailItem As Object 'Create the Outlook object Set objOutlook = CreateObject("Outlook.Application") 'Access a new mail item Set objmailItem = objOutlook.CreateItem(olmailItem) This some VBA code I use in an Access database that starts up Outlook and then creates a new email. You could try using this in Excel, I can't see why it wouldn't work. If you don't want to open a new E-mail, then leave out the last line. I haven't tried it out myself, but I think it will be ok, let me know how you get on. HTH Neil www.nwarwick.co.uk "Jos Vens" wrote: Hi, I share the same problem: how can you know in VBA what the default email handler is? Thanks Jos Vens "Neil" schreef in bericht ... Houm, Outlook express is set as your default mail handler, change this to Outlook proper, and things should be cured. HTH Neil www.nwarwick.co.uk "Houm" wrote: Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open MS Office Outlook
See
http://www.rondebruin.nl/mail/problems.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Neil" wrote in message ... You normally set this within Outlook, usually when you start Outlook and the E-mail handler within it will ask you if you wish to make Outlook the default, obviously you will answer yes to this. However, you MAY be able to do this in VBA, using the following code. Dim objOutlook As Object Dim objmailItem As Object 'Create the Outlook object Set objOutlook = CreateObject("Outlook.Application") 'Access a new mail item Set objmailItem = objOutlook.CreateItem(olmailItem) This some VBA code I use in an Access database that starts up Outlook and then creates a new email. You could try using this in Excel, I can't see why it wouldn't work. If you don't want to open a new E-mail, then leave out the last line. I haven't tried it out myself, but I think it will be ok, let me know how you get on. HTH Neil www.nwarwick.co.uk "Jos Vens" wrote: Hi, I share the same problem: how can you know in VBA what the default email handler is? Thanks Jos Vens "Neil" schreef in bericht ... Houm, Outlook express is set as your default mail handler, change this to Outlook proper, and things should be cured. HTH Neil www.nwarwick.co.uk "Houm" wrote: Hi, Here's my code to open the MS Office 2000 Outlook. Application.Dialogs(xlDialogSendMail).Show But when I ran it, it open the Outlook Express instead of my MS office Outlook. It's there a sitting to change the default to Ms office 2000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open Excel in different windows AND open from Outlook? | Setting up and Configuration of Excel | |||
eula pops up every time i open an office program. office 2003 ins. | Excel Discussion (Misc queries) | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
How can I run Incredimail on Office Outlook | Setting up and Configuration of Excel | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) |