Create an 'event procedure' to open on the 'on-click' event behind a command button and try to open the .xls from there:
EG
Private Sub OpenXls_Click()
On Error GoTo Err_OpenXls_Click
Dim RetVal
RetVal = Shell("C:\Program Files\Microsoft Office\Office\EXCEL.exe...
The following VBA code in the "On Click" property behind a command button should send a message to each of the people in the table you have set up. It will help if you have an email field in the table.
Basically what it should do is supply the contents of the subject and the message to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.