Please find below the script to send outlook mails through spotfire, modify it according to your need.

[Manoj Chaurasia]

Hi All,

 

Please find below the script to send outlook mails through spotfire, modify it according to your need.

 

Please make sure outlook is opened.

 

 

import clrclr.AddReference("System.Windows.Forms")from System.Windows.Forms import SendKeysfrom System.Threading import *from System.Runtime.InteropServices import Marshalclr.AddReference("Microsoft.Office.Interop.Outlook")import Microsoft.Office.Interop.Outlook as outlook

out = Marshal.GetActiveObject("Outlook.Application")ns=out.GetNamespace("MAPI")df=outlook.OlDefaultFolders.olFolderOutboxf = ns.GetDefaultFolder(df);

it=outlook.OlItemType.olMailItemmsg=out.CreateItem(it)

ins=msg.GetInspectormsg.HTMLBody="hello spotfire training is on"msg.Subject="Spotfire"msg.To="harmeet.singh@gmail.com"

msg.Display(False)

SendKeys.SendWait("%(S)")SendKeys.SendWait("%(S)")

 

 

Hope it mails :)

[Manoj Chaurasia]

oh that would be a great help!!

[veera alavala]

i am working on a requirement to export an entire page as pdf and send it up to a group in an email, do you have any idea how this can be done in spotfire

[Manoj Chaurasia]

Yupes its possible check all of my post, wait i will consolidate the script and post

[christopher sawtelle 2]

Cool idea! How do I set the script up in Spotfire to be able to run it

[Manoj Chaurasia]

you just need a button and set the script :))

[christopher sawtelle 2]

I'll give it a try!!

[veera alavala]

hey harmeet, were you able to figure out consolidated script for exporting a pdf and send the pdf in an email to a group of users

[sunitha -]

Hi Harmeet,

 

Your answer is helpful. Thanks. But is there any way we can give outlook credentials here to use instead of keeping outlook open

 

Thanks,

 

Sunitha

[Vinda G]

Hi Harmeet,

I have tried the above code sending mails through Outlook. Where as it is working fine in Client but not in WebPlayer. I am using Spotfire 7.6.1 Version

It throws the below error:

Could not add reference to assembly Microsoft.Office.Interop.Outlook

at IronPython.Runtime.ClrModule.AddReference(CodeContext context, String name)

at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object reference)

at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object[] references)

at _stub_$2622##2622(Closure , CallSite , CodeContext , Object , String )

at Microsoft.Scripting.Actions.MatchCaller.Call3[T0,T1,T2,TRet](Func`5 target, CallSite site, Object[] args)

at Microsoft.Scripting.Actions.CallSite`1.UpdateAndExecute(Object[] args)

at Microsoft.Scripting.Actions.UpdateDelegates.Update3[T,T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)

at $2629##2629(Closure , Scope , LanguageContext )

at Microsoft.Scripting.SourceUnit.Execute(Scope scope, ErrorSink errorSink)

at Spotfire.Dxp.Application.ScriptSupport.IronPythonScriptEngine.Execute(ScriptDefinition script, Dictionary`2 scope)

at Spotfire.Dxp.Application.Scripting.ScriptService.Execute(ScriptDefinition script, Dictionary`2 scope, InternalLibraryManager internalLibraryManager, NotificationService notificationService)

at Spotfire.Dxp.Application.Scripting.ScriptManager.c__DisplayClass4.b__3()

at Spotfire.Dxp.Framework.Commands.CommandHistory.Transaction(Executor executor, Boolean visible, Boolean sticky, Guid stickyGuid)

at Spotfire.Dxp.Framework.Commands.CommandHistory.Transaction(String displayName, Executor executor)

at Spotfire.Dxp.Application.Scripting.ManagedScript.Execute(Dictionary`2 environment)

at Spotfire.Dxp.Application.HtmlTextAreaControls.ActionControl.ModifyCore(Object value)

at Spotfire.Dxp.Application.Visuals.HtmlTextArea.InteractWithControl(String id, Action`1 interaction)

 

Could you please help me in this regard.

[Ankit Anand 4]

Hi Harmeet,

Thanks a lot for this script. Unfortunately it doesnt work with Web Player. Do you have a script to make it work for Web Player

Regards

[Brock Meyer DELETE]

Thanks

[Brock Meyer DELETE]

Thank you this is helpful

[Nikhil Kumar 2]

i am also getting same error.

[Shandilya Peddi]

Check if your NodeManager machine has Outlook installed. When triggerring scripts on WebPlayer they are executed on the NodeManager machine. This script references Outlook so it should be installed on the Node Manager machine