Mr. Jamieson,
Are your separate databases in separate workbooks, or are they in the
same workbook but in different worksheets?
Yes, my data is in separate excel spreadsheets.
Does each database have the same column names and sequence of columns
/in the data source/ ?
Yes, each file is exactly the same, except for the information under
the headers. In actuality, I have a header row for which each of that
row's cell's column contains information from the spreadsheet. For
example:
Row 1 = "1"....."98"
Row 2 = B8....B98
Col A = Header column for col B
It is done this way so that the word document says F1 instead of
Client Name .. can't say I like it, but that's the way chain of
command works around here. I'm told to do something and I have to do
it whether I like the way it is done or not
.
What sequence of records do you need in your output document (i.e. do
you need the first record from each data source, followed by the second
record from each data source, etc. When one data source runs out of
records, do you any kind of placeholder or do you just want to continue
with the next available record?
Each spreadsheet has the data for each client, however, in the Word
document, we need to combine the information into one. Ideally, it
needs to handle X amount of input and it needs to be in the format
from my last posting. I'm not sure what you mean by my data source
running out of records because the mergefield wouldn't be there if
there wasn't going to be information to put in it, but I guess if for
some reason the cell was erroneously empty, an error message should
appear. However, I guess in some cases, there would be an instance
when there was no information given to us about the cell's required
information. In this case, it should either be skipped, or if it is
purposely empty, it usually means that a whole section of the word
document should be eliminated.