Alaska Software Inc. - Using Word for notepad entry and for Mail Merge
Username: Password:
AuthorTopic: Using Word for notepad entry and for Mail Merge
Phil Jackson Using Word for notepad entry and for Mail Merge
on Thu, 11 Dec 2008 09:55:33 +1300
Word already provides spell checking and I wonder if the following is 
possible with ActiveX and xBase

1) Pop up a screen to edit/enter some text using Word - keep controls to 
a minimum. Use native ability to spellcheck / grammar check. Ideally the 
  size of the screen is under my control.
2) Send text to clipboard as required.
3) Or, swap data fields for producing mail merge letters - saved as 
files (DOC or HTML)

I have never used ActiveX but wonder if someone can point me in the 
right direction to get started. I am not averse to paying for someone's 
time if that saves me a great deal more time - if someone is already 
doing the above then that would be very good!

I'm currently using 602Text which probably doesn't handle ActiveX and 
would install Word to get this working as needed.

Cheers

Phil Jackson
AUGE_OHRRe: Using Word for notepad entry and for Mail Merge
on Wed, 10 Dec 2008 22:34:46 +0100
hi,

for ActiveX you can use CreateObject(), GetObject() or XbpActiveXControl().

to have a ActiveX "under Control" you must use XbpActiveXControl() else
you can not "react" on ActiveX (... yes you can :dynamicCast() ... )

i did not have seen any Sample with Word and XbpActiveXControl() yet.

greetings by OHR
Jimmy
Phil Jackson Re: Using Word for notepad entry and for Mail Merge
on Thu, 11 Dec 2008 11:05:18 +1300
Thanks Jimmy

I'll hang out for someone who has some knowledge on this.

If no one has done this before, can someone come back to me with a price 
for the development of this. I will then make it available to the Users 
Group.

Cheers

Phil Jackson

AUGE_OHR wrote:
> hi,
> 
> for ActiveX you can use CreateObject(), GetObject() or XbpActiveXControl().
> 
> to have a ActiveX "under Control" you must use XbpActiveXControl() else
> you can not "react" on ActiveX (... yes you can :dynamicCast() ... )
> 
> i did not have seen any Sample with Word and XbpActiveXControl() yet.
> 
> greetings by OHR
> Jimmy 
> 
>
Mark SergentRe: Using Word for notepad entry and for Mail Merge
on Thu, 11 Dec 2008 09:51:22 -0800
On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote:

> Word already provides spell checking and I wonder if the following is 
> possible with ActiveX and xBase
> 
> 1) Pop up a screen to edit/enter some text using Word - keep controls to 
> a minimum. Use native ability to spellcheck / grammar check. Ideally the 
>   size of the screen is under my control.
> 2) Send text to clipboard as required.
> 3) Or, swap data fields for producing mail merge letters - saved as 
> files (DOC or HTML)
> 
> I have never used ActiveX but wonder if someone can point me in the 
> right direction to get started. I am not averse to paying for someone's 
> time if that saves me a great deal more time - if someone is already 
> doing the above then that would be very good!
> 
> I'm currently using 602Text which probably doesn't handle ActiveX and 
> would install Word to get this working as needed.
> 
> Cheers
> 
> Phil Jackson

Hi Phil,

There is also an activex product called TXText Control that we are using in
our new application. It is a full activex word processor that creates a
number of file formats including office2003/2007 html pdf etc. It has full
mailmerge capabilities and spell checking can be added by a couple of 3rd
party activex controls we are using the wintertree spellchecker. 

We decided to go this way instead of just using word integration because
you are then able to distribute a fully functional (word compatable) word
processor with your application without dealing with office installations
on users workstations etc.

Mark Sergent
InnSource Solutions Inc.
mark@innsourcesolutions.com
Phil Jackson Re: Using Word for notepad entry and for Mail Merge
on Fri, 12 Dec 2008 09:18:13 +1300
Hi Mark

You make a lot of sense! Are there any traps we need to be aware of, 
taking into account that we have no ActiveX experience?

Cheers

Phil Jackson


Mark Sergent wrote:
> On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote:
> 
>> Word already provides spell checking and I wonder if the following is 
>> possible with ActiveX and xBase
>>
>> 1) Pop up a screen to edit/enter some text using Word - keep controls to 
>> a minimum. Use native ability to spellcheck / grammar check. Ideally the 
>>   size of the screen is under my control.
>> 2) Send text to clipboard as required.
>> 3) Or, swap data fields for producing mail merge letters - saved as 
>> files (DOC or HTML)
>>
>> I have never used ActiveX but wonder if someone can point me in the 
>> right direction to get started. I am not averse to paying for someone's 
>> time if that saves me a great deal more time - if someone is already 
>> doing the above then that would be very good!
>>
>> I'm currently using 602Text which probably doesn't handle ActiveX and 
>> would install Word to get this working as needed.
>>
>> Cheers
>>
>> Phil Jackson
> 
> Hi Phil,
> 
> There is also an activex product called TXText Control that we are using in
> our new application. It is a full activex word processor that creates a
> number of file formats including office2003/2007 html pdf etc. It has full
> mailmerge capabilities and spell checking can be added by a couple of 3rd
> party activex controls we are using the wintertree spellchecker. 
> 
> We decided to go this way instead of just using word integration because
> you are then able to distribute a fully functional (word compatable) word
> processor with your application without dealing with office installations
> on users workstations etc.
>
Mark SergentRe: Using Word for notepad entry and for Mail Merge
on Tue, 16 Dec 2008 09:23:34 -0800
On Fri, 12 Dec 2008 09:18:13 +1300, Phil Jackson wrote:

> Hi Mark
> 
> You make a lot of sense! Are there any traps we need to be aware of, 
> taking into account that we have no ActiveX experience?
> 
> Cheers
> 
> Phil Jackson
> 
> 
> Mark Sergent wrote:
>> On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote:
>> 
>>> Word already provides spell checking and I wonder if the following is 
>>> possible with ActiveX and xBase
>>>
>>> 1) Pop up a screen to edit/enter some text using Word - keep controls to 
>>> a minimum. Use native ability to spellcheck / grammar check. Ideally the 
>>>   size of the screen is under my control.
>>> 2) Send text to clipboard as required.
>>> 3) Or, swap data fields for producing mail merge letters - saved as 
>>> files (DOC or HTML)
>>>
>>> I have never used ActiveX but wonder if someone can point me in the 
>>> right direction to get started. I am not averse to paying for someone's 
>>> time if that saves me a great deal more time - if someone is already 
>>> doing the above then that would be very good!
>>>
>>> I'm currently using 602Text which probably doesn't handle ActiveX and 
>>> would install Word to get this working as needed.
>>>
>>> Cheers
>>>
>>> Phil Jackson
>> 
>> Hi Phil,
>> 
>> There is also an activex product called TXText Control that we are using in
>> our new application. It is a full activex word processor that creates a
>> number of file formats including office2003/2007 html pdf etc. It has full
>> mailmerge capabilities and spell checking can be added by a couple of 3rd
>> party activex controls we are using the wintertree spellchecker. 
>> 
>> We decided to go this way instead of just using word integration because
>> you are then able to distribute a fully functional (word compatable) word
>> processor with your application without dealing with office installations
>> on users workstations etc.
>>

Hi Phil,

Sorry for the delay getting back to you. There were a coupld of things we
ran into using the controls. With the following settings on the
xbpactivexcontrol they seem to run well in xbase.

::useGuiThread := .F.
::userEvents := .T.

If you would like come code samples let me know on my private email and i
will put something together for you.

Have a great holiday Season.

Mark Sergent
InnSource Solutions Inc.
mark@innsourcesolutions.com
www.innsourcesolutions.com