Mail merge conditional adress blocks.

Thrizian · #1 07-17-2012, 02:16 PM

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}"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional merge fields in mail merge	Aude	Mail Merge	1	01-06-2012 07:38 PM
From a beginner: Mail Merge using Windows Mail	mhalpern705	Mail Merge	3	12-16-2011 04:58 AM
how can I add tons of mail adress to my adressbook?	esco	Outlook	2	11-25-2011 07:45 AM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM
Word not highlighting conditional Merge fields	Dunce	Mail Merge	0	02-15-2010 05:44 AM