I am using
Set olApp = New Outlook.Application
but this seems to fail on a machine with multiple profiles. Any suggestions
please

It shouldn't fail even with many profiles. I have 8 on my main development
machine for example. You should either open into the default profile or get
prompted as to which profile to open Outlook with.

Did you try CreateObject("Outlook.Application")?

Are you sure that something else isn't involved, such as a script stopper
from an A-V program or firewall that is preventing New or CreateObject from
working? Those are know to be able to do that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"judith" wrote in message
...
I am using
Set olApp = New Outlook.Application
but this seems to fail on a machine with multiple profiles. Any
suggestions
please

I have tried turning off the firewall etc but this machine doesnt seem to
like it. It never gets past the first Outlook statement. Could it be anything
to do with loaded libraries. I have DAO and outlook loaded, should i try
anything else.

It is fine if I use a docmd.sendobject from Access though

Thanks

"Ken Slovak - [MVP - Outlook]" wrote:

It shouldn't fail even with many profiles. I have 8 on my main development
machine for example. You should either open into the default profile or get
prompted as to which profile to open Outlook with.

Did you try CreateObject("Outlook.Application")?

Are you sure that something else isn't involved, such as a script stopper
from an A-V program or firewall that is preventing New or CreateObject from
working? Those are know to be able to do that.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"judith" wrote in message
...
I am using
Set olApp = New Outlook.Application
but this seems to fail on a machine with multiple profiles. Any
suggestions
please

All you need to automate Outlook is Outlook being installed and a reference
to that library in your VBA project. Even without the reference you can
still automate Outlook, you'd just have to use late binding.

The DoCmd.SendObject command doesn't directly use Outlook, it uses Simple
MAPI and that calls whatever the default MAPI provider is set to. It could
be Outlook, it could be Outlook Express, it could even be Eudora or any
other MAPI provider.

What error are you getting? Saying it fails really tells us nothing.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"judith" wrote in message
news
I have tried turning off the firewall etc but this machine doesnt seem to
like it. It never gets past the first Outlook statement. Could it be
anything
to do with loaded libraries. I have DAO and outlook loaded, should i try
anything else.

It is fine if I use a docmd.sendobject from Access though

Thanks

I get Runtime error 424 object required if that helps
thanks

"Ken Slovak - [MVP - Outlook]" wrote:

All you need to automate Outlook is Outlook being installed and a reference
to that library in your VBA project. Even without the reference you can
still automate Outlook, you'd just have to use late binding.

The DoCmd.SendObject command doesn't directly use Outlook, it uses Simple
MAPI and that calls whatever the default MAPI provider is set to. It could
be Outlook, it could be Outlook Express, it could even be Eudora or any
other MAPI provider.

What error are you getting? Saying it fails really tells us nothing.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"judith" wrote in message
news
I have tried turning off the firewall etc but this machine doesnt seem to
like it. It never gets past the first Outlook statement. Could it be
anything
to do with loaded libraries. I have DAO and outlook loaded, should i try
anything else.

It is fine if I use a docmd.sendobject from Access though

Thanks

You get a 424 on code like this?

Dim olApp As Outlook.Application
Set olApp = New Outlook Application

or

Set olApp = CreateObject("Outlook.Application")

That would usually indicate that Outlook isn't correctly installed. If it
was an early binding reference problem then you'd get an error on the Dim
statement. If you get the error after the automation creation line it would
usually indicate that olApp was Nothing and something was preventing
creation of the object, such as a script stopper.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"judith" wrote in message
...
I get Runtime error 424 object required if that helps
thanks