I'm trying to use Database Mail to send e-mail to a foreign address. It delivers the message but the content is encoded in base64 so it can't be read clearly by the destination.
It is a part of the message headers:
To: email@example.com Date: 31 Jan 2010 12:39:53 -0500 Subject: Database Mail Test Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Return-Path:
How do I force database mail in SQL Server 2005 to send e-mail in plain text instead of encoding it in base64?
Sorry friends, someone who has this very same problem told me that base64 encoding is hardcoded in the procedure, so it can't be modified...
answered Feb 05, 2010 at 12:44 AM
you could try decoding it using a SP and then using dbmail to return the result of that to the email as the body or attachment
answered Jan 31, 2010 at 04:36 PM