- @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 email@example.com -PASS your-password -FROM firstname.lastname@example.org -TO email@example.com;firstname.lastname@example.org -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"
CrystalReports CMD eMail
a guest May 2nd, 2014 148 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
RAW Paste Data