I keep messing up configuring Mail Merge which I seem to find the absolutely most difficult piece of Microsoftware to figure out -- which is saying something!
I have a merge document that I somehow figured out how to create once upon a time. I want to change the data source. I go to Tools > Letters and Mailings > Mail Merge, run through the wizard and end up with a merged document of the 1st row only of my merge data file. When I save the document, my original apparently get clobbered because when I pull it back up my merge fields are gone and the 1st data row is merged, regardless of how I answer the "Opening this document will run the following SQL command". If I change the data source contents, I still get the old 1st record in when I open the doc, new contents are ignored.
Once again, I CANNOT seem to figure out how to change the merge datasource without destroying the merge fields.
I would appreciate help ... AGAIN! This time I'll write down the proecedure!