We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jrhnhs
Engaged Sweeper II

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:

image.png

Replacing spaces with %20 gives:
image (1).png

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?.

5 REPLIES 5
jrhnhs
Engaged Sweeper II
 

Sadly, I have tried this before.

image (2).png

Jacob_H
Lansweeper Employee
Lansweeper Employee

yo JR -  i'm not on a computer that can access my on-prem database at the moment, BUT....  you could try this

SELECT TOP 1000000
  tblAssets.AssetName,
  'mailto:me@site.com?subject=Message%20re%20' + 
  REPLACE(tblAssets.AssetName, ' ', '%20') 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
Katgroup
Lansweeper Employee
Lansweeper Employee

Hi jrhnhs,

Could you open a support case for this so we can log it as a feature request?

Manage Cases - Lansweeper Community

jrhnhs
Engaged Sweeper II

I have tried but don't have access to the support portal.

Katgroup
Lansweeper Employee
Lansweeper Employee

It looks like we didn't have a contact for you in our ticketing system; I've corrected this and you should be able to open a case now 🙂.

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now