Not merging one field if another is blank

[Alvin Mast]

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?

 

[Doug Robbins - Word MVP]

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]

Doug, thanks a big bunch for the solution. The only difference between you
"IF" and mine was that I did not have quotes around the 3 fields after the <>.

{IF ( MERGEFIELD "Private" } <> " " "{ MERGEFIELD "PrivField' } { MERGEFIELD
"PrivAreaCode } { MERGEFIELD "Private" }"}

I apologize for being so vague. By "not working" I meant that the
PrivAreaCode was still printing. I tried to copy and paste the instruction,
but the MERGEFIELDs were replace by values.

al

 

[Graham Mayor]

You can get a macro to post field constructions on the web from
http://www.gmayor.com/export_field.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>