View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Not merging one field if another is blank

It would help point out why it is not working if you had posted the field
construction that you had tried and also what "it's not working." means in
terms of the result that you do get.

To start with, the field delimiters { } must be entered using Ctrl+F9. They
cannot be entered using the keys in the row above the Enter Key (on a US
Keyboard)

{ IF { MERGEFIELD Number } "" "{ MERGEFIELD FieldName} { MERGEFIELD
AreaCode } { MERGEFIELD Number}" "" }



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Alvin Mast" wrote in message
...
I'm doing a merge using an Access contact file. The user is allowed up to
7
telephone numbers, each with 3 fields: FieldName, AreaCode, Number.

I want to not merge any of the 3 fields if Number is blank. I tried
inserting an IF statement but it's not working.

How can I do this?
--
al