Data Merge HELP

[Barry_Re...@adobeforums.com]

I am creating a business card template and plan to merge data from an excel file. I have it working except for one issue. The card template has 4 fields in the lower left corner. These fields have tags or captions for the data that will go there:

Phone:
Fax:
Cell:
Email:

There are corresponding columns in the excel files for each field. My problem is that when I merge the data, if a person doesn't have one of these data fields on their card (say, Cell phone for example) and I have selected REMOVE BLANK LINES FOR EMPTY FIELDS, it will not do this because of the tags for those fields.

It should come in as:
Phone: 888-444-5555
Fax: 888-999-7777
Email: j...@abc.com

But it is coming in as:
Phone: 888-444-5555
Fax: 888-999-7777
Cell:
Email: j...@abc.com

How do I delete the tag or caption and have the line space close up?

THANKS!

[Bob Bringhurst]

I'm pretty sure the problem is that you added a space after "Cell:" so InDesign didn't remove that line because it has a character on it. If you edit the data source to include the space ("Cell: "), the line should be deleted when "Remove Blank Lines for Empty Fields" is selected.