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 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)
> >
> >