Re: Win32:OLE and Word Mail Merge

No way to do it? Sounds like a challenge :-). I can think of a couple of ways. I have had luck doing automated delimited parsing using the VBA macros in Word and Excel. Then you could automate the macro from Win32:OLE. Have you tried just sending the necessary keystrokes with Win32::CtrlGUI ? I have never tried this, and it seems kind of a kludge, but it might do the trick if there isn't other window activity going at the same time. drinkd

Comment on Re: Win32:OLE and Word Mail Merge

Replies are listed 'Best First'.
Re: Re: Win32:OLE and Word Mail Merge by Gerard (Pilgrim) on Oct 17, 2001 at 11:30 UTC
In reply to the above two... I had thought of using Win32::CtrlGUI but haven't done so before. (Not that that is any reason not to) I just thought that it was quite likely to get rather ugly. Thanks for your information, I also found the same / similar information last night and this is actually what led me to my conclusion. Bearing in mind that I am new to all this... Anyway I can change the format to standard csv and this works fine... just not ideal for what I wanted. I would be interested in any solutions where I can use my existing delimiters \| and ~ .	[reply]

Replies are listed 'Best First'.

Re: Re: Win32:OLE and Word Mail Merge
by Gerard (Pilgrim) on Oct 17, 2001 at 11:30 UTC

In reply to the above two... I had thought of using Win32::CtrlGUI but haven't done so before. (Not that that is any reason not to) I just thought that it was quite likely to get rather ugly. Thanks for your information, I also found the same / similar information last night and this is actually what led me to my conclusion. Bearing in mind that I am new to all this... Anyway I can change the format to standard csv and this works fine... just not ideal for what I wanted. I would be interested in any solutions where I can use my existing delimiters | and ~ .

[reply]