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

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?
 
D

David H

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?
 
N

NewVBUser

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top