Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @echo off
- REM run vbscript to export report
- "C:\Customer Folders\VBScript Location\crystal_export_excel.vbs"
- REM need to put delay before next command possibly
- ping www.google.com
- REM now rename email and archive the file
- ren "C:\Customer Folders\Output Location\*.xls" %date:~10%-%date:~4,2%-%date:~7,2%_ReportName.xls
- "C:\Program Files\Febooti Command line email\febootimail" -SMTP smtp.youremailserver.com -USER you@youremailserver.com -PASS your-password -FROM noreply@youremailserver.com -TO customer1@recipient.com;customer2@recipient.com -SUBJECT "eMail Subject" -BODY "Attached File - Automated Crystal Export" -FILE "C:\Customer Folders\ExportedFile Location\*.xls"
- move "C:\Customer Folders\ExportedFile Location\*.xls" "C:\Customer Folders\Archive Folder Location\archive"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement