Catalog merge from Excel; $ formatting
 

Im trying to merge data from Excel into a Word doc using the catalog merge
option. The end result should be Word text followed by a Word table populated
by Excel data.

However, the result I keep getting is a repeat of the Word text and a
one-row table of Excel data. Ive tried using the €œNext Record€� field after
the last field, but there is no difference in the result. There are no
breaks of any kind in the document.

Ive not had a problem doing this before. What am I doing wrong?

And, the $ looses the formatting in the merge and comes through as 300000
instead of $300,000. How can I adjust this?