CrystalReports CMD eMail

@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 protected] -PASS your-password -FROM [email protected] -TO [email protected];[email protected] -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"