View Single Post
 
Old 05-28-2012, 07:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Baldeagle,

I can't see anything in the files that would account for data truncation. Perhaps you should re-check the data source - it may be incomplete or corrupt. What happens if you do, say, a directory or label merge for all records? Do they still get truncated?

As for the currency, simply add a numeric picture switch to the relevant fields. To do this:
• select the field;
• press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
• edit the field so that you get {MERGEFIELD MyData \# £,0.00};
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote