Mailto function multiple line body

in regard to the mailto anapedia, how to have the body of the email to have multiple lines? i.e. how to make %0D%0A work in to the mailto formula?

Accepted answers

All comments

PrevContributor

Hi Jen,

Perhaps instead of using multiple Line Items for your Body, can you create a concatenated Line Item which is a formula merging all your Body Line Items into one Line Item, and then referencing that final concatenation in the Mailto function? For example, if you want your Body to be Line Item A & Line Item B, create Line Item C with formula 'Line Item A' & 'Line Item B' (with any necessary spacing/formatting issues), and then using Line Item C in your Mailto function?

Hope that helps!

-Chris Weiss

jeremiebrunet

Hi,
Try using %0A%0A without any quotes around. Here's a simple example that worked for me, without using MAILTO. Just format your line item as Text / Email and enter the formula :

"[click here to submit your budget]" & "recipientaddress@company.com" & "?subject=Budget Submission&body=Please review my budget. %0A%0A Thanks"

Hope this helps in the MAILTO context.

Dennis_Lucanas

Hi, CC is now not working. Please help. here's my code "[Notification]" & TO & "?cc=" & Control Module.UniPlan Admin Email & "&subject=" & Subject & "&body=" & Body & "%0A%0AThanks" ELSE BLANK

Thanks Dennis

AlexisY

Hi Denis,

Try replace ? by & before cc and add "mailto:?to=" like this:

"[Notification]" & "mailto:?to=" & TO & "&cc=" & Control Module.UniPlan Admin Email & "&subject=" & Subject & "&body=" & Body & "%0A%0AThanks" ELSE BLANK

This should works fine 🙂

Alexis

rolympia

Hi all,

I'm having trouble with the Mailto: on google chrome opening gmail. I have set google chrome to open gmail for mailto: protocols. Test scenarios:

* anaplan mailto on chrome - new tab opens momentarily, but never opens gmail

BUT

* non-anaplan mailto (a link on w3schools.com) on chrome- opens gmail on chrome with compose

* anaplan mailto on internet explorer- opens gmail on chrome with compose

* anaplan mailto on firefox- opens gmail on chrome with compose

I have disabled popup blockers on chrome, but still I cannot open gmail. Have you guys experienced such problems?

thanks!

andrea.lee

I am having this exact issue. Did you ever find a solution to this problem?

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…