Mail merge conditional adress blocks.

[Thrizian]

Dear Community,

I am trying to get myself into using MSWord more advanced lately. Now i find myself being unable to find a way to set the following situation up!
I have an excel file which consists of many columns of which one can have a list of entries being the names of providers in the Netherlands.


Now what i want to do is mail merge the provider names into a word document. With a conditional that makes the names of the providers turn into their adress blocks.
lets say this is the column named "Internet":

Alice
CanalDigitaal
Stichting CAI Bleiswijk
Budget Phone Company
BenF Media
KPN


In the word document i would need a if format saying:

{IF {MERGEFIELD Internet} = "Alice" "Alice 
Postbus 1404 
6501 BK Nijmegen" "{IF { MERGEFIELD Internet} = "KPN" "KPN 
Postbus 30000
2500 GA Den Haag" " "} "}

the result would be that it changes the merge field to:

Alice
Postbus 1404
6501 BK Nijmegen

Or:
KPN
Postbus 30000
2500 GA Den Haag

Yet when i use the code above i get:
"Internet}"

[macropod]

That suggests you haven't used Ctrl-F9 for all of the field braces (ie '{}')

[Thrizian]

Originally Posted by macropod

That suggests you haven't used Ctrl-F9 for all of the field braces (ie '{}')

And you are right!

Thank you very much. I was not aware that each field has to get it's own Ctrl+F9. Great info!