Can anyone point me in the direction as to why the following fails?

Set NS = Outlook.Application.GetNamespace("MAPI")

It is done on a server that only has outlook and exel installed (Excel is
the full instlal, outlook is only partially).
--
-Lee

Hi Lee,
I believe the MAPI namespace only works if Outlook is configured for
CIW (Corporate Intranet/Workgroup?), not Internet Mail (or whatever the other
option is). Also, the MAPI namespace is a connection to an MS Exchange
Server, so a "partial" install of Outlook may not be enough to allow you to
use the MAPI namespace. Another possible cause of the problem: trying to get
to the namespace without an instance of the Outlook Application object. Try
this instead:

set myOutApp = GetObject("Outlook.Application")
set NS = myOutApp.GetNamespace("MAPI")

Using GetObject will allow you to use an existing instance of Outlook, if
there is one; otherwise it will create a new instance. If you prefer to
create a new instance anyway, change the first line to:
set myOutApp = new Outlook.Application

Hope this helps!

Shadhi

"Lee" wrote:

Can anyone point me in the direction as to why the following fails?

Set NS = Outlook.Application.GetNamespace("MAPI")

It is done on a server that only has outlook and exel installed (Excel is
the full instlal, outlook is only partially).
--
-Lee

Okay, I found the problem. It is saying I am missing a .dll file. Does
anyone know what the .dll file I would need for this, its really Excel
running an outlook method. Thanks.
--
-Lee


"Shadhi" wrote:

Hi Lee,
I believe the MAPI namespace only works if Outlook is configured for
CIW (Corporate Intranet/Workgroup?), not Internet Mail (or whatever the other
option is). Also, the MAPI namespace is a connection to an MS Exchange
Server, so a "partial" install of Outlook may not be enough to allow you to
use the MAPI namespace. Another possible cause of the problem: trying to get
to the namespace without an instance of the Outlook Application object. Try
this instead:

set myOutApp = GetObject("Outlook.Application")
set NS = myOutApp.GetNamespace("MAPI")

Using GetObject will allow you to use an existing instance of Outlook, if
there is one; otherwise it will create a new instance. If you prefer to
create a new instance anyway, change the first line to:
set myOutApp = new Outlook.Application

Hope this helps!

Shadhi

"Lee" wrote:

Can anyone point me in the direction as to why the following fails?

Set NS = Outlook.Application.GetNamespace("MAPI")

It is done on a server that only has outlook and exel installed (Excel is
the full instlal, outlook is only partially).
--
-Lee

Why not try an Outlook group. You have departed from any dependence on
Excel.

--
Regards,
Tom Ogilvy


"Lee" wrote in message
...
Okay, I found the problem. It is saying I am missing a .dll file. Does
anyone know what the .dll file I would need for this, its really Excel
running an outlook method. Thanks.
--
-Lee


"Shadhi" wrote:

Hi Lee,
I believe the MAPI namespace only works if Outlook is configured
for
CIW (Corporate Intranet/Workgroup?), not Internet Mail (or whatever the
other
option is). Also, the MAPI namespace is a connection to an MS Exchange
Server, so a "partial" install of Outlook may not be enough to allow you
to
use the MAPI namespace. Another possible cause of the problem: trying
to get
to the namespace without an instance of the Outlook Application object.
Try
this instead:

set myOutApp = GetObject("Outlook.Application")
set NS = myOutApp.GetNamespace("MAPI")

Using GetObject will allow you to use an existing instance of Outlook,
if
there is one; otherwise it will create a new instance. If you prefer to
create a new instance anyway, change the first line to:
set myOutApp = new Outlook.Application

Hope this helps!

Shadhi

"Lee" wrote:

Can anyone point me in the direction as to why the following fails?

Set NS = Outlook.Application.GetNamespace("MAPI")

It is done on a server that only has outlook and exel installed (Excel
is
the full instlal, outlook is only partially).
--
-Lee

Set NS = Application.GetObject("Outlook.Application").GetNa mespace("MAPI")

Would be more what your are looking for. This would require Outlook to be
running at the time.

If it isn't running, use CreateObject instead. See VBA help on GetObject
and CreateObject for examples and explanations.

--
Regards,
Tom Ogilvy

"Lee" wrote in message
...
Can anyone point me in the direction as to why the following fails?

Set NS = Outlook.Application.GetNamespace("MAPI")

It is done on a server that only has outlook and exel installed (Excel is
the full instlal, outlook is only partially).
--
-Lee