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.
| Author |
Topic |
|
Johnho008
Starting Member
24 Posts |
 Posted - 2008-10-01 : 07:38:14
|
| Hi Everyone,Thank you in advance.I am using the function msdb.dbo.sp_send_dbmail and I want to know if there anyway of attaching more then 1 file to the email. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-01 : 07:47:27
|
| yup. you can give a semicolon delimited list of files to be attachedhttp://msdn.microsoft.com/en-us/library/ms190307.aspx |
 |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2008-10-01 : 09:25:44
|
| Hi John,Can you send me code to send a mail through SQL Server. or Please tell me the Steps to do it.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-01 : 09:49:49
|
There are examples in Books Online.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-01 : 09:50:37
|
quote:
Originally posted by ganeshkumar08
Solutions are easy. Understanding the problem, now, that's the hard part
Of course they are easy when you don't want to learn for yourself.Do you take the time to understand the suggestions we give?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Johnho008
Starting Member
24 Posts |
Posted - 2008-10-01 : 10:48:04
|
| Thanks visakh16, feel abit silly. I did use the BOL but think I must be overwork and read without reading! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-01 : 10:49:42
|
quote:
Originally posted by Johnho008
Thanks visakh16, feel abit silly. I did use the BOL but think I must be overwork and read without reading!
No worries.Always use books online as your first line of reference.  |
|
|
|
|
|
|
sp_send_dbmail; how to attaching more then 1 file