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.
 

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

Similar Threads

Batch 2
Can't run Batch file 3
Integrate a Batch file in VBA 1
Batch file Open Word, run macro 0
Run batch file through a Access GUI 5
How to run a batch file or VBS from Access VBA code? 4
Running a remote Batch File 4
text file not created while running a batch file through access 0

Back
Top