Hi,
I would like to integrate MAILTO function so that it automatically sends email to dynamic users based on selections done at the backend.
Thanks
Hi @bhavikasgupta
Unfortunately the MAILTO keyword is a manual function where a user does need to click on it, before your de facto email app pops up with the relevant fields populated, before you manually click 'Send' to send the email.
However there is a workaround for your request that doesn't involve MAILTO.
You can create a module with a numbered list (depending on your requirements, this numbered list can be replaced by a combination of lists) and line item. The numbered list could be a technical list with say 100 members, and the line items are text formatted to capture the TO, CC, BCC, Subject, Mail Body. You can also insert additional Boolean line items which shows/hides different rows based on dynamic selection requirement mentioned in your question.
You can then have an Anaplan Connect in an enterprise server scheduled to export the module above into a csv/txt file. Then a program is scheduled to send the csv/txt file to a SMTP server which then sends the email out.
There is some blocking taking place during an export, so do schedule your export accordingly. You can read the following https://community.anaplan.com/t5/Best-Practices/Imports-and-Exports-and-Their-Effects-on-Model-Performance/ta-p/33552
Thanks,
LipChean
Hi @LipChean_Soh
Thank you for your reply!!
Well with integration what I meant was to send email automatically without any human interference. The email which I am sending currently to users do not have any sort of exports but it's a reminder to those users to complete there pending task.
I already have everything in place to select only those users who have not completed there task but my reason for asking this here was I have to do this every 4 hours so if I could integrate it or may be set some timer to send this email automatically.
Thanks!!
In my response, i mentioned "You can then have an Anaplan Connect in an enterprise server scheduled to export the module above into a csv/txt file. Then a program is scheduled to send the csv/txt file to a SMTP server which then sends the email out."
The scheduled is done by scheduling Anaplan Connect to run every 4 hrs, before another program sends the csv/txt file to a SMTP server.
As mentioned, this is a workaround that requires some scripting, since we don't have anything in Anaplan at the moment that does scheduled email sending.
@bhavikasgupta
Mailto needs a manual trigger. I am not sure if Python can help here. @JaredDolich
Hi @LipChean_Soh?
Hello, what Program is used to schedule the sending of csv/txt file to SMTP server?
Hi @Misbah , Python Scripts needs Virtual Machine to run by itself and the end users do not have Virtual Machine but yes Phyton Scripts can be used if they have virtual machine.
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?