Solved

Creating a MS Outlook 2010 mail message from Powerbuilder only works when Outlook is closed

Posted on 2013-01-16
5
1,664 Views
Last Modified: 2016-10-26
Hi
I am using Powerbuilder 11.5 and have updated the code to handle MS Outlook 2010.

The code used to work fine with earlier versions of Outlook and allowed the user to send emails from Powerbuilder with either Outlook running or not running, but does not work now since the Outlook version change when Outlook is running.  The code works fine when Outlook is not running.

updated version not working when Outlook open
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Outlook\InstallRoot

previous working version of Outlook
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\Outlook\InstallRoot


The code is as follows;

//Declaration
OLEObject myoleobject, db, doc, rt_item, loo_ol_msg_cast

myoleobject = CREATE OLEObject
//  loop for two minutes, or until notes is started successfully
t_StartTime=Now() //wait 2 min for Notes to load ...
Do
	Yield()	//yeld control occasionally
	SetPointer(hourglass!)
	iResult = myoleobject.ConnectToNewObject("outlook.application")	
	If iResult = 0 Then Exit	//OK, Outlook is active
	Yield()
Loop Until SecondsAfter(t_Starttime, now()) > 120	//try again in #sec

if iResult <> 0 then
	f_user_error("Could not open Microsoft Outlook")
	return FALSE
end if

loo_ol_msg_cast = myoleobject.CreateItem(0)

Open in new window


The code fails on the above line (CreateItem) when MSOutlook is running
This works fine when MSOutlook is closed - the mail is generated and sent

I cannot find what is needed to allow a new mail to be generated when MS Outlook is open - I would be really grateful for any assistance - thanks Wingmanshaks
0
Comment
Question by:wingmanshaks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
virtuadept earned 500 total points
ID: 38794034
Hm. That looks like correct syntax for OLE integration. I tried an example that was very similar and it worked, PB 11.5 and Outlook 2010.  Maybe it is something messed up in the registry?

What error is it giving back?


http://downloads.sybase.com/codexchange/powerbuilder/404/PowerBuilder_-_Controlling_the_Outlook_session_using_OLE.htm
0
 
LVL 8

Expert Comment

by:virtuadept
ID: 38864030
Just checking if that previous answer was helpful or not?
0
 

Expert Comment

by:Carson LuzHoxsie
ID: 41860508
Use the following if Outlook is not running.
myoleobject.ConnectToNewObject("outlook.application")

If Outlook is already running, use
myoleobject.ConnectToObject("outlook.application")

Normally, check if Outlook is running first using ConnectToObject("outlook.application"), if not, use ConnectToNewObject("outlook.application") to start it.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Find out what you should include to make the best professional email signature for your organization.
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question