How To Create A CUSTOM Clickable EMAIL LINK in Microsoft Lists with JSON
Hey hey, tech enthusiasts! 🤓 Join us as we explore "7 WAYS to CUSTOMIZE A Clickable Email Link in Microsoft Lists with JSON"! Discover the power of JSON formatting to transform a Single Line Text column into a productivity powerhouse with clickable email links. 💌
Imagine enabling users to send emails with just one click from your list—this video makes it a reality. We'll guide you step-by-step through adding a JSON layer to your Microsoft Lists that won't just enhance functionality, but will also increase your workflow efficiency. 🔗
Whether you're organizing tasks for yourself or coordinating with a team, these clickable email links are more than a convenience; they're a game changer. And we'll show you how to personalize each link with custom email subjects, bodies, and even dynamic content pulled directly from your list items. 🌟
This tutorial is not just about getting things done; it's about doing them with style and skill.
If you are a student, teacher, project manager, business owner or super nerd like me, then we have got you covered!
Let's nerd out and enhance your productivity with Microsoft Lists! 🚀
🟢 FREE RESOURCES 🟢
🔴 Grab A Free Copy Of My eBook, Navigating Microsoft Passages 🔴
https://www.officeskillswithamy.com/e...
🟣 Grab A Free Copy Of My Loop Beginner Guide 🟣
https://www.officeskillswithamy.com/m...
🚀 Grab A Free Copy Of My 365 Copilot Starter Pack 🚀
https://www.officeskillswithamy.com/c...
📌 Grab A Free Copy Of My Copilot Agent Toolkit 📌
https://www.officeskillswithamy.com/c...
🟢 LEARN WITH AMY 🟢
🔵 Self-Paced Courses 🔵
https://www.officeskillswithamy.com/m...
🟡 1:1 Personalized Coaching 🟡
https://www.officeskillswithamy.com/m...
🟠 Live Group Training 🟠
https://www.officeskillswithamy.com/m...
⏰ KEY MOMENTS
00:00 Baseline JSON for Clickable Email Links
02:01 Display Text Customization with JSON
03:30 Defining the ‘mailto’ To Field with JSON
04:41 Customizing Email Subject Line with JSON
06:45 Customizing Email Body with List Data
08:45 Styling Email Links with JSON
10:30 Handling Blank Fields with IF Statements in JSON
📹 WHAT TO WATCH NEXT
• How to use the NEW Forms in Microsoft List...
• [How to Create a Clickable Email Link in M...
• Microsoft Lists Hyperlink Column - How to ...
✨ BASELINE JSON
{
"$schema": "https://developer.microsoft.com/json-...",
"elmType": "div",
"children": [
{
"elmType": "span",
"style": {
"padding": "12px"
},
"txtContent": "Send Email"
},
{
"elmType": "a",
"attributes": {
"iconName": "Mail",
"class": "sp-field-quickActions",
"href": {
"operator": "+",
"operands": [
"mailto:",
"[email protected]",
"?subject=Order Follow Up ",
"&body=Hi, We are following up on our order, please confirm the status."
]
}
}
}
]
}
✨ STYLE SNIPPET
"style":{
"text-decoration": "inherit",
"color": "inherit",
"font-size": "inherit",
"font-weight":"inherit"
},
✨ IF SNIPPET
"=if(@currentField, @currentField, 'Need Email')"
✨ FINAL JSON
{
"$schema": "https://developer.microsoft.com/json-...",
"elmType": "div",
"children": [
{
"elmType": "span",
"style": {
"padding": "12px"
},
"txtContent": "=if(@currentField, @currentField, 'Need Email')"
},
{
"elmType": "a",
"style":{
"text-decoration": "inherit",
"color": "#inherit",
"font-size": "inherit",
"font-weight":"inherit"
},
"attributes": {
"iconName": "Mail",
"class": "sp-field-quickActions",
"href": {
"operator": "+",
"operands": [
"mailto:",
"@currentField",
"?subject=Order Follow Up #",
"[$OrderNumber]",
"&body=Hi ",
"[$Title]",
", We are following up on our order, please confirm the status."
]
}
}
}
]
}
💙 SUPPORT THE CHANNEL 💙
If you've learned something from my videos you can now Buy Me A Coffee:
https://www.officeskillswithamy.com/b...
🤓 WELCOME TO OFFICE SKILLS WITH AMY 🤓
Empowering businesses to streamline Microsoft 365 workflows through Microsoft Courses, Microsoft Coaching solutions and Microsoft Group Training.