Help with using catalog and directory in Mail Merge - Word 2010

Hello,

I have a spreadsheet with customer, product and price.  Each customer has multiple rows.  I am trying to use merge fields that will place the customer name at the top of the page, the products and price further down, and then force a new page for the next customer.

I have set up my merge as a directory, and this is the code I am using:

{ If { MERGESEQ } = "1" "{ MERGEFIELD Customer }" ""}<ENTER>
{ SET Place1 { MERGEFIELD Customer }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
----------------------------Page Break--------------------------------
{ MERGEFIELD Customer }<ENTER>
<ENTER>
{ MERGEFIELD Product }{ MERGEFIELD Price }" "{ MERGEFIELD Product }{ MERGEFIELD Price }" }{ SET Place2 { MERGEFIELD Customer }}<ENTER>

When I run the merge, I am not getting the page break when it's a new customer. I am also seeing a carriage return after each product/price that I can't seem to find in my merge document (to delete it).

Any assistance would be much appreciated!!

Tami
tarcher61Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
Debugging complex Word field structures like this can be difficult. In fact all you have done is to put the first <ENTER> in the wrong place. The first two lines should look like this:

{ If { MERGESEQ } = "1" "{ MERGEFIELD Customer }<ENTER>
" ""}{ SET Place1 { MERGEFIELD Customer }}<ENTER>
0
tarcher61Author Commented:
Greetings!

I changed it to match what you suggested, but there still is no page break before a new customer.

Could it be something else?

Thank you!
0
GrahamSkanRetiredCommented:
I tested it with your field names before posting. This is what it looks like in draft view with field codes displayed:Picture of field codes in draft mode view
I have also attached the document itself
OneToMany.docx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tarcher61Author Commented:
You are AWESOME!!  It's working perfectly - can't thank you enough!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.