Sending emails from TM1 without CDO
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Sending emails from TM1 without CDO
I am looking into possible solutions for sending emails from TM1. As per earlier posts, a recommended solution was to use vb scripts based on CDOhttp://www.rondebruin.nl/cdo.htm. In Exchange 2010 CDO is not officially supported anymore, due to possible incompatibilities with 64-bit. Does anyone know of another solution, preferably one that would last for a longer period, withstanding numerous MS changes? I was looking into powershell scripts, but they seem to be changing quite often, so not sure if it is an optimal way.
-
- Posts: 26
- Joined: Fri Oct 09, 2009 5:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Sending emails from TM1 without CDO
If you don't mind having to do some development in .NET you could write your own using the System.Net.Mail namespace.
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Sending emails from TM1 without CDO
Hi
In the past, I have used sendemail:
http://caspian.dotconf.net/menu/Software/SendEmail/
Though more at the level of the pet project rather than development with customers.
But it worked fine.
In the past, I have used sendemail:
http://caspian.dotconf.net/menu/Software/SendEmail/
Though more at the level of the pet project rather than development with customers.
But it worked fine.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Sending emails from TM1 without CDO
I have implemented this commercially and works nicely to this day. The only thing you need is access to an SMTP server in the organisation (not always a given).Wim Gielis wrote:In the past, I have used sendemail
If your company/customer prefers Lotus Notes, it's possible to set up a daemon to scan a folder for any files to be sent as e-mails.
Kamil Arendt
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Sending emails from TM1 without CDO
I do not have experience with .Net development, do you know of some ready-made solution for such purpose?bagovino wrote:If you don't mind having to do some development in .NET you could write your own using the System.Net.Mail namespace.
-
- Posts: 34
- Joined: Mon Oct 18, 2010 7:38 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Sending emails from TM1 without CDO
qml wrote:I have implemented this commercially and works nicely to this day. The only thing you need is access to an SMTP server in the organisation (not always a given).Wim Gielis wrote:In the past, I have used sendemail
If your company/customer prefers Lotus Notes, it's possible to set up a daemon to scan a folder for any files to be sent as e-mails.
it seems to have problems with mails larger than 16kb in windows environment, an I'll have attachments that can be significantly larger. Also do you know if it has an option to receive confirmation that mail was send?
Anyway, thanks for suggestion.
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Sending emails from TM1 without CDO
Have you done a simple internet search for "smtp email" or "command line email"? There are many email tools out there that allow emails to be sent from command line interface and require only access to smtp server (most of them freeware). I have used blat.exe quite a lot in the past and haven't ever had an issue with file size restrictions for attachments.vladkon wrote:it seems to have problems with mails larger than 16kb in windows environment, an I'll have attachments that can be significantly larger. Also do you know if it has an option to receive confirmation that mail was send?
Anyway, thanks for suggestion.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Sending emails from TM1 without CDO
Blat is definitely one of the better ones and I can second Lotsa's recommendation. However, the showstopper problem you might find is that some SMTP servers will block e-mail sent by blat as it thinks it is spam. To date, I've not found a bullet-proof technical solution to this, but it getting a friendly IT guy involved who knows their way around an Exchange/ Domino server is very worthwhile.lotsaram wrote:I have used blat.exe quite a lot in the past and haven't ever had an issue with file size restrictions for attachments.
Robin Mackenzie