man this is really interesting, but the rabbit hole is getting deeper and deeper.
if you send an email via sp_send_mail with SECURE in the subject, does your Exchange Server encrypt the email for you?
i found this overview article on how Outlook 2007 is using #DES encryption, with public and private keys:
stating the obvious, if i knew the public key, i could then use a 3DES encryption method on SQL server to create an encrypted string to include int he body; at least from there we could test to see if it can be opened or not when it finally gets received.
I'll keep poking around till i find a code snippet or two, but until then google and i are running around together.
this article on SSC has a sql 2000 toolkit[/url] to add extended stored procedures to do encryption, and 2005 and up have some built in encryption tools, but it's the testing of compatibility that is important.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!