run a batch file saved on server with VBA code or macro

  • Thread starter Thread starter NewVBUser
  • Start date Start date
N

NewVBUser

I have a batch file that runs the sendemail program with all the correct
switches for the to/from email addresses, etc. I want to be able to run this
batch file that is stored on the server where the db is housed from within MS
Access when a form is closed and the record saved.

Any suggestions? Can this be done?
 
If your users have Outlook on their desktops, why not use it via Office
Automation?

What's the reason that you're wanting to use a batch file to generate the
email?
 
I need to have the users invoke this application from the intranet and have
the users use a copy of ms access on their pc but not all users have office
email on the pc. Some PCs are used as a workstation of any user. The batch
file contains a perl script that will send email from the command line.
 
Back
Top