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 |
|
DCW87
Starting Member
6 Posts |
 Posted - 2012-06-26 : 11:52:40
|
| Hi,I have a script which runs and sends emails based on a loop which cycles through a contacts table and picks out the unique addresses. The problem is that this script utilises html/css formatting which works pefectly when i hard code my email into @copy_recipients but it doesnt display this formatting when sending to the @recipients variable @ContactEmail....anyone seen this before, or have any suggestions? Really need help on this one :S thanks dave |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-06-26 : 12:14:10
|
| I'm probably reading this wrong, but are you saying the body of the email looses its formatting is you pass a variable in to the @recipients parameter? |
 |
|
|
DCW87
Starting Member
6 Posts |
Posted - 2012-06-27 : 06:26:03
|
| Lamprey, thats right. The formatting is just basic CSD/HTML which is nested into the body of the email, but for some reason when i pass in a variable for the recipient it drops the formatting, when i enter an email address instead, the formatting remains intact. Tkizer,Unfortunately this is the only real option within my organisation, or at least the only option i have for the time being.... can you recommend any specific apps to achieve this? I forgot to mention that the auto email job is also sending attachements alongside the message and writing the results back into an email log tableThanks |
|
|
|
|
|
|
HTML/CSS Variable recipien Issue in SP_Mail