certainly. I suspect that Excel files are the most used data source for
Word MailMerges.
As close to a real DB table: first row contains the cell headings, each
subsequent row a full dataset. No empty lines (i.e., if your Excel file
contains 100 datasets, it has 1 (title) + 100 rows, and everything after
row 101 is empty).
Only your specific requirements dictate exactly how many columns you need.
In addition to Robert's comments I would
a. avoid mixing data types in the same column
b. make sure that Word handles special values such as blanks in date or
numeric columns the way you expect. There's a page at http://tips.pjmsn.me.uk/t0003.htm that describes the background to this.
c. not use more than 255/256 columns - Excel 2007 allows more, but Word
Mail Merge cannot use them.
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.
