it's very urgent regarding XP_SEND MAIL

Hi,
I have a problem in sending mail from sql server 2000 which is using
windows 2000 professional and outlook express
Iam pasting my code below
/
************************************************** ************************************************** ********
Create procedure Pub_SendingMail
as
declare
@.EmailAddTO varchar(30),
@.EmailSubject varchar(130),
@.EmailText varchar(255),
@.return int,
@.Counting int
@.
begin
/* SET value */
set @.return = 0
set @.Counting = 0
set @.EmailSubject = 'TEST EMAIL'
set @.EmailText = 'This is a test email'
set @.EmailAddTO = 'nagesh@.emids.com'
/* LOOP. If e-mail is sent, break loop; ELSE WAIT 10 seconds, and
then RETRY. */
WHILE 1=1
begin
set @.Counting = @.Counting + 1
exec @.return = master.dbo.xp_sendmail
@.recipients = @.EmailAddTO,
@.message = @.EmailText ,
@.subject = @.EmailSubject
@.attachments = 'c:\attachment.txt'
/* CHECK value, break if SUCCESS */
if @.return = 0
begin
print 'EMAIL SENT'
break
end
else
begin
/* Try 1 times */
if @.Counting = 1
break
print 'EMAIL FAILED, WAIT 10 SECONDS, TRY AGAIN'
/*000 hours, 00 minutes, and 10 seconds */
waitfor delay '000:00:03'
end
end
end
************************************************** ************************************************** *************/
and when iam executing
EXEC Pub_SendingMail
it is giving the following error
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: Either there is no default mail client or the current
mail client cannot fulfill the messaging request. Please run Microsoft
Outlook and set it as the default mail client.
but here i need to send mail not only to out look express but also
general mail servers
I would deeply appriciate if any body can help me about this issue
and send any modifications in the above code.And also how to configure
the Microsoft Outlook Express as the default mail client.
it is very very very very very urgent
Regards
prasad
You'll need to set up a MAPI mail profile for this to work. Alternatively
you could use the XPSMTP.DLL which is free
(http://www.sqldev.net/xp/xpsmtp.htm).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

it's very urgent regarding XP_SEND MAIL

Hi,
I have a problem in sending mail from sql server 2000 which is using
windows 2000 professional and outlook express
Iam pasting my code below
/
************************************************************************************************************
Create procedure Pub_SendingMail
as
declare
@.EmailAddTO varchar(30),
@.EmailSubject varchar(130),
@.EmailText varchar(255),
@.return int,
@.Counting int
@.
begin
/* SET value */
set @.return = 0
set @.Counting = 0
set @.EmailSubject = 'TEST EMAIL'
set @.EmailText = 'This is a test email'
set @.EmailAddTO = 'nagesh@.emids.com'
/* LOOP. If e-mail is sent, break loop; ELSE WAIT 10 seconds, and
then RETRY. */
WHILE 1=1
begin
set @.Counting = @.Counting + 1
exec @.return = master.dbo.xp_sendmail
@.recipients = @.EmailAddTO,
@.message = @.EmailText ,
@.subject = @.EmailSubject
@.attachments = 'c:\attachment.txt'
/* CHECK value, break if SUCCESS */
if @.return = 0
begin
print 'EMAIL SENT'
break
end
else
begin
/* Try 1 times */
if @.Counting = 1
break
print 'EMAIL FAILED, WAIT 10 SECONDS, TRY AGAIN'
/*000 hours, 00 minutes, and 10 seconds */
waitfor delay '000:00:03'
end
end
end
*****************************************************************************************************************/
and when iam executing
EXEC Pub_SendingMail
it is giving the following error
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: Either there is no default mail client or the current
mail client cannot fulfill the messaging request. Please run Microsoft
Outlook and set it as the default mail client.
but here i need to send mail not only to out look express but also
general mail servers
I would deeply appriciate if any body can help me about this issue
and send any modifications in the above code.And also how to configure
the Microsoft Outlook Express as the default mail client.
it is very very very very very urgent
Regards
prasadXp_sendmail cannot use Outlook Express. Do yourself a big favor and use xp_smtp_sendmail from
www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<shyam.yarlagadda@.gmail.com> wrote in message
news:1170414875.690570.8220@.v45g2000cwv.googlegroups.com...
> Hi,
> I have a problem in sending mail from sql server 2000 which is using
> windows 2000 professional and outlook express
> Iam pasting my code below
> /
> ************************************************************************************************************
> Create procedure Pub_SendingMail
> as
> declare
> @.EmailAddTO varchar(30),
> @.EmailSubject varchar(130),
> @.EmailText varchar(255),
> @.return int,
> @.Counting int
> @.
> begin
> /* SET value */
> set @.return = 0
> set @.Counting = 0
> set @.EmailSubject = 'TEST EMAIL'
> set @.EmailText = 'This is a test email'
> set @.EmailAddTO = 'nagesh@.emids.com'
> /* LOOP. If e-mail is sent, break loop; ELSE WAIT 10 seconds, and
> then RETRY. */
> WHILE 1=1
> begin
> set @.Counting = @.Counting + 1
> exec @.return = master.dbo.xp_sendmail
> @.recipients = @.EmailAddTO,
> @.message = @.EmailText ,
> @.subject = @.EmailSubject
> @.attachments = 'c:\attachment.txt'
> /* CHECK value, break if SUCCESS */
> if @.return = 0
> begin
> print 'EMAIL SENT'
> break
> end
> else
> begin
> /* Try 1 times */
> if @.Counting = 1
> break
> print 'EMAIL FAILED, WAIT 10 SECONDS, TRY AGAIN'
> /*000 hours, 00 minutes, and 10 seconds */
> waitfor delay '000:00:03'
> end
> end
> end
> *****************************************************************************************************************/
> and when iam executing
> EXEC Pub_SendingMail
> it is giving the following error
> Server: Msg 18030, Level 16, State 1, Line 0
> xp_sendmail: Either there is no default mail client or the current
> mail client cannot fulfill the messaging request. Please run Microsoft
> Outlook and set it as the default mail client.
> but here i need to send mail not only to out look express but also
> general mail servers
> I would deeply appriciate if any body can help me about this issue
> and send any modifications in the above code.And also how to configure
> the Microsoft Outlook Express as the default mail client.
> it is very very very very very urgent
> Regards
> prasad
>|||You'll need to set up a MAPI mail profile for this to work. Alternatively
you could use the XPSMTP.DLL which is free
(http://www.sqldev.net/xp/xpsmtp.htm).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

It's Urgent Please Help....

Hi, I've created one mailing label report with
2 Across Than 3 down.But it displays the data
like
1 4
2 5
3 6
Is there a way to change the default orientation from Down then Across
to Across and then down like this ?
1 2
3 4
5 6
Thanks & Regards
MalkeshOne idea ist to add a counter to your view and select only the datarows with
1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
... data rows from view.
Markus Pöhler
netpoint-edv gmbh
Germany
"Malkesh" wrote:
> Hi, I've created one mailing label report with
> 2 Across Than 3 down.But it displays the data
> like
> 1 4
> 2 5
> 3 6
> Is there a way to change the default orientation from Down then Across
> to Across and then down like this ?
> 1 2
> 3 4
> 5 6
>
>
> Thanks & Regards
> Malkesh|||Thanks,
But I'm Sorry, i need to explain the actual problem rather
giving you the layout.
Actually we have Event Badge Report with Badge Info is on Top
Left side and Receipt Info is On Top right side fro the event, and after that
as many tickets as individual is registered for shouls be print from next row.
So i need to layout the report Across tha Down.
How can i achieve this task ?
--
Thanks & Regards
Malkesh
"MarkusPoehler" wrote:
> One idea ist to add a counter to your view and select only the datarows with
> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
> ... data rows from view.
>
> Markus Pöhler
> netpoint-edv gmbh
> Germany
>
> "Malkesh" wrote:
> > Hi, I've created one mailing label report with
> > 2 Across Than 3 down.But it displays the data
> > like
> > 1 4
> > 2 5
> > 3 6
> >
> > Is there a way to change the default orientation from Down then Across
> > to Across and then down like this ?
> >
> > 1 2
> > 3 4
> > 5 6
> >
> >
> >
> >
> > Thanks & Regards
> > Malkesh|||If you are doing this with a table. there is a property called writing-mode
lr-tb or tb-lr...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Malkesh" <Malkesh@.discussions.microsoft.com> wrote in message
news:8CFA0F60-3BF8-47D2-894E-58B370C6D9C4@.microsoft.com...
> Thanks,
> But I'm Sorry, i need to explain the actual problem rather
> giving you the layout.
> Actually we have Event Badge Report with Badge Info is on Top
> Left side and Receipt Info is On Top right side fro the event, and after
> that
> as many tickets as individual is registered for shouls be print from next
> row.
> So i need to layout the report Across tha Down.
> How can i achieve this task ?
> --
> Thanks & Regards
> Malkesh
>
> "MarkusPoehler" wrote:
>> One idea ist to add a counter to your view and select only the datarows
>> with
>> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
>> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6
>> ,8
>> ... data rows from view.
>>
>> Markus Pöhler
>> netpoint-edv gmbh
>> Germany
>>
>> "Malkesh" wrote:
>> > Hi, I've created one mailing label report with
>> > 2 Across Than 3 down.But it displays the data
>> > like
>> > 1 4
>> > 2 5
>> > 3 6
>> >
>> > Is there a way to change the default orientation from Down then Across
>> > to Across and then down like this ?
>> >
>> > 1 2
>> > 3 4
>> > 5 6
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> > Malkesh