mail merge when not all fields populated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cwr - 19 Apr 2005 19:19 GMT

I did a mail merge from an excel spreadsheet.
Had first name, middle name and last name.
Not all of the entries had a middle name, so there was an
extra space between first name and last name.
Is there any way to set it up so that if the entries that have
no middle name have only one space between first name and middle name?

Thanks

Reply to this Message

GTS - 19 Apr 2005 22:16 GMT

> I did a mail merge from an excel spreadsheet.
> Had first name, middle name and last name.
[quoted text clipped - 4 lines]
>
> Thanks

You could use an IF statement for the midde name:
{ MERGEFIELD "FORENAME" }{ IF MERGEFIELD MIDDLENAME <> "" " {MERGEFIELD
MIDDLENAME" } { MERGEFIELD "SURNAME" }
There is a space before the middle name that will only show if there is a
middle name - I'm sure there must be an easier way but can't think how :-)
Graham

Reply to this Message

Peter Jamieson - 20 Apr 2005 08:23 GMT

> I'm sure there must be an easier way but can't think how :-)

:-) Other than creating the field you need in the data source itself, which

may or may not be easy depending on the source, there isn't an easier way.

Peter Jamieson

>> I did a mail merge from an excel spreadsheet.
>> Had first name, middle name and last name.
[quoted text clipped - 10 lines]
> middle name - I'm sure there must be an easier way but can't think how :-)
> Graham

Reply to this Message