Discussion:
Navigation to URL- mailto: failing when field text includes &
(too old to reply)
Samyra
2010-02-23 15:54:02 UTC
Permalink
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.

This works great, except when the data I am pulling in includes an &.

If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.

For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.


Below is the url I am using:

="mailto:" & Fields!Expr1.Value &
"?subject=Funding%20Packet&cc=" &Fields!AltEmail.Value &
"&body=Attached%20is%20a%20scanned%20copy%20of%20the%20lease%20documents%20for%20"
& Fields!Lessee.Value &
".%20%20The%20original%20documents%20will%20be%20sent%20overnight.%20%0D%0A%0D%0APlease%20Fund.%20%20%0D%0A%0D%0AThank%20You!%0D%0A"
--
Samyra
Maurice Maglalang
2011-09-21 17:06:53 UTC
Permalink
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Samyra
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.
This works great, except when the data I am pulling in includes an &.
If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.
For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.
="mailto:" & Fields!Expr1.Value &
"?subject=Funding%20Packet&cc=" &Fields!AltEmail.Value &
"&body=Attached%20is%20a%20scanned%20copy%20of%20the%20lease%20documents%20for%20"
& Fields!Lessee.Value &
".%20%20The%20original%20documents%20will%20be%20sent%20overnight.%20%0D%0A%0D%0APlease%20Fund.%20%20%0D%0A%0D%0AThank%20You!%0D%0A"
--
Samyra
Maurice Maglalang
2011-09-21 17:07:26 UTC
Permalink
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Samyra
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.
This works great, except when the data I am pulling in includes an &.
If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.
For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.
="mailto:" & Fields!Expr1.Value &
"?subject=Funding%20Packet&cc=" &Fields!AltEmail.Value &
"&body=Attached%20is%20a%20scanned%20copy%20of%20the%20lease%20documents%20for%20"
& Fields!Lessee.Value &
".%20%20The%20original%20documents%20will%20be%20sent%20overnight.%20%0D%0A%0D%0APlease%20Fund.%20%20%0D%0A%0D%0AThank%20You!%0D%0A"
--
Samyra
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Maurice Maglalang
2011-09-21 17:07:47 UTC
Permalink
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Samyra
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.
This works great, except when the data I am pulling in includes an &.
If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.
For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.
="mailto:" & Fields!Expr1.Value &
"?subject=Funding%20Packet&cc=" &Fields!AltEmail.Value &
"&body=Attached%20is%20a%20scanned%20copy%20of%20the%20lease%20documents%20for%20"
& Fields!Lessee.Value &
".%20%20The%20original%20documents%20will%20be%20sent%20overnight.%20%0D%0A%0D%0APlease%20Fund.%20%20%0D%0A%0D%0AThank%20You!%0D%0A"
--
Samyra
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Maurice Maglalang
2011-09-21 17:09:00 UTC
Permalink
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Samyra
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.
This works great, except when the data I am pulling in includes an &.
If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.
For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.
="mailto:" & Fields!Expr1.Value &
"?subject=Funding%20Packet&cc=" &Fields!AltEmail.Value &
"&body=Attached%20is%20a%20scanned%20copy%20of%20the%20lease%20documents%20for%20"
& Fields!Lessee.Value &
".%20%20The%20original%20documents%20will%20be%20sent%20overnight.%20%0D%0A%0D%0APlease%20Fund.%20%20%0D%0A%0D%0AThank%20You!%0D%0A"
--
Samyra
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Post by Maurice Maglalang
concatenate with a + not an &. but my question is why can't i get it to work when concatenating with a multivalue joined parameter? for example: ="MailTo:" + Join(Parameters!ListOfEmailAddresses.Value, "; ") comes back with an invalid URI error message. anyone?
Loading...