Mailmerge: remove blank lines created by carriage return in datas.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveM - 26 Jun 2007 12:43 GMT

I want to print some mailing labels but I have blank lines in the address
fields that are created from carriage returns in the datasource.

How do I stop these blank lines displaying on my labels?

Reply to this Message

SteveM - 26 Jun 2007 14:41 GMT

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

Reply to this Message

Peter Jamieson - 26 Jun 2007 18:02 GMT

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

> To explain further:
>
[quoted text clipped - 11 lines]
>
> Steve

Reply to this Message

SteveM - 26 Jun 2007 18:16 GMT

Thanks for the reply Peter.

The Excel worksheet was created from a query in Access. I solved the problem
by modifying the query to detect Chr(13) & Chr(10) at the end of the data and
return only the data portion of the field prior to their occurrence.

Steve

> 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
[quoted text clipped - 23 lines]
> >
> > Steve

Reply to this Message