TM1 Forum

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.

If you don't mind having to do some development in .NET you could write your own using the System.Net.Mail namespace.

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.

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.

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?

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.

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.

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.