Triggering batch file from Outlook

Status
Not open for further replies.
Outlook version
Email Account
Exchange Server
How can we trigger a batch file from within Microsoft Outlook ? We receive email notifications of when the database backups are completed between 2AM and 4AM at a shared drive. These emails are sent to our team's email group. As soon as I receive this email (my email id is part of the team's email group), I want outlook to start running a batch file to start the copy process. I won't be logged on to Outlook at this hour of the night, therefore, i need some automated way of outlook to trigger the execution of the batch file.

In which version of Outlook is it possible? I have Outlook 2007, but if required, I can ask my company to give me a different version (Outlook 2010 or 2013?)..

Also, is there a different way (other than using Outlook) to achieve this task?

Thanks,

newbieoutlookuser
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
while you can trigger a batch file using a rule or other trigger, you can't do it from outlook unless outlook is open. Triggering it from the server requires an event sink and permission to run software on the server.

How are you backing the db up? Can you add the copy routine to the backup routine?

I use this in a batch to backup SQL db then cleanup old db.

REM Run TSQL Script to backup databases

sqlcmd -S server_name -E -i "C:\SQLBackUp\scripts\backupDB.sql"

REM Run database backup cleanup script

C:\SQLBackUp\scripts\deleteBAK.vbs
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P ThisOutlookSession not triggering for TaskItems Using Outlook 3
B ItemAdd event not functioning - not triggering. Outlook VBA and Custom Forms 2
O Batch update calendar Using Outlook 3
M Batch print without appended trail of repeated e Using Outlook 2
F Send multiple batch tasks to single person Using Outlook 3
Diane Poremsky Batch Import Photos into Outlook Contacts Using Outlook 0
Z Batch Change Folder Views in Outlook 2016 Using Outlook 1
J Hyperlinks to batch files with parameters Using Outlook 3
P Batch adding text to email subject lines in Outlook Using Outlook 24
C "The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file location" Using Outlook 1
L Restoring Outlook from backup pst file Using Outlook 5
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
DoctorJellybean Use OST file location for fresh installation? Using Outlook 1
HarvMan Exporting IMAP OST file to PST Using Outlook 5
P File Picker for attachment Outlook VBA and Custom Forms 0
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
N File Picker for attachment Outlook VBA and Custom Forms 2
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
L Article on merging pst file Using Outlook 1
J Deliver new messages to New or Existing Data File? Using Outlook 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
O Comma Separated Values.ADR and A file error has occurred in the translator Using Outlook 6
R Problem moving file “Email folders.pst” to new PC Using Outlook 5
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
V Pin a document to the "Attach file" Recent Documents list Using Outlook 0
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
B Can I create a local PST file for SPAM on a drive that is usually disconnected? Using Outlook 3
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
G Cannot Move Autocomplete File to New Computer Using Outlook 15
B Outlook 2013 erratically deleting original file that is attached Using Outlook 0
I Outlook 365 - import/attach PST file that used POP3 Using Outlook.com accounts in Outlook 0
M Deleting attachments does not reduce file size Using Outlook 0
P PST file is getting huge under POP 3 Using Outlook 2
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
F Script for zip file attachment Outlook VBA and Custom Forms 1
M Export-Import .pst file problems Using Outlook 2
L Cannot open PST file for first session each day Using Outlook 6
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
S What's in a PST file? Using Outlook 1
S automate save the .xlxs file to share Network Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
A Order of Recent Items in Attach File List Using Outlook 5

Similar threads

Top