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 2008 Forums  Transact-SQL (2008)  sp_send_dbmail attachment problem

Author  Topic  Tang123 Starting Member 1 Post Posted - 2010-05-03 : 11:38:12 hi everyone, i am having some problems with using sp_send_dbmail. my application executes sp_send_dbmail with pdf attachments for auto emailing documents for customers or for email accounts in the external network. however, some customers receives the email and can open the attachments without problems. but a few percentage cannot open the attachment even if they are using MS Outlook and Microsoft Exchange. this is the sample message when trying to open the attachments: Cannot create file xxx.pdf ...Right click the folder you want to create the file in and then click Properties in the shortcut menu to check your permissions for the folder. i don't know why there are spaces appended after pdf. the document being sent contains a unique filename so it is not possible that they have received the same file for more than 100 times. Text format is being used and not RTF. the pdf attachment in their emails does not have the pdf icon even if they have Adobe Reader installed. i will greatly appreciate any help on this matter. i've tried researching everywhere but cannot find the answer for this one. sincerely, tang