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 |
|
Kaaaahn
Starting Member
2 Posts |
 Posted - 2008-08-21 : 00:55:34
|
| I'm creating a SQL Server 2005 mailing solution that will read an HTML string and MUST EMBED into the outgoing email any images found. If this were an ASP.net app then this would not be a problem. The challenge is that this is NOT an ASP.net app and ONLY SQL Server 2005 can be used. Simply setting the src of the image tag doesn't work because many email clients will initially block those images. Embedding the images directly into the outgoing email solves this issue.How can images be embedded into the body of an email generated using Database Mail? |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-08-21 : 02:33:52
|
| you can store the image in binary values in a field with the help of datatype image.for further details search in google. |
 |
|
|
Kaaaahn
Starting Member
2 Posts |
Posted - 2008-08-21 : 02:46:23
|
| Thanks VGuys.I don't see how the location of the image matters. Even an image is stored in an image field it still needs to be embedded into the outgoing email. |
|
|
|
|
|
|
Embed images into an email using Database Mail