A simple annoying problem that I cannot find a solution to. I am running a Mailmerge using an Access 2010 query as the record source. I want to select a random group of records manually from the list - no problems. However the field list is mixed up in Word and does not match the order in the query.
So the Query will return the records in this order: Field1, Field2, Field3, Field4, Field5, Field6
Word Displays them as Record_Source, Field2, Field6, Field3, Field4, Field1, Field5
I can drag the fields to the order I want but when I next open the merge document it again uses it's own order. Where is it getting this order from and how can I set it to either match the Access Query order or match an order that I create.
All help gratefully appreciated.