Re: Running up against the limit in Excel 2003

I find it hard to imagine a mail merge that needs that many fields.
However, if you do need to exceed the 255 column limit of Excel, you can use
a .csv file as the data source.

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

"AndyC812" <AndyC812@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1808876D-FA3E-44E2-A32B-1BACF35BF17D@xxxxxxxxxxxxxxxx
I have created an application in Excel that collects data for eventual
merging into a Word mail merge document. It is so large that I am running
out of columns in Excel for new merge fields (I am using 250 of possible
255). My question - is there a better way to get my data fields from
Excel
into Word (CSV file, XML?) ? Can this be automated?

Any tips would be appreciated!

Thanks!
Andy


.

Relevant Pages

  • Re: Word 2003 Mail Merge cannot open Excel 2003 document
    ... I redid it and saved as a csv file again and it worked! ... "Peter Jamieson" wrote: ... creating a very simple data source in Excel and see if that works OK. ...
    (microsoft.public.word.docmanagement)
  • Re: How to set up a pivot table from a csv file
    ... You could connect to the csv file, but the steps are different in Excel 2007 and earlier versions of Excel. ... Select External Data source, and click Next ... In the Query Wizard, select your fields, and click Next 3 times, to get to the end of the Wizard, click Finish ...
    (microsoft.public.excel.misc)
  • Re: Run out of columns
    ... As far as I know the current limit in Excel is 256 columns. ... as a data source in Word 2003, the open will probably succeed, but you will ... > I am using word to merge data from an excel sheet - but I have run out of ... > I thought a csv file of the data would not have a column limit, ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Exporting data from word form to excel: Maximum number of fields?
    ... There is a 256 column limit in Excel 2003. ... a database such as SQL or Oracle (MS Access database would not help since ... As far as a more elegant way to collect data, ...
    (microsoft.public.word.vba.general)
  • Re: can I export WAB to print labels
    ... Export the WAB to a CSV file. ... Open in Excel. ... use that as your data source for label printing.... ...
    (microsoft.public.word.newusers)