Mail Merge with Large File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WWalsh - 21 Aug 2006 21:01 GMT

Hope someone out there can help - I have a very large file that I need to use
for a mail merge. It resides on an IBM AS/400. There are many more than 255
columns/fields in the file, and I've been trying to download this into Excel,
Access, even directly into Word's mail merge, but keep maxing out because of
the columns. Breaking the file up into smaller files and trying to use joins
hasn't worked either. Short of reducing my file to only 255 fields, does
anyone have any suggestions on how I can do this?

Thanks in advance,
WWalsh

Reply to this Message

Doug Robbins - Word MVP - 22 Aug 2006 04:31 GMT

Download the data as a comma delimited text file and use that as the data
source for the mail merge.

Or use Excel 2007 from which the 255 column limit has been removed

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hope someone out there can help - I have a very large file that I need to
> use
[quoted text clipped - 11 lines]
> Thanks in advance,
> WWalsh

Reply to this Message

WWalsh - 22 Aug 2006 20:24 GMT

Thank you - are there any limitations to the file and/or record size that I
can download and use as a data source?

> Download the data as a comma delimited text file and use that as the data
> source for the mail merge.
[quoted text clipped - 16 lines]
> > Thanks in advance,
> > WWalsh

Reply to this Message