Merge - Excel data to Word labels

  • Thread starter Thread starter Kathy Saleeba
  • Start date Start date
K

Kathy Saleeba

I'm puzzled. I'm doing a mail merge in Word with an Excel
document as my data source. My Excel document has only
one page (tab) of data, with nearly 400 lines of data.
When I reach the part of my mail merge using the Word
Wizard (I don't care for wizards - would rather do it
myself!) I have a choice of 3 Excel "pages" to choose
from:
kpa_address_list
kpa_address_list$
kpa_address_list_

I chose the first one, but all the data did not merge
(left about 100 lines of data out). When I tried to do
it with the second name in the list kpa_address_list$ all
the data successfully merged.

Can someone please tell me the differences in these name
files? Thank you.

(e-mail address removed)
 
Is the file named the same as one of the examples you posted? Do you have a
label at the top of the data? You (or Word) need a label. Are there blanks
in you XL table? If so, the wizard may interpret the blank as the end of the
data.
 
Back
Top