[Peter Jamieson]

Your best best is probably to create an Excel macro that fixes the data
before the merge. (You'd probably be better off asking about that in an
Excel group, too). However, you /might/ be able to do this in Word by
opening the data source from within Word VBA and using an SQL function that
replaces two CR (or CRLF, or whatever it actually is) characters by a single
one. I don't know in this case whether that is workable, but if you want to
go that route and can't figure out the VBA or the necessary SQL, ask again
and I'll have a closer look. Also, that approach own't work if for other
reasons you have to open the worksheet using DDE (the default in Word 2000
and earlier).

Peter Jamieson
"SteveM" wrote in message
...
To explain further:

The fields from my datasource (an Excel file) are Address, Town, County
etc.
The Address field is multiline and some users have added a carriage return
at the end of the street address info causing a blank line between
Address/Town.

So, I need to trim off this character from the end of the data in this
field
if it is there.

Any ideas?

Steve