xp_sendmail - empty subject

Question

xp_sendmail - empty subject

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Rupert Woodman SSC Enthusiast Points: 165 More actions · Answer 1

Thanks for doing all that Bledu - much appreciated.

I'm coming to the conclusion that I'll have to apply a service pack and see what happens. I didn't really want to as it'll then mean I'll have to go through the acceptance process with the users before I can update the live server, which will take time etc, but I guess I have no real choice.

Rgds

Daniel Cho SSC Enthusiast Points: 100 More actions · Answer 2

I experienced the same problem on a new development machine of ours. The solution was to turn OFF caching on the outlook client. Also, it wasn't just the subject which was affected. Sending a query attachment was not working as well. Turning off the caching fixed both of our issues.

Hope that helps.

Daniel Cho SSC Enthusiast Points: 100 More actions · Answer 3

Also, after caching has been turned off, you should restart SQL Mail by executing xp_stopmail then xp_startmail.

bledu SSChampion Points: 12335 More actions · Answer 4

I have cached mode turned on, and I could not duplicate the error. Have you installed the service packs as yet?

Everything you can imagine is real.

Rupert Woodman SSC Enthusiast Points: 165 More actions · Answer 5

Nope, not yet - been kind of busy. Will try the caching option first, but if that doesn't work, I'll try the SP.

thanks

Rupert Woodman SSC Enthusiast Points: 165 More actions · Answer 6

Hi Daniel,

Thanks for the suggestion.

I've had a look at my outlook client and I can't find mention of caching - could you tell me where it is?

many thanks

bledu SSChampion Points: 12335 More actions · Answer 7

Tools ->Email Accounts ->View or Change Existing -> [Select your Account] ->Click Change -> and wala you should see it. its a checkbox.

this is on outlook 2003

Everything you can imagine is real.

Rupert Woodman SSC Enthusiast Points: 165 More actions · Answer 8

Ahh, got it - don't know why I didn't see that - sorry about that.

AND IT WORKS!

So thank yo uvery much for all of you who read this and made suggestions, esp to Bledu & Danial.

Rgds

bledu SSChampion Points: 12335 More actions · Answer 9

we all wish m$ products could work seamlessly

Everything you can imagine is real.

Jane Matheson-154829 SSCertifiable Points: 5522 More actions · Answer 10

I have recently had this issue when migrating servers adn the caching was the fix. Thanks everyone.

michatha Newbie Points: 9 More actions · Answer 11

I was facing the exact same issue and this fix WORKED! Thanks a lot.

Kendo-771548 Old Hand Points: 348 More actions · Answer 12

I have the same problem, Were using Outlook 2003 and SQL server 2000.

The mail is sending OK but the subject line remains blank? If the variable is specified or left blank the result is the same.

Did you ever get a solution to this problem.

Thanks for any help

Kenny

bhsim Old Hand Points: 325 More actions · Answer 13

So,hv anyone find the root of the problem for this and get the solution? i wish to know where outlook caching also..appreciate if someone can share..