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.
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…
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385