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]
|