Sending emails from TM1 without CDO

Post Reply
vladkon
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

Post by vladkon »

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.
bagovino
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

Post by bagovino »

If you don't mind having to do some development in .NET you could write your own using the System.Net.Mail namespace.
Wim Gielis
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

Post by Wim Gielis »

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.
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
User avatar
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

Post by qml »

Wim Gielis wrote:In the past, I have used sendemail
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).
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
vladkon
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

Post by vladkon »

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.
I do not have experience with .Net development, do you know of some ready-made solution for such purpose?
vladkon
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

Post by vladkon »

qml wrote:
Wim Gielis wrote:In the past, I have used sendemail
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).
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.
lotsaram
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

Post by lotsaram »

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.
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.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Sending emails from TM1 without CDO

Post by rmackenzie »

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.
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.
Robin Mackenzie
Post Reply