ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA code to send a system message? (https://www.excelbanter.com/excel-programming/347984-vba-code-send-system-message.html)

quartz[_2_]

VBA code to send a system 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.

booner

VBA code to send a system message?
 
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.




quartz[_2_]

VBA code to send a system 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.





Tom Ogilvy

VBA code to send a system message?
 
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.







quartz[_2_]

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.







Dave Peterson

VBA code to send a system message?
 
VBA has its own Shell command. Look at VBA's help for more info.

quartz wrote:

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.







--

Dave Peterson


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com