Need help mail merge from excel to word spreadsheet!

[albert3167]

I created a spreadsheet in Word and did a datalink to excel. Then insert my mail merge fields. What is happening is that its merging one page per excel row. I need each row (excel data) to fill in each row (word data). I don't think I set it up correctly. SOME HELP!

 

[SkipVought]

In the mail Merge setup, you can select Catalog or Mailing Lables.

Also, if you Toggle the display of codes, you'll see where the [NEXT RECORD] control gets inserted.

You'll need to "play around" with it to get it to work the way you want.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[albert3167]

I inserted a next record on the next row in word, used Directory when doing he merge and still have the same problem. AHHHHHHHH!!! HELP

 

[albert3167]

OH....can't figure out how to view (NEXT RECORD) codes?

 

[SkipVought]

You alos need Field Codes for each filed that you want in each cell of your table

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[albert3167]

I GOT IT WORKING! THANKS SKIP! YOUR THE BEST!