Re: Office/400 Document Conversion

Don wrote:
> 
> Let me take this a step further...
> 
> We've got a client that's made the transition from OV/400 to
> Wordperfect...  Now the hitch...they want to be able to import via ODBC
> fields direct from the PF/LF's on the 400 into their documents...  I've
> not been able to find anyone that knows how to do this...  ANy ideas?? CAN
> it be done??
> 
Don,

   We do this all the time, although it is a 2 step process.  On the PC
we create an Excell spread sheet that receives external data via ODBC. 
This inturns automatically runs  Microsoft Query on the PC that defines
which records we want loaded into the file.  Once this is done we save
it.  From that point on, all you do is open the spreadsheet and go to
the DATA option and select refresh data.  It will then go to the AS/400
and update the records in the spread sheet.  We then open a Mail merge
Word document (which I am sure you can do in Word perfect), and it
automatically fills in the information. 

 I know that the ladies in Marketing run this every day to send out
mailings to everyone that they have talked to that day.

HTH


-- 
Pete Massiello
OS Solutions International 
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---