• Subject: Re: Office/400 Document Conversion
  • From: Pete Massiello <PMassiello@xxxxxxxxxxxxxxxx>
  • Date: Sun, 05 Oct 1997 12:15:18 -0700
  • Organization: OS Solutions

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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.