Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2015, 04:46 PM
nfotx nfotx is offline Explanation of "other placeholders" Mac OS X Explanation of "other placeholders" Office for Mac 2011
Novice
Explanation of "other placeholders"
 
Join Date: Dec 2014
Location: CA
Posts: 15
nfotx is on a distinguished road
Red face Explanation of "other placeholders"

In the Data Form, beside the contacts tab, is "other placeholders." Can someone direct me to instructions for using other placeholders?



I need to know how to use the other placeholders when data is not available for each header value.

For example, some companies I know the district sales manager's name, but on other companies, I don't. How do I create a smooth-looking mail merge without knowing all the names?
Reply With Quote
  #2  
Old 08-03-2015, 09:06 PM
macropod's Avatar
macropod macropod is offline Explanation of "other placeholders" Windows 7 64bit Explanation of "other placeholders" Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,234
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Not using a Mac, I don't know what the "other placeholders" tab is - there isn't one of that name in Word 2010, for example.

That said, it seems you want to conditionally output some content only when a particular field has some content. Since you're using a Mac, you can't use the mergefield \b and \f swtiches for that purpose. Instead you need to use an IF field to perform a test.

Suppose, for example, you're merging data for clients and your data source contains a field for their middle initials, named 'Initials'. In that case you might use a field as follows to only output a space after the 'Initials' field if it actually has some content:
{IF{MERGEFIELD Initials}<> "" "{MERGEFIELD Initials} "}
or:
{IF«Initials»<> "" "«Initials» "}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Cmd-F9 (Ctrl-F9 on a PC); 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.

This is all discussed in my Mailmerge Tips & Tricks Sticky thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge, placeholders

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Explanation of &quot;other placeholders&quot; Using "insert other placeholders" *Ask, *Fill In, etc nfotx Mail Merge 1 07-06-2015 02:04 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
Microsoft Office XP/2003/2007/2010 Graphic Filters "Allow List" Explanation Jazz43 Office 0 08-24-2011 10:47 AM
Explanation of &quot;other placeholders&quot; How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
Explanation of &quot;other placeholders&quot; 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 09:47 AM.


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