[JVRB]

I have an Excel spreadsheet I am using as a database (as it has less thatn
100 records, Excel is adequate). I have 3 types of mail targets - with
variations
1. Unmarried clients with and without middle initials
2. Married clients with shared surname, with and without middle initials
3. Married clients with different surnames, with and without middle initials

My field names are First_Name1, Mid_Init1, Last_Name1, First_Name2,
Mid_Init2, and Last_Name2.

I need to set up my mail merge such that it gives me:

First_Name1 Mid_Init1
If First_Name2 is blank,
return First_Name1 Mid_Init1 Last_Name1 (i.e. John J. Doe)
If First_Name2 is not blank and Last_Name2 is blank,
return First_Name1 Mid_Init1 and First_Name2 Mid_Init2 Last_Name1
(I.e. John J. and Jane K. Doe)
If Last_Name2 is not blank,
return First_Name1 Mid_Init1 Last_Name1 and First_Name2 Mid_Init2 Last_Name2

I tried using nested if combined with .AND. but it doesn't seem to work.

Anyone have an idea on this?