Problems Using Xp_smtp_sendmail
Jul 20, 2005
I am trying to use this code to send an email
declare @rc int,
@invjournal int
set @invjournal = 2222
exec @rc = master.dbo.xp_smtp_sendmail
@FROM= N'matt@hasta.se',
@FROM_NAME= N'Matt Douhan',
@TO= N'inventering@hasta.se',
@replyto = N'Reply to NONE',
@CC= N'',
@BCC= N'',
@priority= N'NORMAL',
@subject= N' TEST TEST TEST Inventeringsjournal '+@invjournal+'
klar för integration till redovisningen TEST TEST TEST',
@message= N'Vänligen uppdatera denna inventeringsjournal till
redovisningen',
@messagefile= N'',
@type= N'text/plain',
@attachment= N'',
@attachments= N'',
@codepage= 0,
@server = N'mandarin.internal.hasta.se'
select RC = @rc
go
but it fails with the following with the following error msg
Server: Msg 170, Level 15, State 1, Line 14
Line 14: Incorrect syntax near '+'.
the problem seems to be when I want to use the @invjournal variable in
the subject, if I take it away and only send text it works just fine.
Any ideas would be much appreciated
rgds
Matt
View 1 Replies
Aug 2, 2006
Any idea when this extended stored procedure gets installed in SQL 2000 as I get just the error message below when I try to run it:
Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.
View 3 Replies
View Related
Aug 3, 2006
does anyone knows if there is such xp_smtp_sendmail with 64-bit version?
View 1 Replies
View Related
Sep 8, 2006
Hi!
I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:Program FilesMicrosoft SQL ServerMSSQLBinnDLL. Then I registered it by exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com',
@subject = N'My first HTML mail',
@message = N'<HTML><H1>This is some HTML content</H1></HTML>',
@type = N'text/html'
select RC = @rc
go
An error generating stating
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
(1 row(s) affected)
Please anyone help me to sort out this problem.
View 1 Replies
View Related
Apr 14, 2008
(Apologies if this is in the wrong section.)
I'm been using xp_smtp_sendmail in SQL2000 for firing off task assignment emails from a ASP.NET website which uses Integrated security to connect.
Everything has been fine in the past but now these EMail have stopped being sent. (Can't give an accurate date as to when)
The same thing is now happening on my local machine as well, everything appears to run fine - xp_smtp_sendmail does not send back an error code it's just that the EMail is not sent. The unusual thing is that if I run the exact same code (lifted from Profiler) in SQL Analyser then the mail is fired off no problem.
Things I have tried...
Set Chaining in Calling DB.
Set Website conn string from integrated to use sa login.
Opened up permissions for ASPNET user.
Created sproc in master to do call to xp.
Reloaded xp_smtp_sendmail and set permissions.
I'm now at a dead end and would be grateful for any helpideas.
View 2 Replies
View Related
Sep 23, 2005
Just trying out xp_smtp_sendmail for the first time.I get the error:Error: connecting to server smarthostOK, so I don't have the server parameter for SMTP server set upcorrectly.I don't even know what an SMTP Server is! Is this an e-mail providerthat provides SMTP functionality, or an application I need to install?
View 4 Replies
View Related
Sep 27, 2007
Hello All.
I sent a HTML file as text message using xp_smtp_sendmail from my SQL server but the test email that I received doesn't look like the HTML file I have originally. Below are my codes:-
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'xxx@yyy.com',
@FROM_NAME = N'Mr XXX',
@TO = N'www@yyy.com',
@CC = N'kkk@yyy.com',
@priority = N'HIGH',
@subject = N'Weekly Sales To Thirds',
@type = N'text/html',
@messagefile = N'D:WSTWeeklySalesToThirds.htm',
@server = N'999.99.999.99',
@attachments = N'D:WST4weeksWST.xls'
select RC = @rc
The problem I have is the email doesn't display the HTML correctly. Spaces appeared and some of wording have wrapped.
I have attached partial screen shots of my original HTML file and email.
Please help if you have similar problem and solution. Thank you.
Best regards
Teck Boon
View 2 Replies
View Related
Jul 20, 2005
Hi all. Iv'e tryed out xp_smtp_sendmail, and I like what I can see sofar. The thing I wonder about is if the xp supports sending both htmlAND plain text in the same mail. I'm on a sql2000 sp3 and I have noproblem with the xp when i either send plain text or html, but asstated above I need to send with both formats in one mail......For use when one does not know if the receiver uses a mail-client thatsupports html or not. If not does anyone know of a good way to attackthis problem?thanks in advanceKarl B
View 1 Replies
View Related
Oct 23, 2007
OK so now I'm setting up a trigger to email info to different people based on values INSERTed into one of my tables. I'm using an IF statement to determine who I'm giong to send the mail to, but I don't really understand how to include the data (parameters) in my message. Thanks for any help. Here's what I have so far.
Code Block
ALTER TRIGGER [smallin].[trig_test]
ON [smallin].[DATALIST]
AFTER INSERT
AS
declare @rc int,
@post bit,
@pre bit
SELECT @post = [POST], @pre = [PRE] FROM inserted
IF @post = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is post data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'
ELSE IF @pre = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is pre data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'
View 5 Replies
View Related