I am building email template for MAILTO formula. Is it possible to format the text (make bold, italic, colored) and create paragraphs in the emails' body? Maybe implement html tags?
I don't believe you can do bolds, italics, or colored, but you can have multi lines like paragraphs.
Create a Line item called Break without any dimensionality (or better yet, create this in its own module without dimensionality) with the formula being: " "
Create a line item named Removed Quotes with the formula: RIGHT(LEFT(break, 2), 1)
Create your 1st paragraph in a line item (Body line 1), your 2nd paragraph in a secod line item (Body Line 2), etc.
Create another line item named Full Body with the formula: 'Body Line 1' & Remove quotes & 'Line 2' & Remove quotes & 'Line 3'
In the last parameter of the MAILTO function, use the Full Body line item.
This should give you what you are looking for in regards to line breaks.
Hope this helps,
this is what the body of my mailto looks like:
but it should like this instead:
to make the link visible and clickable to the recipients.
Do we have any workarounds to do this?
Note: here is my mailto formula:
MAILTO("Send to Approver 1", " ", "", "", "Anaplan notification", "https://us2a.app.anaplan.com/core10145/anaplan/framework.jsp?selectedWorkspaceId=8a81b00e67191af0016...")
Thank you so much!
I would check the format of the email, whether the default is in HTML or Text.
Your solution is not working to me. Quick questions:
Thanks in advance for your help.
Care to attach some pictures to help figure out what is going on?
Sure! Here you go some pictures. The line items I'm using are "Body", "break" and "MAILTO" ("Body 2" and "MAILTO2" are for an alternative solution I found in the Community).
I think the issue is in your break and break_aux line items.
Break should not be a subsidiary view, but fully dimensioned by what you have in the Applies To for the module:
Break_aux should not be a formula of " ", but that should be entered as the text. Take a look at the below:
Thanks for the quick answer. I did the changes, but it's still not working (same result). Please, find new screenshots below:
On the Break, you don't enter " ", but rather " shift return (on the Mac -> Control + Option + Return)