PDF writer hyperlink annoyance

[Darth Vodka]

i have an Access report with an email address on it, that unfortunately contains an ampersand

abc&[email protected]

PDF writer goes "oooh an @ signm this is an email", creates a hyperlink, but ballses it up because of the ampersand to

mailto:[email protected]

:icon_eek:

anyone know how to get PDF writer to either
a) do it properly
b) stop doing hyperlinks

 

[Jeff]

i have an Access report with an email address on it, that unfortunately contains an ampersand

abc&[email protected]

PDF writer goes "oooh an @ signm this is an email", creates a hyperlink, but ballses it up because of the ampersand to

mailto:[email protected]

:icon_eek:

anyone know how to get PDF writer to either
a) do it properly
b) stop doing hyperlinks

Try replacing the ampersand with %26, it might then translate that into the ampersand without breaking the address.

 

[Darth Vodka]

Try replacing the ampersand with %26, it might then translate that into the ampersand without breaking the address.

tried that already (and &&) it displays it as ampersand and then PDF writer takes what is displayed



ta anyways

 

[Matt_B]

& is a bit of an irregular character to have in an email Darth, don't you have problems with people receiving email from it anyway? or it validating in forms?

 

[Macky]

& is a bit of an irregular character to have in an email Darth, don't you have problems with people receiving email from it anyway? or it validating in forms?

I was thinking the same, a lot of email systems won't handle ampersands in addresses.

 

[Steven]

I was thinking the same, a lot of email systems won't handle ampersands in addresses.

According to this character it is valid. However I think it is only valid if you enclose it in quotes.

Acme&[email protected] - is not valid
"Acme&Co"@acmegroup.com - is valid. :icon_eek: :icon_conf

 

[Matt_B]

According to this character it is valid. However I think it is only valid if you enclose it in quotes.

Acme&[email protected] - is not valid
"Acme&Co"@acmegroup.com - is valid. :icon_eek: :icon_conf

That is correct, however .net/C# default email sending will not recognise it as valid, and certain mail server software don't send it. I know this as I had a site the other week wouldn't send for something similar, I think it was an _ at the start of the address, which is valid but the server rejected it as invalid.

edit, it wasn't the _ they had a white space which is why I recognised the quoting sytem.

 

[Darth Vodka]

& is a bit of an irregular character to have in an email Darth, don't you have problems with people receiving email from it anyway? or it validating in forms?

no, it works fine, but there is an SMTP address with no funny letters, not quite sure what the SMTP aliases are all about



and yes our first reaction was "who set that email up with a funny letter?"



there's no nice way to solve it that i found, they can either:-

1) force PDF writer to switch off hyperlinks in each PDF they create every time
2) use mailto:abc&def [[email protected]]
3) get IT to change their email/add another alias without a funny letter

effort

thanks all