View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default VBA code to send a system message?

Thanks again Tom.
Do I need to reference a Shell library then?

The VBE isn't recognizing "Net Send"...

"Tom Ogilvy" wrote:

Use Shell and
Net Send ComputerName Msg

or
Net Send * Msg

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Thanks for the reply, but actually, it's neither email nor a message box.

There is a method to send a system popup message to users on a network if
you know their computer name - without using an email system. It is great
whenever your email system is down. That is what I'm after...any ideas?

"booner" wrote:

Not exactly sure what you mean by a system message ... so could be two
possibilities: email or a message box.

Look into these:

CDO.Message (send email)
MsgBox (popup a dialog box to the user)

BBB

"quartz" wrote in message
...
I am using Office 2003 on Windows XP.

Could someone please post example VBA code or script to send a system
message to user(s)? - Or point me to a web site that may help. This

would
be
extremely helpful when Oulook is down.

Thanks much in advance.