Send mail (Windows 2008 Server)

gardenierbi — Thu, 29 Dec 2011 10:32:27 GMT

Before Windows 2008 we used the CDOSYS library for sending mail with a macro. Windows 2008 doesn't have this library, we should use the System.Net.Mail namespace from the .NET Framework (see: http://hosting.intermedia.net/support/kb/default.asp?id=1579). So instead coding this:

Set objEmail = CreateObject("CDO.Message")

We should coding this:

%@ Import Namespace="System.Net.Mail"%

How can we do this with QlikView?

I've already searched for an example on the Community but I can't find any. Who has a working example for mailing with a macro from a Windows 2008 Server 64bit environment?

Re: Send mail (Windows 2008 Server)

fosuzuki — Thu, 29 Dec 2011 17:49:55 GMT

Hi,

I have one app working in Windows 2008 Server. It works both when triggering it locally in the server and when the user triggers it wia IE Plugin. I use the following code in a macro (some parts are commented out because my environment doesn't need):

' Object creation

Set objMsg = CreateObject("CDO.Message")

Set msgConf = CreateObject("CDO.Configuration")

Set myMail=CreateObject("CDO.Message")

'==This section provides the configuration information for the remote SMTP server.

' Server Configuration

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

'Name or IP of Remote SMTP Server

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = sSMTPServerIP

'Server port (typically 25)

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = sSMTPServerPort

''Use SSL for the connection (False or True)