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]

Thanks again, Paul.

The truncated addresses problem was my fault! As it was only a test I had not filled the table in Access with the complete information! Sorry.

As far as the currency issue is concerned, the cells in the form are not filled with merged data, the idea is that the recipient of the form will enter figures and send the form back to the Treasurer. When I select the cell and press Shift - F9 nothing happens. Is there some other way to make these cells appear as currency when someone enters a figure?

Any more thoughts on the hyperlink problem?