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:
Code:
{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}"