Mailto formula help: url contains "&"

I am creating a formula to create an email from excel.


=HYPERLINK(CONCATENATE("mailto:",H1,"?subject=",H3,"&body=",G3))


G3 is the url link created in the table using our tracking codes that use "&" as a separator

https://XXXXXXXXXX.taleo.net/careers...&src=SNS-10060


so the url that is copied to the email looks like this:
https://XXXXXXXXXX.taleo.net/careers...il.ftl?lang=en

I have tried a million way to build a formula around this limit and failed each time. Can anyone help please. I searched and read here and elsewhere before posting.

BUMP - Please, I need some advice to solve

I was able to solve this problem on my own by converting all special characters manually into HTML variations (See below)

Find and Replace
: %3A
/ %2F
? %3F
= %3D
& "%26"
# "%23"
Space "%20"
Line Break %0A
+ %2B


This was a bit of a special case, since I did not want to use VBA, and I was not able to change our hyperlink structure. The end result is a spreadsheet that appends tracking code to our urls in the body of email with the subject customizable from drop down menus.

The email is sent to webservice and converted into RSS feed, which can then be distributed to our corporate social media channels. Templating the tracking code and messages gave corporate a happy feeling, and since all emails are traceable to the source, we know who and when they were sent in case someone goes rogue (we can reset the mailto address as well).


The only issue we have is the 255 character limit. Each special character or space uses 4 characters, so messages are very brief. I would love to learn of a work-around or short URL service that can operate within excel, that would create additional character space.