Directory and merge from Excel
I am using Excel 07 and Word 07.
I am trying to merge the data in .csv form into Word. I am doing this using
the mail merge feature and selecting 'directory'.
I match the fields and place them in the document and then use the rule of
'next record' in hopes that it will keep placing the records with the same
format as the first. When I click preview I only see the first record and
when I do a 'finish and merge' Word locks up. There are 1755 records.
I amd doing this on the first line of the page:
«LastName», «FirstName» & «Spouse»
«Address1», «Address2», «City», «State», «ZIPCode» «HomePhone»
«Children»
«Next Record»
«Next Record»
«Next Record»
In return I only receive the first record
A., Kristopher & Cyndi
1022 Ae, , Indianapolis, IN, 46227 ### ### ####
Ceer
thoughts?
|