Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql
Showing posts with label valid. Show all posts
Showing posts with label valid. Show all posts
Thursday, March 22, 2012
Email Validation in reporting Sevices...
Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:
Monday, March 19, 2012
Email ID Validation in SQL Query
Hi,
Can someone help me with a query to validate if a value stored in the
emailaddress field in a table is a valid email id or no. Please mail me
ASAP. Thanks in advance.
Regards
DineshDinesh
I'm not sure iunderstood your question.
Since you have not provided a table structure along with sample data , I
guess you can do something like that
IF EXISTS (SELECT * FROM Table WHERE email_id=@.par)
--do soemthing
ELSE
--do somethimg else
"Dinesh" <Dinesh@.discussions.microsoft.com> wrote in message
news:80CE816E-A91C-4ECE-93E4-19006167B567@.microsoft.com...
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh|||Dinesh skrev:
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh
Depends on what you actually want to validate...
Is it only that the value looks like 'somename@.someaddress', or is it
to check if there really IS such an (active?) email account, or is it
to check against a table with valid email addresses? Or something else?
/impslayer, aka Birger Johansson|||Please explain in detail, your question? Mean provide sample data situation
Thanks,
Siva
"impslayer" wrote:
> Dinesh skrev:
>
> Depends on what you actually want to validate...
> Is it only that the value looks like 'somename@.someaddress', or is it
> to check if there really IS such an (active?) email account, or is it
> to check against a table with valid email addresses? Or something else?
> /impslayer, aka Birger Johansson
>
Can someone help me with a query to validate if a value stored in the
emailaddress field in a table is a valid email id or no. Please mail me
ASAP. Thanks in advance.
Regards
DineshDinesh
I'm not sure iunderstood your question.
Since you have not provided a table structure along with sample data , I
guess you can do something like that
IF EXISTS (SELECT * FROM Table WHERE email_id=@.par)
--do soemthing
ELSE
--do somethimg else
"Dinesh" <Dinesh@.discussions.microsoft.com> wrote in message
news:80CE816E-A91C-4ECE-93E4-19006167B567@.microsoft.com...
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh|||Dinesh skrev:
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh
Depends on what you actually want to validate...
Is it only that the value looks like 'somename@.someaddress', or is it
to check if there really IS such an (active?) email account, or is it
to check against a table with valid email addresses? Or something else?
/impslayer, aka Birger Johansson|||Please explain in detail, your question? Mean provide sample data situation
Thanks,
Siva
"impslayer" wrote:
> Dinesh skrev:
>
> Depends on what you actually want to validate...
> Is it only that the value looks like 'somename@.someaddress', or is it
> to check if there really IS such an (active?) email account, or is it
> to check against a table with valid email addresses? Or something else?
> /impslayer, aka Birger Johansson
>
Friday, March 9, 2012
E-mail address of one or more recipients is not valid
We have setup Reporting Services on a Server 2003 box with SMTP intalled on
it. I am able to write a simple VB Script that uses CDO to send a e-mail out
to a certain address (let's say to john@.test.com). When I setup a
subscription using the same e-mail address I get the error "The e-mail
address of one or more recipients is not valid." Does anyone know why - if I
can write a 6 line CDO vbscript shouldn't SMTP be working?I've figured out what my problem is - apparently SQL Server Reporting
Services is not authenticating correctly. I had to change the settings on
the Relay Restictions on the Access tab for the SMTP Server Properties to be
allow relay through the virtual server with "All except the list below"
instead of the default "Only the list below". Seems like it should work with
the default setting since there is no authentication (anonymous access) but
looks like RS doesn't like that.
"John R" wrote:
> We have setup Reporting Services on a Server 2003 box with SMTP intalled on
> it. I am able to write a simple VB Script that uses CDO to send a e-mail out
> to a certain address (let's say to john@.test.com). When I setup a
> subscription using the same e-mail address I get the error "The e-mail
> address of one or more recipients is not valid." Does anyone know why - if I
> can write a 6 line CDO vbscript shouldn't SMTP be working?
it. I am able to write a simple VB Script that uses CDO to send a e-mail out
to a certain address (let's say to john@.test.com). When I setup a
subscription using the same e-mail address I get the error "The e-mail
address of one or more recipients is not valid." Does anyone know why - if I
can write a 6 line CDO vbscript shouldn't SMTP be working?I've figured out what my problem is - apparently SQL Server Reporting
Services is not authenticating correctly. I had to change the settings on
the Relay Restictions on the Access tab for the SMTP Server Properties to be
allow relay through the virtual server with "All except the list below"
instead of the default "Only the list below". Seems like it should work with
the default setting since there is no authentication (anonymous access) but
looks like RS doesn't like that.
"John R" wrote:
> We have setup Reporting Services on a Server 2003 box with SMTP intalled on
> it. I am able to write a simple VB Script that uses CDO to send a e-mail out
> to a certain address (let's say to john@.test.com). When I setup a
> subscription using the same e-mail address I get the error "The e-mail
> address of one or more recipients is not valid." Does anyone know why - if I
> can write a 6 line CDO vbscript shouldn't SMTP be working?
Subscribe to:
Posts (Atom)