How to only merge fields with data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lewis0205NC - 11 Oct 2006 19:26 GMT

When I go to edit individual files, sometimes the mail merge creates a whole
bunch of extra merges at the end but because the data file only had x amount
of rows of data, the extra merges are blank. How can I make sure that only
the fields with data end up in the final merge files?

Reply to this Message

Doug Robbins - Word MVP - 11 Oct 2006 20:04 GMT

What is the data source? I guess it is probably Excel and you may have some
spaces in some of the cells below the data. Select all of the rows below
the data (I mean all) and press delete to delete whatever it is that might
be in any of the cells.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When I go to edit individual files, sometimes the mail merge creates a
> whole
[quoted text clipped - 3 lines]
> only
> the fields with data end up in the final merge files?

Reply to this Message

Lewis0205NC - 11 Oct 2006 20:20 GMT

Yes, it did work. Out of curiosity, how could there have been data in those
cells?

> What is the data source? I guess it is probably Excel and you may have some
> spaces in some of the cells below the data. Select all of the rows below
[quoted text clipped - 8 lines]
> > only
> > the fields with data end up in the final merge files?

Reply to this Message

Doug Robbins - Word MVP - 12 Oct 2006 04:37 GMT

It could have been just a space in one of them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Yes, it did work. Out of curiosity, how could there have been data in
> those
[quoted text clipped - 14 lines]
>> > only
>> > the fields with data end up in the final merge files?

Reply to this Message