EXEC msdb.dbo.sp_send_dbmail 
@profile_name = 'Administrator', 
@recipients = 'joe@company.com; peter@company.com; adam@company.com', 
@query = 'SELECT Name, Item FROM db.dbo.importedrecords' , 
@subject = 'Imported Records Count', 
@attach_query_result_as_file = 1 ;

DECLARE @EmailList varchar(3000)
SELECT @EmailList = COALESCE(@EmailList,'') + email + ';'
FROM importedrecords

EXEC msdb.dbo.sp_send_dbmail 
@profile_name = 'Administrator', 
@recipients = @EmailList, 
@query = 'SELECT Name, Item FROM db.dbo.importedrecords' , 
@subject = 'Imported Records Count', 
@attach_query_result_as_file = 1 ;

Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 478
Query execution failed: ?Msg 208, Level 16, State 1, Server MYSERVER, Line 1
Invalid object name 'importedrecords'

quote:

---

Originally posted by s_anr

hi Visakh,

I get the following error :

Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 478
Query execution failed: ?Msg 208, Level 16, State 1, Server MYSERVER, Line 1
Invalid object name 'importedrecords'

Note : select * from importedrecords is a valid query with 'email' as a valid field and it does give me the results when run independently.

---