problems with merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christinab - 13 Apr 2004 12:51 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 13 Apr 2004 13:18 GMT

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.

> Does this make sense? I would appretiate some help!
>
> Christina

Reply to this Message