Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

trying to do a mail merge from an AS/400

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jp - 08 Dec 2003 16:08 GMT
We are trying to set up a mail merge from an AS/400.  The 400 can export
stuff into an access database...

is there a better way to get info into a mail merge?
Peter Jamieson - 09 Dec 2003 11:41 GMT
I don't have an AS400 here so can only give you a couple of pointers. You
may find that you already have a Windows ODBC driver or OLEDB provider that
is designed to get data from AS400's file system, or you may be able to get
one from IBM. Of these, Word 97/2000 can only use ODBC - to use it, you
would need to set up an ODBC "data source name" on each name using the ODBC
administrator in WIndows Control Panel, then from Word's Open Data Source
dialog box, use the MS Query button to define the queries you need. If you
are using Word 2002/2003 there are several possible methods - the MS Query
option is on the Tools menu in the Select Data Source dialog. However, you
may face problems getting this to work.

However, if you do have the AS400 ODBC driver, you may be able to use a
slightly different route, i.e. rather than exporting data to Access, use
Access to set up a table that is linked to the AS400 data. Then try
connecting to that table ffrom Word (you may need to use a specific type of
connection to do it).

--
Peter Jamieson - Word MVP

> We are trying to set up a mail merge from an AS/400.  The 400 can export
> stuff into an access database...
>
> is there a better way to get info into a mail merge?
Frank Tolstyka - 09 Dec 2003 13:23 GMT
What I do is to set up the ODBC data source using the driver from i-series
access for windows. Then use MS query to select you file and fields. Then
use the mail merge in word using the query as the data source. HTH

> We are trying to set up a mail merge from an AS/400.  The 400 can export
> stuff into an access database...
>
> is there a better way to get info into a mail merge?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.