I have a maintenance plan which put out a report everyday after if runs, with the name as PlainMMDDYYYY. Using sp_send_dbmail, how can one have the report sent to the operator when the new file each day? I have at the end of the plan an Excute T-SQL Statement task which exec sp_db_mail but using the @file_attachment won't get the newly name file each day