Tech Articles


Reading MS Outlook Items


Here is some code which reads data from Outlook (2007 was tested) into Powerbuilder. You basically need to create a window with a multiline edit and a button on it. Put this into the clicked event of the button.

To run it, open Outlook, select something (email message, task, etc.) then click the button on your PB window. There are many, many more methods and properties you have access to from PB via OLE to Outlook. The MSDN reference online is a big help

integer li_rc
long ll_itemcount, ll_i
oleobject lole_item, lole_outlook, lole_exp, lole_selecteditems
string ls_subject, ls_from, ls_to, ls_body, ls_msg
lole_outlook = CREATE oleobject
lole_exp = CREATE oleobject
lole_selecteditems = CREATE oleobject
li_rc = lole_outlook.ConnectToNewObject("outlook.application")
lole_exp = lole_outlook.ActiveExplorer()
// Outlook has to be running
If IsNull(lole_exp) THEN
    Messagebox('Outlook Error','Is Outlook currently running?')
    GOTO cleanup
END IF
li_rc = lole_exp.class
// caption is window name like "Inbox - Microsoft Outlook" or "Calendar - Microsoft Outlook"
ls_subject = lole_exp.caption

lole_selecteditems = lole_exp.selection
ll_itemcount = lole_selecteditems.count
FOR ll_i = 1 to ll_itemcount
    lole_item = CREATE oleobject
    lole_item = lole_exp.selection.item(ll_i)
    li_rc = lole_item.class
    CHOOSE CASE li_rc
        CASE 26 //appointment
            ls_body = lole_item.body
            ls_msg += '~r~n Appointment No: ' + string(ll_i) + ' of ' + string(ll_itemcount) + '~r~n' + ls_body
            // lots of other stuff could be here
        CASE 40 // contact
            ls_body = lole_item.body
            ls_msg += '~r~n Contact No: ' + string(ll_i) + ' of ' + string(ll_itemcount) + '~r~n' + ls_body
            
        CASE 43 // mail
            ls_subject = lole_item.subject
            ls_from = lole_item.sendername
            ls_to = lole_item.to
            ls_body = lole_item.body
            ls_msg = '~r~nSubject: ' + ls_subject + '~r~nFrom: ' + ls_from + '~r~nTo: ' + ls_to + '~r~nBody: ' + ls_body
            ls_msg += '~r~n Email No: ' + string(ll_i) + ' of ' + string(ll_itemcount) + '~r~n' + ls_msg
            
        CASE 48 // task
            ls_subject = lole_item.subject
            ls_to = lole_item.owner
            ls_body = lole_item.body
            ls_msg = '~r~nSubject: ' + ls_subject + '~r~nOwner: ' + ls_to + '~r~nBody: ' + ls_body
            ls_msg += '~r~n Task No: ' + string(ll_i) + ' of ' + string(ll_itemcount) + '~r~n' + ls_msg
            
    END CHOOSE
    DESTROY lole_item
NEXT
IF Len(ls_msg) > 0 THEN
    mle_1.text = ls_msg
ELSE
    mle_1.text = 'No items processed.'
END IF
cleanup:
DESTROY lole_selecteditems
DESTROY lole_exp
DESTROY lole_outlook
Comments (1)
Thursday, Apr 20 2017

If you also want to do anything that changes anything in more recent versions of Outlook (like create emails, as one of my programs does) you will run into the problem where Outlook prompts you to allow an external program to make changes, for X minutes. Very annoying. The solution is to use the Outlook Redemption object instead, from <a href="http://www.dimastr.com/redemption">http://www.dimastr.com/redemption.<;/a> It's a free library that duplicates most of the Outlook OLE API, but uses a lower-level API to do the actual work, eliminating that security prompt.

#3
0

Find Articles by Tag

Database Table Data SDK PFC Data Jenkins Text OLE Export JSON DataType .NET Std Framework RibbonBar DragDrop Encoding Array Script Event Handler Database Table Schema .NET Assembly Linux OS PostgreSQL REST TFS Resize Messagging UI Repository Error API COM Visual Studio Graph Debugger Source Code Charts 64-bit RibbonBar Builder Deployment OrcaScript SOAP PDF iOS Open Source Icon Interface Validation Database Table DataWindow UI Modernization PostgreSQL ODBC driver Automated Testing SVN Menu OAuth 2.0 Service SQL Server Filter Git Database Painter Syntax PowerServer Web UI Themes Web API Variable CrypterObject Testing Windows OS WinAPI CoderObject PowerBuilder (Appeon) Installation Window Elevate Conference TLS/SSL Authorization Platform SqlModelMapper Migration Performance External Functions DataWindow JSON InfoMaker Oracle RESTClient PowerServer Mobile Mobile Azure ActiveX Import JSON Outlook Class XML Database Object 32-bit IDE .NET DataStore Windows 10 Icons GhostScript Android MessageBox Database Connection PowerScript (PS) BLOB WebBrowser Web Service Proxy PowerBuilder Compiler PDFlib JSON Authentication Debugging Application Encryption Excel OAuth TreeView Sort Source Control JSONParser JSONGenerator Stored Procedure Design File License Transaction TortoiseGit Event Handling C# HTTPClient ODBC Database Profile Bug Event Import Trial NativePDF Configuration Debug SnapObjects CI/CD PBNI SnapDevelop Branch & Merge Export PowerBuilder DevOps Database Model DLL SqlExecutor PBDOM RichTextEdit Control Expression SQL PBVM