Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2006

Tip: Looking for answers? Try searching our database.

Merge field punctuation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Candace - 23 Jun 2006 16:58 GMT
Is there any way to display punctuation after a merge field depending on
whether or not there is any data in that field? For instance, I have a
sentence that includes an Address1 field and an Address 2 field. I have a
comma between the two address fields. If some of the records that merge do
not contain a second address, I don't need the comma that prints after the
first address. Is this possible with Word 2003?
Doug Robbins - Word MVP - 23 Jun 2006 18:42 GMT
Use an If...then...Else... field

{ IF { MERGEFIELD Address2 } <> "" ", { MERGEFIELD Address2 }" "" }

You must use Ctrl+F9 to insert each pair of field delimiters.  Put this
field construction immediately after your Address1 mergefield and note that
there is a space after the comma.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is there any way to display punctuation after a merge field depending on
> whether or not there is any data in that field? For instance, I have a
> sentence that includes an Address1 field and an Address 2 field. I have a
> comma between the two address fields. If some of the records that merge do
> not contain a second address, I don't need the comma that prints after the
> first address. Is this possible with Word 2003?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.