In this article, we will discuss how to create clickable email links in NetSuite Saved Searches using the mailto: hyperlinks.
This technique allows users to launch their default email application directly from a Saved Search result, making it easier to contact customers, vendors, employees, or leads without copying email addresses manually.
Solution: Using Formula (HTML) Field
Using a Formula (HTML) field, you can turn email addresses into clickable links that:
- Open Outlook or another email client
- Prepopulate recipient email addresses
- Optionally include subject lines and email body text
This is especially useful for:
- Customer follow-up searches
- Collections and AR workflows
- Vendor communication lists
- Sales outreach searches
Example Formulas:
- Formula 1: '<a href="mailto:' || {email} || '">Send Email</a>'
- Formula 2: '<a href="mailto:' || {email} || '">' || {email} || '</a>'
- Formula 3 (with Default Subject Line): '<a href="mailto:' || {email} || '?subject=Customer Follow Up">Email Customer</a>'
- Notes:
- Spaces should use %20
- Special characters may require URL encoding
- Formula 4 (with Subject and Body Text): '<a href="mailto:' || {email} || '?subject=Invoice Reminder&body=Hello,%20please%20review%20your%20open%20invoice.">Send Reminder</a>'
- Notes:
- Spaces should use %20
- Special characters may require URL encoding
- Formula 5 (formatted as a button): '<a href="mailto:' || {email} || '" style="padding:4px 8px;background:#0070d2;color:white;text-decoration:none;border-radius:4px;">Email</a>'
Example Result:
Notes
-This behavior depends on the user having a default email application configured.
-Results may vary between browsers and operating systems.
-Test formulas in Sandbox before moving to production.
-Formula (HTML) fields support limited HTML rendering within Saved Search results.
The mailto: link is a simple but powerful way to make Saved Searches more interactive and user-friendly.
With just a Formula (HTML) field, you can streamline communication workflows and reduce repetitive manual steps for your users.
-----
If you find this information useful, let us know by reacting or commenting on this post!