I have set up mail merge documents with the SQL query as the datasource - and
everything is working fine. I have a finicky little question which causes me
grief and if anyone out there can help - I'd be delighted.
When I press the button "Mail Merge Recipients" in the Word document, my
columns represent the fields that are delivered by the query. However - the
ORDER of the columns appears to have NOTHING whatsoever to do with the order
of the fields as created in the SQL query. And manually moving them around -
doesn't help as it doesn't stick (not to mention that it's not a user
friendly window). However - if I click on the button "Insert Merge Field"
that list is in the same order as set up in the query. Go figger! Not the
end of the world - but bugging me. If anyone can enlighten me - I dub thee
"GURU"!
Thanks