Im using an Excel 2000 spreadsheet as a mail merge source in Word 2000.
Ive defined the range of cells to be included in the merge and specified it
as the data source. There are four columns formatted as general that are
used in the Filter Records query dialog (and Ive also tried reformatting as
text and as date). There are actual dates as well as the €œdate€� of 09/--/05.
The query dialog is:
F1Date equal to 09/--/05
Or F2Date equal to 09/--/05
Or F3Date equal to 09/--/05
Or F4Date equal to 09/--/05

The merge only returns the records from columns F2Date through F4Date, not
any records from column F1Date that should be included. If I copy the
09/--/05 from the F1Date cells and paste it into records in the F4Date cells,
the records are returned. Ive copied the data to a new worksheet, inserted
a new column and pasted the data from F1Date into it, renamed it, reformatted
it, done everything I can think of but cant figure out why this doesnt
work. Any help will be greatly appreciated.
--
Kroggie