Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

xp_sendmail - empty subject Expand / Collapse
Author
Message
Posted Wednesday, February 15, 2006 2:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 14, 2006 4:13 AM
Points: 11, Visits: 1

Hi Balmukund,

In Outlook 2003, I can see an option to change to use Word as the default editor, but as I don't have Word installed on the machine, this option is greyed out.
I don't see how I can change to use notepad as the default mail editor - could you elucidate please?

Many thanks
Post #258520
Posted Wednesday, February 15, 2006 11:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
DECLARE @To VARCHAR(500)
DECLARE @MessageString VARCHAR(500)
DECLARE @User1Email VARCHAR(500)
DECLARE @Topic VARCHAR(200)

SET @MessageString ='This script will send an email'

SET @User1Email = 'someone@mars.com' -- use semi colon to seperate many email addresses

SET @To = @User1Email

SET @Topic = 'Test SQL Send Email'

EXEC Master..xp_sendmail
@recipients = @To
,@message = @MessageString
,@subject = @Topic



Everything you can imagine is real.

Post #258781
Posted Wednesday, February 15, 2006 3:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 12, 2012 3:19 PM
Points: 24, Visits: 72
Can you try turning off caching on your outlook client?
Post #258863
Posted Thursday, February 16, 2006 2:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 14, 2006 4:13 AM
Points: 11, Visits: 1
Hi Bledu,

Thanks for your suggestion.

I don't think you understood my problem fully.

I can send an email, and for one user it works perfectly, another user, on the same machine, it sends an email with an empty subject line.

I did a cut & paste of your code, just changing the email address, and it behaved as my current script - the subject line comes through as blank.

Rgds
Post #258942
Posted Thursday, February 16, 2006 2:52 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
I have win xp with latest update, outlook 2003 and sql 2000 with service pack 4.
i tried to setup with similar stuff like yours and it works fine.

this removes the problem of you having to go to an earlier version of outlook.

i can not duplicate your problem though. your settings work fine on my machine.
why don't you try installing service pack 4 for sql server 2000, it might solve your problem.



Everything you can imagine is real.

Post #258952
Posted Thursday, February 16, 2006 3:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 14, 2006 4:13 AM
Points: 11, Visits: 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
Post #258961
Posted Thursday, February 16, 2006 12:40 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 12, 2012 3:19 PM
Points: 24, Visits: 72
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.
Post #259164
Posted Thursday, February 16, 2006 12:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 12, 2012 3:19 PM
Points: 24, Visits: 72
Also, after caching has been turned off, you should restart SQL Mail by executing xp_stopmail then xp_startmail.
Post #259176
Posted Friday, February 17, 2006 2:08 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
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.

Post #259324
Posted Friday, February 17, 2006 2:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 14, 2006 4:13 AM
Points: 11, Visits: 1

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
Post #259329
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse