I have the following report in LANSweeper:
Select Top 1000000 tblAssets.AssetName,
'mailto:me@site.com?subject=Message re ' + tblAssets.assetname As
hyperlink_hyp1,
'EMAIL' As hyperlink_name_hyp1
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
but when I click the 'email' link and opening in outlook, I get something like:

Replacing spaces with %20 gives:

In both cases I want spaces between the words in the subject line.
When I use the link:
mailto:me@somewhere.com?subject=This is the subject&body=hey you!
on the address bar of chrome, this works fine. This is using outlook as the email client.
Any suggestions on how I get it to work from within lansweeper?.