Send a PDF file as an E-mail attachment from Network folder using SQL Server 2005 e-mail - issue

Question

Hi friends,

I have some PDF file whihc are stored on Network shared Drive Folder.

I wuould like to send this PDF file as An e-mail attachment to some colleague, on schedule basis.

Is there any way to send PDF file as an e-mail attachemnt using SQL Server 2005 ?

 

Answer 1

Pleas read BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f1d7a795-a3fd-4043-ac4b-c781e76dab47.htm

[ @file_attachments = ] 'file_attachments'

Is a semicolon-delimited list of file names to attach to the e-mail message. Files in the list must be specified as absolute paths. The attachments list is of type nvarchar(max).

---

Best Regards, Uri Dimant http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Have you heard about DatabaseMail in SQL Server 2005?

SQL Server 2005 Database Mail provides several options for sending e-mail messages. These options include sending attachments, setting sensitivity and importance, including query results, and formatting the e-mail message in an HTML format.

Go to below link which will show you how to configure Database Mail in SQL Server 2005 and how to send email from SQL Server with attchment file.

SQL Server 2005 Database Mail Setup and Configuration Scripts and Send Email with Attachment from sql server

Thanks,

---

Kapil Khalas

Answer 3

One another option is designing a small SSIS package with send mail task. Refer the below links for details

http://www.mssqltips.com/tip.asp?tip=1731

http://msdn.microsoft.com/en-us/library/ms142165.aspx