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?

Reply | Quote

Replies

This happens when your Field names cannot be found by Word. When using an Excel file as a Data Source, the field names MUST be in the first row of the the Spreadsheet and there can be no blank rows between the field names and the actual data. Correct your Excel list, save and then try the merge again.

Reply | Quote

Thanks guys,
I already had the Field names/Header Row in the first column, and the data snugged up tight like it should be, so I’m still not sure what was going on there. BAM, the AutoFilter is awesome, and selecting it from the merge did allow me to access the fields on the first worksheet, but not the others. Now Geof’s post, “Word DataSource Not First sheet in Workbook” is catching my eye. Are we only allowed to merge fields from one worksheet at a time?
(BTW, can someone tell me how you insert links to other posts in these things?)
Thanks again for the help.

Reply | Quote

Hi, Mark! Item 17 in HELP provides details on using the URL tags. Good luck!

Reply | Quote

On second thought, I think I hate it.

You were right, selecting _FilterDatabase from the Word doc gave me access to all the fields as mergesources, and it was kind of cool to have combo boxes available for each field, but my file size has ballooned and the thing now takes about a minute to save.

My list has 2000 records, 10 source fields and about 15 calculated fields. I remember Charlotte talking about Indexes in the Access Forum and saying that too many of them could slow a database down. Does Autofilter create an index for each of my fields?

And most importantly, how do I turn the thing off? (I finally just put the fields I want to merge on the first worksheet)
Thanks again,
Mark

Reply | Quote

Then again, I could try decaff..
A brief experiment showed that the file size ballooned because I had added calculated fields, and the primary reason for long saves was cuz it was over the network. Sorry about the hysterics….
Mark

Reply | Quote