Triggering batch file from Outlook

Status
Not open for further replies.
Outlook version
Outlook 2007
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
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 New Slipstick.com Articles 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
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 5
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
L How to Import Exchange OST file into Outlook? Using Outlook 3
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
C Can't create Outlook data file Outlook Wishlist 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
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
W error with the permission for the file Outlook VBA and Custom Forms 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
DoctorJellybean Preserve OST file location in new installation? Using Outlook 4
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
A Populate Listbox from Txt File Outlook VBA and Custom Forms 0
M Same file "stuck" on top of file list in "Attach File" drop down Using Outlook 4
A Populate Textbox from Txt File Outlook VBA and Custom Forms 1
A Read and Write to Text File Outlook VBA and Custom Forms 1
geofferyh How to change the Attachment File Name? Outlook VBA and Custom Forms 1
S Moving .OST file location unsuccessful! Using Outlook 6
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1

Similar threads

Top