Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-01-16
5
Medium Priority
?
1,744 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
Article by: evilrix
Looking for a way to avoid searching through large data sets for data that doesn't exist? A Bloom Filter might be what you need. This data structure is a probabilistic filter that allows you to avoid unnecessary searches when you know the data defin…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

618 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