[eggedd2k]

I'm having some problems getting the address part of the data source
to display correctly. I'm merging from an SQL data source/query.

In particular the County and Country parts are showing as blank lines
if the corresponding field is empty. Some
clients in our database do not have anything in the County or Country
fields and therefore I need these fields to
supress if they are blank - and instead display the PostCode line
instead - rather than showing as a blank line.

The fields codes are shown as below.

Can anyone show me how I need to format the County and Country fields
so that they don't display if they are empty BUT ensure that they
don't leave blank lines?

thanks very much

Field Codes:

{MERGEFIELD SEND_TO \*MERGEFORMAT}
{MERGEFIELD CLIENT_NAME \*MERGEFORMAT}
{MERGEFIELD ADDRESSDETAIL \*MERGEFORMAT}
{MERGEFIELD CITY \*MERGEFORMAT}
{MERGEFIELD COUNTY \*MERGEFORMAT}
{MERGEFIELD COUNTRY \*MERGEFORMAT}
{MERGEFIELD POSTCODE \*MERGEFORMAT}




Fields:

Send_To
Client_Name
AddressDetail
City
County
Country
PostCode