--************* Create the CDO.Message Object ************************
   EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT

--***************Configuring the Message Object ******************
-- This is to configure a remote SMTP server.
-- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_schema_configuration_sendusing.asp
   EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'
-- This is to configure the Server Name or IP address. 
-- Replace MailServerName by the name or IP of your SMTP Server.
   EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', '10.0.0.2'

-- Save the configurations to the message object.
   EXEC @hr = sp_OAMethod @iMsg, 'Configuration.Fields.Update', null

-- Set the e-mail parameters.
   EXEC @hr = sp_OASetProperty @iMsg, 'To', 'support@mydomani.co.nz'
   EXEC @hr = sp_OASetProperty @iMsg, 'From', @EmailFrom
   EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @subject
   EXEC @hr = sp_OASetProperty @iMsg, 'Cc', @cc
   EXEC @hr = sp_OASetProperty @iMsg, 'Bcc', @bcc
-- If you are using HTML e-mail, use 'HTMLBody' instead of 'TextBody'.
   if @MailFormat = 0 
	BEGIN
		EXEC @hr = sp_OASetProperty @iMsg, 'TextBody', @message
	END
   ELSE
	BEGIN
		EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @message
	END

   if @attachment IS NOT NULL
  	begin
		EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', NULL, @attachment
	end
   EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL
   update tbl_mailtable set sent = 'y', datesent = getdate() where mailid = @mailid

-- Do some error handling after each step if you need to.
-- Clean up the objects created.
   EXEC @hr = sp_OADestroy @iMsg

quote:

---

Originally posted by Peso

Why aren't you using database mail?

---

N 56°04'39.26"
E 12°55'05.63"

---

quote:

---

Originally posted by Kristen

I would move the

update tbl_mailtable set sent = 'y', datesent = getdate() where mailid = @mailid

to the start (and I would use tri-state, so set "sent" to "Sending", and then reupdate at the end to change it to "Sent")

That way another task run, which overlapped, could not resend a "Sending" email

I don't know if that is what is happening, or if it is getting duplicated in the SMTP queue or somesuch, but I'd adopt that sort of failsafe anyway.

---