Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Is it possible to attach multiple documents in ema

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2008-08-19 : 11:30:45
I am using the following to send an email with an attachement.

Is it possiblt to attach multiple documents in one single email.

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'MyeMail',
@recipients=@recipient,
@body = @mailbody,
@subject=@Subject,
@file_attachments=@filepath

Thank you very much for the info.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-19 : 11:42:26
you can. refer this:-
http://www.mssqltips.com/tip.asp?tip=1438
Go to Top of Page
   

- Advertisement -