msg command from CMD line

[Freshman]

OK but in my view rather a strange request

No error message for me in Access

Personally I like your idea more as it is one box to close. I might give them both options (with a tickbox in the Global Settings to choose between the 2).

The Access thing is still a mystery - might be a setting inside Access Options which is different.

 

[Gasman]

Try with the full path for the msg file ?

 

[Freshman]

Try with the full path for the msg file ?

Great advice but not without hiccups:
My system is also 32 so my msg.exe file is in the same place but inspite of providing the full path:

Shell "C:\Windows\System32\msg.exe * test"

I once again got file not found

So I copied the file to root and tried

Shell "C:\msg.exe * test"

And it worked 100%

I might add a copy command before the code to solve this issue

Thanks a lot for sticking with this issue

 

[Gasman]

Very weird

 

[isladogs]

Just a random thought...
Try ticking the Microsoft Shell Controls and Automation Reference

 

[Gasman]

Just a random thought...
Try ticking the Microsoft Shell Controls and Automation Reference

FWIW, that is not included in a DB where it works as I posted.

 

[isladogs]

It also wasn't included in the db where I tested both bits of code successfully.
Just wondered if it might solve the issue for the OP.

 

[Freshman]

Just a random thought...
Try ticking the Microsoft Shell Controls and Automation Reference

Nope -
But at least I have a working solution

 

[essaytee]

I get a "file not found" which makes sense since the Shell command would be looking for "msg". I'm running Win 7 so I cannot comment on Win 10 but we are running same Access 2007 so I still find it a bit weird that yours are working. Strange hey

FWIW, I get the same error message. I'm running Win 10 Pro, Access 2016.

 

[Freshman]

Have a look at the solution above

 

[apr pillai]

If your machine is a Workstation of Intranet then you can use the NET SEND command to send messages to other workstations, by typing the following command on the DOS Prompt:

C:\>NET SEND "workstationID' "Message"

This can be automated through VBA based on speccific requirements. Check the following link: Sending Alerts to Workstations