Triggering batch file from Outlook

Status
Not open for further replies.
N

newbieoultookuser

Member
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
 
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.
< Outlook VBA - moving mail item to public folder using variable within path | Outlook 2010 unable to send iCloud account e-mail after iOS 7 upgrade >
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
E "Cannot display the folder. MS Outlook cannot access the specified file location" Using Outlook 4
M Outlook 365 macro - automatically attach file based on subject line Outlook VBA and Custom Forms 0
S Import pst file into 365 desktop and have it sync one Using Outlook.com accounts in Outlook 2
T Cannot open .pst file Using Outlook 2
D DB/Object/Record vs File/List/Range Terminology Outlook VBA and Custom Forms 0
Rob Can't save MailItem because the message changed in .pst file Outlook VBA and Custom Forms 0
C Advanced search terms for "Outlook Data File" Using Outlook 1
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 0
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
E Save Selected Email Message as .msg File - digitally sign email doesn't works Outlook VBA and Custom Forms 1
W Outlook 365 File access denied attempting to import .pst Using Outlook 6
P Copying ALL calendar entries from Calender in PST file to IMAP OST file? Using Outlook 1
R Saving Emails and Attachments as .msg file Using Outlook 3
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
Wotme create email only data file Using Outlook 1
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

Similar threads

Back
Top