Mail Merge with Large File

W

WWalsh

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
 
D

Doug Robbins - Word MVP

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

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

WWalsh

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top