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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail Merge - Not moving to next record

Status
Not open for further replies.

JackGat

Technical User
Dec 28, 2009
15
US
Hi
I need some help.
I am trying to do a mail merge of a place card template. The template is a word document called place_cards. See attachment.

There are 20 records however only record one appears after the merge. The merge isn't moving to the next record in the file. What am I doing wrong?
Any help would be appreicated? Thanks!

Links to files:


 


After the FIRST set of fields for the FIRST RECORD, you need a {NEXT RECORD} command. Insert it BEFORE the MergeField.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Hi SkipVought

I tried insert the next merge record after the merge field but the 1st record still appears. Is my template the problem? Thanks!
 


In your word doc...
[tt]
«FirstName» «LastName»

«Next Record»«FirstName» «LastName»

....
[/tt]
When you PREVIEW, you see
[tt]
Jennifer Bayles

Tim Johnson
....
[/tt]


Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Hi

Thanks for the information. I tried it placing the next record in the template and I got the 2nd record for every merged record. The 2nd record just repeated everywhere.


My word template has the text aligned vertically rather than horizontal. Plus the template is a custom. It's not a standard template from Word.Is that causing the problem?
 



Try reconnecting your source workbook. This DOES work!

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top