Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 a Word table and text followed by a list of Excel data (Field 1,2,3,4, double space, Field 1,2,3,4, €¦) However, the result I keep getting is a repeat of the Word table and text prior to each set of merged fields. Ive tried using the €śNext Record€ť field after the double space, 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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Catalog merge from Excel; $ formatting
Peter Jamieson has answered your repetition question. For the $ formatting
issue, see "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at : http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "srpd" wrote in message ... I'm trying to merge data from Excel into a Word doc using the catalog merge option. The end result should be a Word table and text followed by a list of Excel data (Field 1,2,3,4, double space, Field 1,2,3,4, .) However, the result I keep getting is a repeat of the Word table and text prior to each set of merged fields. I've tried using the "Next Record" field after the double space, but there is no difference in the result. There are no breaks of any kind in the document. I've 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge a catalog | Mailmerge | |||
merge a catalog | Mailmerge | |||
Merge from excel loses formatting | Mailmerge | |||
Merge catalog | Mailmerge | |||
formatting columns in a catalog | Mailmerge |