AutomergeField???? Where are my variable names?

Topic

New Reply

Hello,
I’m running a mail merge in WD2K pulling List data from Excel2K. When I use the insert Mergefield dropdown list, it only shows AutomergeField and AutomergeField1. It was previously listing my actual fieldnames, so I’m guessing I somehow goofed up on the Insert Name process when I defined the Headernames as dynamic ranges using Insert Name Define.
I’ve since taken that out and renamed the column labels the old way, but no use. Any ideas?

I’ve X-posted this in the Word Forum

Reply | Quote

Replies

Mark, I would try and attach the merge again, by clicking on the Merge Helper in Word and opening the source document again. This should work through and find the correct range of cells.

Reply | Quote

Thanks Mike, but no joy. Heres a new wrinkle-I finally just copied the new labels and ranges into an older workbook that wasn’t having any merge problems, inserting a new worksheet on which to past them. Now Word will show the new labels (in this case being used as a header for field names) but doesn’t show any that are still on the previous worksheet (which I did however, rename). This is my first Excel project, so I hope I’m not being glaringly stupid.

Reply | Quote