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