Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Next Record in Word mail merge not working

Status
Not open for further replies.

itfellow

MIS
Jan 6, 2004
130
US
Hi all,

I am working in Word 2003, sp2.

I am doing a mail merge from a text file that contains comma-separated fields. I only need four fields from each row, and I'd like to get as many row on a single page of the Word doc as possible (the text file contains hundreds of rows).

So, I inserted the merge fields which correspond to the text file, then inserted the "next record" code a number of times. However, when I merge to a new doc, I only get 1 record per page. It gives me as many of the rows as I ask for, but will not put them on the same page. It seems to be ignoring the next record code, and I can't seem to figure out why.

Any suggestions?
 



Hi,

Please toggle to make the MergeCodes visible and COPY your sheet and PASTE it here.

Skip,

[glasses] [red][/red]
[tongue]
 
OK, here's what it looks like (with the header):

Landlord ID Landlord Tenant Staff
«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»
«Next Record»
«Next Record»
«Next Record»
«Next Record»
«Next Record»
 




You need MergeFields after each NextRecord
[tt]
Landlord ID Landlord Tenant Staff
«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned»
«Next Record»«LANDLORD_ID» «LL_Corr_Name» «First_Name» «Last_Name» «Staff_Assigned» [/tt]


Skip,

[glasses] [red][/red]
[tongue]
 
Ack, I knew it was something simple! Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top