Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-06-2015, 11:51 AM
nfotx nfotx is offline Using "insert other placeholders" *Ask, *Fill In, etc Mac OS X Using "insert other placeholders" *Ask, *Fill In, etc Office for Mac 2011
Novice
Using "insert other placeholders" *Ask, *Fill In, etc
 
Join Date: Dec 2014
Location: CA
Posts: 15
nfotx is on a distinguished road
Cool Using "insert other placeholders" *Ask, *Fill In, etc


I have some names with no middle initials. Consequently, I end up with two spaces between the first name and the last name. Which of the "other placeholders" do I use to get rid of the extra space. If <MiddleInitial> is blank, then remove a space. I know it is not that simple but that is what I need the mail merge to do.
Reply With Quote
  #2  
Old 07-06-2015, 02:04 PM
macropod's Avatar
macropod macropod is offline Using &quot;insert other placeholders&quot; *Ask, *Fill In, etc Windows 7 64bit Using &quot;insert other placeholders&quot; *Ask, *Fill In, etc Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Perhaps you could explain what this has to do with *Ask, *Fill In, etc?

Assuming this is indeed for a mailmerge, you could use field coding like:
{MERGEFIELD First_Name}{IF{MERGEFIELD Middle_Name}<> "" " {MERGEFIELD Middle_Name}"} {MERGEFIELD Last_Name}
or:
«First_Name}{IF«Middle_Name»<> "" " «Middle_Name»"} «Last_Name»

Note: The field brace pairs (i.e. '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces represented in the field construction are all required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Instead of "Insert Cut Cells"; I get "Insert Paste Row" dzmudly Excel 3 02-21-2019 03:44 AM
How to globally change default "pattern fill" color for all shapes in PP 2013 tbach PowerPoint 1 01-31-2014 10:59 AM
Printing "Fill-In" merge fields vorm Mail Merge 0 07-27-2011 08:22 AM
Using &quot;insert other placeholders&quot; *Ask, *Fill In, etc How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
Using &quot;insert other placeholders&quot; *Ask, *Fill In, etc Option "Show picture placeholders" only works for inline pictures?? Fix? MattM Word 2 06-15-2011 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.


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