View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
srpd srpd is offline
external usenet poster
 
Posts: 17
Default 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?