Several of us use Excel as the data source, but when we connect to the
spreadsheet, in the Mail Merge recipients box Word displays the columns in
the wrong order. For example:
Spreadsheet column order is: Last Name, First Name, Address1, Address2,City,
State, Zip
WORD displays this as: Address2,City, State,Zip, Last Name, First Name,
Address1

All the data is displayed, but if you want to select only certain people on
the spreadsheet you have to scroll over on each record to find the right name
and select it.

Word will still place the data in the correct field, the problem only seems
to exist in the Mail Merge Recipients box. HELP