RE: Microsoft Word and the iSeries

You may be better off opening an excel spreadsheet with the macro Auto_Open 
which you can set the macro up to refresh the data then the mail merge can work 
from there. You could even create a menu option on the AS400 to call the 
spreadsheet on the PC or even create a file 1st from the customer/supplier 
files for good security then open the spreadsheet etc.


Regards
 
Steve Dodkins
 
ebm-papst UK Ltd
 
Tel: 01245468555
 
www.ebmpapst.co.uk
 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] 
On Behalf Of Jerry Adams
Sent: 17 January 2007 14:35
To: Midrange Systems Technical Discussion
Subject: Re: Microsoft Word and the iSeries

I've never done it from an iSeries, but I have done tons of mail merges in 
Word.  Since Word's mail merge involves a template with merge fields and a data 
source (I usually use an Excel spreadsheet, but any kind of db file would 
work), couldn't you create the data source on the iSeries and, then, populate 
the data source in Windows?  I think there are even some open source utilities 
around for creating an Excel spreadsheet from
DB2 files.


If the idea is to create the merged document on the iSeries and, then, to 
export it to Word, that would seem to be a bit harder, though I think I recall 
reading of such tools.  Can't recall the names or leads though.


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst B&W Wholesale Distributors, Inc.* * 
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Jonathan Mason wrote:

Hi List

Has anybody got or read the book "Microsoft Word and the iSeries" by G.
Wayne Hawks?

I have a customer who would like to have their AS400 (and I use the 
name
generally) data incorporated into Word documents.  At a price of $395 
(or
£395 in the UK) I want to be sure that I can achieve what they want 
using the book for guidance before spending that much money.

Are there other alternatives available for getting data into Word?  
Ideally what they would like is to be able to create a template in 
Word and generate a report using the template.

Thanks

Jonathan




  

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To 
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or 
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment 
to review the archives at http://archive.midrange.com/midrange-l.