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 |
|
JDV
Starting Member
1 Post |
 Posted - 2010-01-31 : 13:43:07
|
| 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. How do I force database mail in SQL Server 2005 to send e-mail in plain text instead of encoding it in base64? |
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-02-05 : 01:39:34
|
| To send e-mail in plain text and also attachements:EXEC sp_send_dbmail @recipients = 'SQLDBA@dba.com', @subject = 'Testing MIME / PLAIN TEXT', @body = 'Hello SQL DBA: Text format', @body_format = 'TEXT', @file_attachments = 'c:\filename.txt' To send e-mail in MIME and also attachements:EXEC sp_send_dbmail @recipients = 'SQLDBA@dba.com', @subject = 'Testing MIME / PLAIN TEXT', @body = 'Hello SQL DBA: MIME format', @body_format = 'HTML', @file_attachments = 'c:\Screen Test.txt' |
 |
|
|
|
|
|
database mail in SQL to change e-mail encoding