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 / May 2006

Tip: Looking for answers? Try searching our database.

literal text to mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jt - 08 May 2006 17:13 GMT
I need to add literal text (ie: "Best of the Best" to a mail merge. The
quotes are constraints for the mail merge formatting. I can't figure out how
to work around this.
Doug Robbins - Word MVP - 08 May 2006 18:17 GMT
Is the text in the data source?  What is the data source?  What version of
Word?

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

>I need to add literal text (ie: "Best of the Best" to a mail merge. The
> quotes are constraints for the mail merge formatting. I can't figure out
> how
> to work around this.
jt - 08 May 2006 20:09 GMT
The text is not in the data source. I'm working in word 2003. For example:
{IF {MERGEFIELD RCPS} <> "0" "You are the "Best of the Best"" " ". When I
attempt to add the quotes to the phrase, it creates conditional text instead
of quoted literal. Adding additional " didn't have an effect. jt

> Is the text in the data source?  What is the data source?  What version of
> Word?
[quoted text clipped - 3 lines]
> > how
> > to work around this.
what4893 - 08 May 2006 21:31 GMT
Why don't you just do the merge and let Best of the Best come out and
then do a find and replace for Best of the Best and replace it with
"Best of the Best"?
Peter Jamieson - 09 May 2006 06:53 GMT
It would be nice if this was easier, but you can do it using a nested field
{ QUOTE 34 }

e.g.

{ IF { MERGEFIELD RCPS } <> "0" "You are the { QUOTE 34 }Best of the Best{
QUOTE 34 }" " " }

where all the {} are the special field code braces you can insert using
ctrl-F9.

If you are using them a lot and like to keep things short you can use

{ SET q { QUOTE 34 } }

then

{ IF { MERGEFIELD RCPS } <> "0" "You are the { q }Best of the Best{ q }" "
" }

Peter Jamieson

> The text is not in the data source. I'm working in word 2003. For example:
> {IF {MERGEFIELD RCPS} <> "0" "You are the "Best of the Best"" " ". When I
[quoted text clipped - 11 lines]
>> > how
>> > to work around this.
 
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.