Send Alerts to Application user base

[redbull]

I am looking for a solution to notifying the userbase (100 people). Currently the Managers are emailing the group, however as with most company emails they are largely ignored.



Currently I have a form on the application that they open, its called frmAdvert. And IF I know a day in advance I can it up so the following morning the users will see this advert on open. I would like to allow this happen "live" during the day. Possibly just have the Managers have a document stored on the shared drive open for all users.

Any thoughts on how this can be accomplished. If not, do YOU have any use for this? Anyone like to collaborate to build it?

I am thinking that Powershell can be utilized, somewhere....

or possibly a file check something like "IF \\computername\c$\Program Files\Application\ any.LBD" then
oshell yadda yadda, open up the document the manager has placed on the shared drive.

[RuralGuy]

Maybe you will find this link helpful: http://www.utteraccess.com/forum/Ins...8#entry1064398

[redbull]

Very interesting. I am trying to piece together what was done here. It does not seem to be a working example right now.

[redbull]

Progress thus far...

Public Sub ProcedureInAccess()
Dim Path As String
Dim acApp As Object
Dim db As Object


Path = "\\remotemachinename\c$\Program Files\MyApp\MyApp.ldb" ' file path on remote machine
Set acApp = CreateObject("Access.Application")


If Len(Dir(Path)) > 0 Then  ' Does the ldb exsist? meaning is the application open?
acApp.OpenCurrentDatabase ("\\remotemachinename\c$\Program Files\MyApp\MyApp.mde")
acApp.Visible = False
Set db = acApp
acApp.Run "Help"  'Module to run
acApp.Quit
Set acApp = Nothing
   
End If
End Sub

So, The code above does about half of what I need it to do. It identifies if a remote user has the application open. The part I am getting wrong is this will run the "Help" module on my local machine. Any ideas?

[RuralGuy]

I never played with it so I'm clueless.