Email link in Sharepoint Lists

Question

How do I make an email address as a link in SharePoint Lists without having to see mailto: at the beginning of the email address?

Answer 1

Hi Beth College,

As per your description, you need to add column(single line column) or in your Email column use a below JSON code formatting to make a email address as a link in SharePoint Lists . Go to Email column (single line column), right-click on column>Column setting>Format this column> Advance mode> and paste below code there and click "save" to check the result.

Reference screenshot:

JSON code:

{ 

    "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", 

    "elmType": "div", 

    "children": [ 

        { 

            "elmType": "a", 

            "style": { 

                "padding-right": "8px" 

            }, 

            "txtContent": "@currentField", 

        "attributes": { 

        "target": "_blank", 

        "href": { 

                    "operator": "+", 

                    "operands": [ 

                        "mailto:", 

                        "@currentField", 

                        "?subject=Wonder women here&body=Hey ",  

            "[$Title]", 

                        "\nJust checking, if you have saved the world?.\r\n---\r\n", 

                        "\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=", 

                        "[$ID]" 

                    ] 

                } 

            } 

        }, 

        { 

            "elmType": "a", 

            "attributes": { 

        "target":"_blank", 

                "class": "sp-field-quickActions", 

        "href": { 

                    "operator": "+", 

                    "operands": [ 

                        "mailto:", 

                        "@currentField", 

                        "?subject=Wonder women here&body=Hey ",  

            "[$Title]", 

                        "\nJust checking, if you have saved the world?\r\n---\r\n", 

                        "\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=", 

                        "[$ID]" 

                    ] 

                } 

            } 

        } 

    ] 

} 

Result:

I appreciate your patience and understanding.

Best Regards

Waqas Muhammad

Answer 2

Hi Beth College,

Have you checked above reply? Do you need further assistance?

Best Regards

Waqas Muhammad

Answer 3

Thank you for your help! I actually found a simpler way, that does not require JSON code.

Edit Column> More Options > Use Enhanced Rich Text

Then proceed to insert the information there, using mailto: and the information.

Thank you so much for your help though! I was really struggling to find a simple solution!

Answer 4

Thank you! I figured it out, but I appreciate your direction as well!

Answer 5

Hi Beth College,

Thanks for your valuable feedback and thanks for sharing updates with us. I appreciate your kind words.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Best Regards,

Waqas Muhammad