problems with merge fields

[christinab]

I am doing a mail merge for a list of about 160 names, which are held in an Excel spreadsheet. I have Title, FirstName, Lastname, Address etc, etc. The merge itself works fine. But when a person is called Sir, rather than Mr, then the letter types "Dear Sir Smith". I dont like this. I would prefer it to say "Dear Sir David Smith", but only if the title IS EQUAL TO Sir. All others should just have "Dear Mr Smith", or whatever

Does this make sense? I would appretiate some help

Christina

 

[Doug Robbins - Word MVP]

Hi Christina

Use an If...Then...Else field

Dear { IF { MERGEFIELD Title = "Sir" "Sir { MERGEFIELD FirstName }" "Mr" }
{ MERGEFIELD LastName },

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle them off.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I am doing a mail merge for a list of about 160 names, which are held in

an Excel spreadsheet. I have Title, FirstName, Lastname, Address etc, etc.
The merge itself works fine. But when a person is called Sir, rather than
Mr, then the letter types "Dear Sir Smith". I dont like this. I would prefer
it to say "Dear Sir David Smith", but only if the title IS EQUAL TO Sir. All
others should just have "Dear Mr Smith", or whatever.