I'm having a "bang head here" day trying to get sp_send_dbmail working in SQL 2005 with file attachments. Long story short, I'm working on an internal "mass mail" system and while my test emails with attachments work (by calling just the sp), building the exact same call inside a stored procedure doesn't. I get an "Attachment file is invalid" error.
I'm almost to the point where I want to ditch the SQL mail solution and write another Windows service to process this... anyone have any suggestions on how to get this cluster to work? Thanks... I need an aspirin now! Until Later! C. Hatton Humphrey No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:342289 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
