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 2007

Tip: Looking for answers? Try searching our database.

inserting quotation marks with IF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hbear - 28 Jun 2007 15:56 GMT
I'm creating a bibliography through a merge and would like to insert
quotation marks around one field if another field contains text.  The
criteria is simple: if "Details" is not blank, insert """ (that's a single
quotation mark) in front of "Summary", with a similar statement at the end of
"Summary".  I've tried both the IF, Then, Else... box and manually inserting
the statement myself.  Neither is working.  I'm not getting quotation marks
under any circumstances.  I'm guessing it's some confusion surrounding having
three quotation marks in a row (""").  What's the workaround for this?  
Adding spaces doesn't help (of course).
Peter Jamieson - 28 Jun 2007 17:50 GMT
Use either

{ IF "{ MERGEFIELD Details }" <> "" "{ QUOTE 34 }Summary{ QUOTE 34 }" }

or if you need a lot of them it might be clearer to use something like

{ SET q { QUOTE 34 } }

at the beginning of the document then use { q } where you need the qutoe
mark, e.g.

{ IF "{ MERGEFIELD Details }" <> "" "{ q }Summary{ q }" }

(All the {} have to be the special field braces that you can insert using
ctrl-F9 - you cna't just type them on the keyboard.)

Peter Jamieson
> I'm creating a bibliography through a merge and would like to insert
> quotation marks around one field if another field contains text.  The
[quoted text clipped - 9 lines]
> three quotation marks in a row (""").  What's the workaround for this?
> Adding spaces doesn't help (of course).
hbear - 28 Jun 2007 18:24 GMT
Thank you!  Fabulous information!

> Use either
>
[quoted text clipped - 26 lines]
> > three quotation marks in a row (""").  What's the workaround for this?
> > Adding spaces doesn't help (of course).

Rate this thread:






 
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.