mailto: with multiple email addresses = Invalid URI

I'm trying to create a mailto link with muliple email addresses like
"mailto:name@.email1.com;name2@.email2.com;name3@.email3.com" and cannot
get it working. any ideas on how to get this working?
Thanksgot it working...as an expression w/in the navigation tab of Advanced
Textbox Properties
=IIf( IsNothing(Fields!EmailGroupList.Value),
Nothing,("javascript:void(window.open('mailto:" &
Fields!EmailGroupList.Value & "','_blank'))"))
this opens up the mail client and populates the To: field with multiple
addresses.

mailto: protocol

i am using mailto: protocol in jump to URL. if i hard code the value
(xyz@.microsoft.com), it works fine. But if i try to use
mailto:Fields!email.Value, it throws out an error to me saying "Invalid URI"
Has anyone faced such kind of problem or has a solution for it?
--
Thanks!
AshishDid you try this expression:
="mailto:" & Fields!email.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashish" <Ashish@.discussions.microsoft.com> wrote in message
news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> i am using mailto: protocol in jump to URL. if i hard code the value
> (xyz@.microsoft.com), it works fine. But if i try to use
> mailto:Fields!email.Value, it throws out an error to me saying "Invalid
URI"
> Has anyone faced such kind of problem or has a solution for it?
> --
> Thanks!
> Ashish|||Hi Robert,
Thanks for the reply.
I tried the expression ="mailto:" & Fields!email.Value but everytime it
gives me an error saying "Invalid URI: Hostname could not be parsed"
Thanks
"Robert Bruckner [MSFT]" wrote:
> Did you try this expression:
> ="mailto:" & Fields!email.Value
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> > i am using mailto: protocol in jump to URL. if i hard code the value
> > (xyz@.microsoft.com), it works fine. But if i try to use
> > mailto:Fields!email.Value, it throws out an error to me saying "Invalid
> URI"
> >
> > Has anyone faced such kind of problem or has a solution for it?
> > --
> > Thanks!
> > Ashish
>
>|||Do you have RS 2000 SP1 installed?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashish" <Ashish@.discussions.microsoft.com> wrote in message
news:0A5C0D9C-B4F2-4947-81B5-0854CB00395D@.microsoft.com...
> Hi Robert,
> Thanks for the reply.
> I tried the expression ="mailto:" & Fields!email.Value but everytime it
> gives me an error saying "Invalid URI: Hostname could not be parsed"
> Thanks
> "Robert Bruckner [MSFT]" wrote:
> > Did you try this expression:
> > ="mailto:" & Fields!email.Value
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> > news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> > > i am using mailto: protocol in jump to URL. if i hard code the value
> > > (xyz@.microsoft.com), it works fine. But if i try to use
> > > mailto:Fields!email.Value, it throws out an error to me saying
"Invalid
> > URI"
> > >
> > > Has anyone faced such kind of problem or has a solution for it?
> > > --
> > > Thanks!
> > > Ashish
> >
> >
> >|||I had the same problem. If any record in your data set does not return an
email address in the form of name@.abc.com, you will receive that message. I
got around it by setting a default email address to any record that did not
have an email specified.
Hope that helps.
Stan
"Ashish" <Ashish@.discussions.microsoft.com> wrote in message
news:0A5C0D9C-B4F2-4947-81B5-0854CB00395D@.microsoft.com...
> Hi Robert,
> Thanks for the reply.
> I tried the expression ="mailto:" & Fields!email.Value but everytime it
> gives me an error saying "Invalid URI: Hostname could not be parsed"
> Thanks
> "Robert Bruckner [MSFT]" wrote:
> > Did you try this expression:
> > ="mailto:" & Fields!email.Value
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> > news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> > > i am using mailto: protocol in jump to URL. if i hard code the value
> > > (xyz@.microsoft.com), it works fine. But if i try to use
> > > mailto:Fields!email.Value, it throws out an error to me saying
"Invalid
> > URI"
> > >
> > > Has anyone faced such kind of problem or has a solution for it?
> > > --
> > > Thanks!
> > > Ashish
> >
> >
> >|||I do have RS 2000 SP 1 installed
One more thing was that how can we add custom subject and body with the
mailto: protocol
Thanks for the help
Ashish
"Robert Bruckner [MSFT]" wrote:
> Do you have RS 2000 SP1 installed?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> news:0A5C0D9C-B4F2-4947-81B5-0854CB00395D@.microsoft.com...
> > Hi Robert,
> >
> > Thanks for the reply.
> > I tried the expression ="mailto:" & Fields!email.Value but everytime it
> > gives me an error saying "Invalid URI: Hostname could not be parsed"
> >
> > Thanks
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Did you try this expression:
> > > ="mailto:" & Fields!email.Value
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> > > news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> > > > i am using mailto: protocol in jump to URL. if i hard code the value
> > > > (xyz@.microsoft.com), it works fine. But if i try to use
> > > > mailto:Fields!email.Value, it throws out an error to me saying
> "Invalid
> > > URI"
> > > >
> > > > Has anyone faced such kind of problem or has a solution for it?
> > > > --
> > > > Thanks!
> > > > Ashish
> > >
> > >
> > >
>
>|||Yes, you were right. If any record in the dataset doesn't return any email
then it throws out that error.
Do you know how we can write the custom mail subject and mail body in that
expression.
Thanks for the help
Ashish
"SSVette@.Hotmail.com" wrote:
> I had the same problem. If any record in your data set does not return an
> email address in the form of name@.abc.com, you will receive that message. I
> got around it by setting a default email address to any record that did not
> have an email specified.
> Hope that helps.
> Stan
> "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> news:0A5C0D9C-B4F2-4947-81B5-0854CB00395D@.microsoft.com...
> > Hi Robert,
> >
> > Thanks for the reply.
> > I tried the expression ="mailto:" & Fields!email.Value but everytime it
> > gives me an error saying "Invalid URI: Hostname could not be parsed"
> >
> > Thanks
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Did you try this expression:
> > > ="mailto:" & Fields!email.Value
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Ashish" <Ashish@.discussions.microsoft.com> wrote in message
> > > news:9D7D36EE-784E-424C-81CF-BFA53B4173AB@.microsoft.com...
> > > > i am using mailto: protocol in jump to URL. if i hard code the value
> > > > (xyz@.microsoft.com), it works fine. But if i try to use
> > > > mailto:Fields!email.Value, it throws out an error to me saying
> "Invalid
> > > URI"
> > > >
> > > > Has anyone faced such kind of problem or has a solution for it?
> > > > --
> > > > Thanks!
> > > > Ashish
> > >
> > >
> > >
>
>

mailto: hyperlink

How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions.
VRThat should work, check the acutal host name of the email address to make
sure it's ok.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"vrodkar" <vrodkar@.discussions.microsoft.com> wrote in message
news:2075FB1D-B624-4C6E-8CB7-F0A468594602@.microsoft.com...
> How do we put a mailto hyperlink in the report. I used an expression in
> 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that
> it is an invalid URI: host name could not be parsed. Any suggestions.
> VR|||I ran across the same problem and found it to be a data issue. The following expression in the Jump to URL validated each email address for an @. sign:
=iif(InStr( Fields!email.Value, "@.")=0,Nothing,"mailto:" + Fields!email.Value )
Hope that helps!
"vrodkar" wrote:
> How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions.
> VR

mailto in RS

hello, how can have the mailto feature in rs? can someone please help me out
on this? thanks.Are you talking about the email delivery extension? If so, in the
RSReportServer.config file, make sure that the elements for smtpserver and
From are filled in. Until these are present, the email extension will not
show up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Asha" <Asha@.discussions.microsoft.com> wrote in message
news:9651C72E-1677-4D86-B24D-915070639309@.microsoft.com...
> hello, how can have the mailto feature in rs? can someone please help me
> out
> on this? thanks.

MailTo html in SELECT Statetment?

How do I write a SELECT statement to return one of the selected fields as a mail to link?
Thanks for helping a SQL newbie.
Scott

I'm a little confused. You'd do a SELECT emailAddress FROM yourTable, and then you would just plop the value into an anchor tag with a "mailto:" prefix.
Do you have some code that is not working correctly?
|||

Thank you for responding.

I'm using Dave O'Leary's Advanced DataGrid to pull content out of a MS SQL 2000 table in a DNN3 application.
Heres the statement:
SELECT TOP 5 Title, Price, EmailContact FROM cs_ClassifiedsItem ORDER BY CreatedDate
The DNN module stores classified ad information. The email address is stored as a character string and is returned as a mailto link at runtime. Advanced DataGrid simply returns the character string. I'd like to add code to the SELECT statement to return the email character string as a mailto link.

Mr. O'Leary provides the following guidance on his websitehttp://www.efficionconsulting.com/Default.aspx?tabid=217:

Q. Can the Grid display images and/or Links? A. Yes. To do so, you basically need to return the appropriate HTML so, you can either store the full HTML in the database field or, in the select statement you can add the HTML, i.e. SELECT '<img src=' + ImageName + '>' FROM LinkImage. I have not been able to get this to work using various forms of mailto tags. Help is much appreciated. Thanks, Scott

|||Then something like this might work for you:

SELECT TOP 5
Title,
Price,
'<a href=''mailto:' + EmailContact + '''>' + EmailContact + '</a>' AS MailToLink
FROM
cs_ClassifiedsItem
ORDER BY
CreatedDate

I don't think that mixing presentation code with data access code is a good idea, however.
|||Thank You! And I appreciate your guidance on mixing code.
Scott

mailto and picking a field for the subject line

I've put a hyperlink on a report to send a message to the support center
concerning service calls that are overdue for closure. How can I assign one
of the report fields as the subject of the mail message? For instance, if
the user clicks the 'Send Mail' link, the subject of the mail is "Call Number
"& "Field.svc00200.
Mail system is Exchange.
Many thanks
(BTW--I know 0 .net code, so keep that in mind, lol)Build the url string programmatically. I know you say you don't know
.Net but in RS a little knowledge goes a long way!
Where you would type the url, try
="mailto:" + Fields!email.Value + "&Subject=Call number" +
Fields!svc00200.Value
Chris
Jeff Metcalf wrote:
> I've put a hyperlink on a report to send a message to the support
> center concerning service calls that are overdue for closure. How
> can I assign one of the report fields as the subject of the mail
> message? For instance, if the user clicks the 'Send Mail' link, the
> subject of the mail is "Call Number "& "Field.svc00200.
> Mail system is Exchange.
> Many thanks
> (BTW--I know 0 .net code, so keep that in mind, lol)|||Nope, doesn't work. Gets Invalid URI: The hostname could not be parsed.
="Mailto:dispatch@.blah.com"+"&Subject=Call Number
"+Fields!svc00200.callnbr.Value
"Chris McGuigan" wrote:
> Build the url string programmatically. I know you say you don't know
> ..Net but in RS a little knowledge goes a long way!
> Where you would type the url, try
> ="mailto:" + Fields!email.Value + "&Subject=Call number" +
> Fields!svc00200.Value
> Chris
>
> Jeff Metcalf wrote:
> > I've put a hyperlink on a report to send a message to the support
> > center concerning service calls that are overdue for closure. How
> > can I assign one of the report fields as the subject of the mail
> > message? For instance, if the user clicks the 'Send Mail' link, the
> > subject of the mail is "Call Number "& "Field.svc00200.
> >
> > Mail system is Exchange.
> >
> > Many thanks
> > (BTW--I know 0 .net code, so keep that in mind, lol)
>|||I'm guessing it's a typo, but you have Fields!svc00200.callnbr.Value,
that doesn't look valid to me!
I have had this working, so it is possible. You probably haven't quite
got the expression right. Are there any characters in the returned
field that would effect the parsing, eg &
Chris
Jeff Metcalf wrote:
> Nope, doesn't work. Gets Invalid URI: The hostname could not be
> parsed.
> ="Mailto:dispatch@.blah.com"+"&Subject=Call Number
> "+Fields!svc00200.callnbr.Value
> "Chris McGuigan" wrote:
> > Build the url string programmatically. I know you say you don't know
> > ..Net but in RS a little knowledge goes a long way!
> > Where you would type the url, try
> > ="mailto:" + Fields!email.Value + "&Subject=Call number" +
> > Fields!svc00200.Value
> >
> > Chris
> >
> >
> > Jeff Metcalf wrote:
> >
> > > I've put a hyperlink on a report to send a message to the support
> > > center concerning service calls that are overdue for closure. How
> > > can I assign one of the report fields as the subject of the mail
> > > message? For instance, if the user clicks the 'Send Mail' link,
> > > the subject of the mail is "Call Number "& "Field.svc00200.
> > >
> > > Mail system is Exchange.
> > >
> > > Many thanks
> > > (BTW--I know 0 .net code, so keep that in mind, lol)
> >
> >