I understand, i learn stuff as I go, mail merge is a great program but it could be so much better. Can you tell me how to do it in xcel? ![]()
In MS Word 2007 I am merging a letter with names, dollar amts and addressses. I would like find a way to use a conditional statement so that if one field is blank it would use another instead. I am not familiar with this at all, except I do know its possible.
Example is if First Name is Francis, Nickname is Frank, I want to use the nickname fields when present. This is probably way too simple for this forum but I would appreciate any help someone is willing to give.
Thanks,
Mary Ellen ![]()

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic