Error in sending mails !

I am trying to send email thro DTS using Activex Script.

Here is the code :

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()
const SMTP_SERVER = "MPBAKOREX01.corp.mphasis.com"

set iMsg = CreateObject("CDO.Message")
set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields

With Flds
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPickup
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = SMTP_SERVER
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 90
.Update
End With

With iMsg
Set .Configuration = iConf
.To = "ausrg@.yahoo.com"
.From = "shanmuga.r@.mphasis.com"
.Subject = "TEST"
.HTMLBody = "jfldsajfldk;sajf ;lksadjf;lkasdjlfkjasdlkfjlasdkj flkdsajflsadjf ljasdlf a"
.Send
End With

Main = DTSTaskExecResult_Success
End Function

When i am executing this , i am getting the following error :

Error Source : Microsoft Data Transformation Services (DTS) Package

Error Description : Error Code: 0

Error Source= CDO.Message.1

Error Description: The "SendUsing" configuration value is invalid.

Error on Line 27

How to solve it ?

Hi,

You question has nothing to do with SSIS (or DTS) and more about CDO programming in VBScript. This is SSIS group, I doubt you'll find many CDO experts here.

The best advice you'll get in this forum is to move to SSIS - there is a nice SMTP Mail Task that will likely do what you need.

Regards,
Michael.

|||

ohh Thanks michael

|||Try searching, this will have been answered before on the DTS newsgroup -http://groups.google.com/advanced_search?q=+group%3Amicrosoft.public.sqlserver.dts|||

Hi DarrenSQLIS,

Thanks. But i dont have access to the site which u mentioned. Can you plz details the article in that site ?

:)

Error in Sending Emails

Hi,

i am getting the following error when i try to schedule a report and Delivery it through an email

"The e-mail address of one or more recipients is not valid"

although, i have mentioned my pop3 mail account, i have included the smtp server details in the .config files as per the msdn help.

pl help me solve this

T & R,

Bharath V V

Which article are you refering to ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||try to give only one email id. and then if it works, try to give multiple ids. check ur SMTP server you have given is valid one|||

Hi,

i have reffered to the following article:

http://msdn2.microsoft.com/en-us/library/ms159155.aspx

Regards,

Bharath V V

Error in HTML email.

Hello,
My company is using Reporting Services with SP2 installed. We are sending
HTML emails to our customers. When the customer receives the email, there is
a fault in the html format.
Example:
class="a355"> </TD><TD class="a356"> </TD><TD class="a357"> </TD><TD
class="a358"> </TD></TR><TR style="HEIGHT:6.35mm"><TD class="a372"><DIV
class="r11">6.12.2005 08:06</DIV></TD><TD class="a
373"><DIV class="r11">6.12.2005 20:36</DIV></TD><TD class="a374"><DIV
class="r11">174,21</DIV></TD><TD class="a375"><DIV
class="r11">221</DIV></TD><TD
At the fourth line <TD class="a there is CR in the source, the view of the
html email is then damaged, the customer, instead of seeing nice color and
fonts, the customer only sees the plain text.
This errors comes all over the html code !
We are sending the emails (SMTP) through Windows 2003. I have not seen
this error on SMTP Windows 2000. But we need to use Windows 2003 so I cant
use 2000.
best regards,
G. SigurdssonYou may want to look at the following KB. It may apply to your issue.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7ffe50d4-aff8-4c1e-9609-6798190c2d58&displaylang=en
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gudmundur Sigurdsson" <GudmundurSigurdsson@.discussions.microsoft.com> wrote
in message news:C4A4A063-B10F-4E9E-B976-AB930636593D@.microsoft.com...
> Hello,
> My company is using Reporting Services with SP2 installed. We are sending
> HTML emails to our customers. When the customer receives the email, there
> is
> a fault in the html format.
> Example:
> class="a355"> </TD><TD class="a356"> </TD><TD class="a357"> </TD><TD
> class="a358"> </TD></TR><TR style="HEIGHT:6.35mm"><TD class="a372"><DIV
> class="r11">6.12.2005 08:06</DIV></TD><TD class="a
> 373"><DIV class="r11">6.12.2005 20:36</DIV></TD><TD class="a374"><DIV
> class="r11">174,21</DIV></TD><TD class="a375"><DIV
> class="r11">221</DIV></TD><TD
> At the fourth line <TD class="a there is CR in the source, the view of
> the
> html email is then damaged, the customer, instead of seeing nice color and
> fonts, the customer only sees the plain text.
> This errors comes all over the html code !
> We are sending the emails (SMTP) through Windows 2003. I have not seen
> this error on SMTP Windows 2000. But we need to use Windows 2003 so I
> cant
> use 2000.
> best regards,
> G. Sigurdsson