DB Engine :: Send Multiple Attachments With Database Mail In Server

I am sending multiple attachments with database mail for that i have created script to generate file names and send it to mail. Below are my script

DECLARE @MailFile VARCHAR(100)
SET @MailFile = 'Detail_Reimbursement_1_15_'
+ LEFT(CONVERT(VARCHAR, Getdate()), 3)
+ Substring(CONVERT(VARCHAR, Getdate(), 100), 8, 4)
+ '.csv'

[Code] ....

The script is working fine if i manually provided file path to @file_attachments. it is showing error i passes the variable @Loc3 to @file_attachments. Below is the error if i passes the variable to @file_attachments parameter.

(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
Msg 22051, Level 16, State 1, Line 0
Attachment file 'E:DatabaseTannaFinanceReportDetail_Reimbursement_1_15_Aug2015.csv is invalid.