Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2012, 02:16 PM
Thrizian Thrizian is offline Mail merge conditional adress blocks. Windows 7 32bit Mail merge conditional adress blocks. Office 2010 32bit
Novice
Mail merge conditional adress blocks.
 
Join Date: Jul 2012
Posts: 2
Thrizian is on a distinguished road
Question Mail merge conditional adress blocks.

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}"
Reply With Quote
  #2  
Old 07-17-2012, 04:10 PM
macropod's Avatar
macropod macropod is offline Mail merge conditional adress blocks. Windows 7 64bit Mail merge conditional adress blocks. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That suggests you haven't used Ctrl-F9 for all of the field braces (ie '{}')
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-17-2012, 10:41 PM
Thrizian Thrizian is offline Mail merge conditional adress blocks. Windows 7 32bit Mail merge conditional adress blocks. Office 2010 32bit
Novice
Mail merge conditional adress blocks.
 
Join Date: Jul 2012
Posts: 2
Thrizian is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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!
Reply With Quote
Reply

Tags
mergefield address word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge conditional adress blocks. Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Mail merge conditional adress blocks. From a beginner: Mail Merge using Windows Mail mhalpern705 Mail Merge 3 12-16-2011 04:58 AM
Mail merge conditional adress blocks. how can I add tons of mail adress to my adressbook? esco Outlook 2 11-25-2011 07:45 AM
Mail merge conditional adress blocks. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft