Mail Merge Problem (excel/word)

[RVStevenson]

We have multiple mail merge documents that use the same excel spredsheet. The mail merge documents have been funtioning untill today. For some reason, when we attempt a merge we recieve an error "Invalid Merge Field" for each field in the word document. We have re-opened the data source through the mail merge wizard, tried opening the source for data and header seperately, and many other things. The list of available merge fields are labeled with labels in the spreadsheet but are listed as AutoMergeFieldXX in the field list in the word document. Opening the header source corrects this problem however it still says invalid merge field when the merge is attempted... The documents merge fine when other data sources were used. Any suggestions??

Thanks..

Ryan Stevenson Thanks,

Ryan V. Stevenson
Consumer Options - Managed Money - NSN

 

[Guest_imported]

Have you tried resetting the merge document as a normal word document then saving it and then re-associating it with your Excel worksheet?

 

[RVStevenson]

I wish it were that easy... This is affecting all of my form letters, not just one of them..... Thanks,

Ryan V. Stevenson
Consumer Options - Managed Money - NSN
RVStevenson@ameritech.net