Why does Outlook.Application.GetNamespace("MAPI") Fail?

[Guest]

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).

 

[Tom Ogilvy]

Set NS = Application.GetObject("Outlook.Application").GetNamespace("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.

 

[Guest]

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

 

[Guest]

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.

 

[Tom Ogilvy]

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