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 / November 2007

Tip: Looking for answers? Try searching our database.

How do I insert a carriage return in a MERGEFIELD?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tanya - 07 Nov 2007 15:46 GMT
I have inserted the following field code{ MERGEFIELD  AWARDSCH_DESC2 \b
SCHOLARSHIPS}.  However I would like the MERGEFIELD TO APPEAR ON THE NEXT
LINE. E..I
SCHOLARSHIPS
MERGEFIELD AWARDSCH_DESC2

I do not want Scholarships to show up uless there is something in the
MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
Peter Jamieson - 07 Nov 2007 16:32 GMT
Put the SCHOLARSHIPS inside quotes, e.g.

{ MERGEFIELD AWARDSCH_DESC2 \b "SCHOLARSHIPS" }

then add a carriage return immediately before the second ", in the usual
way, so you have

{ MERGEFIELD AWARDSCH_DESC2 \b "SCHOLARSHIPS
" }

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have inserted the following field code{ MERGEFIELD  AWARDSCH_DESC2 \b
> SCHOLARSHIPS}.  However I would like the MERGEFIELD TO APPEAR ON THE NEXT
[quoted text clipped - 4 lines]
> I do not want Scholarships to show up uless there is something in the
> MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
Tanya - 07 Nov 2007 17:02 GMT
Hi Peter,

I tried this and it does not work.

> Put the SCHOLARSHIPS inside quotes, e.g.
>
[quoted text clipped - 14 lines]
> > I do not want Scholarships to show up uless there is something in the
> > MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
Peter Jamieson - 07 Nov 2007 17:15 GMT
It works here, except the carriage return itself always appears.

But you can also do it using the more complicated:

{ IF "{ MERGEFIELD AWARDSCH_DESC2 }" = "" "" "SCHOLARSHIPS
{ MERGEFIELD AWARDSCH_DESC2 }" }

where all three pairs of {} are the special field codes youcan insert using
ctrl-F9

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi Peter,
>
[quoted text clipped - 19 lines]
>> > I do not want Scholarships to show up uless there is something in the
>> > MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
Tanya - 08 Nov 2007 16:00 GMT
Hi,

I am trying to go a step further.  I have inserted a table to disble a
category of things AWARDSCH_DESC, AWARDGRNT_DESC, AWARDLOAN_DESC. Each one
takes up a cell in the table.  With the field code, "{ IF "{ MERGEFIELD
AWARDSCH_DESC2 }" = "" "" "SCHOLARSHIPS
{ MERGEFIELD AWARDSCH_DESC2 }" }", How can I add to delete the cell if the
mergefield is null or blank?

> It works here, except the carriage return itself always appears.
>
[quoted text clipped - 29 lines]
> >> > I do not want Scholarships to show up uless there is something in the
> >> > MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
Graham Mayor - 09 Nov 2007 06:46 GMT
You cannot delete cells from a table with a merge field, only the content -
however you don't delete the content, you insert it only when the condition
applies. Personally I would never test for a nul entry using this syntax. I
much prefer the alternative

 { IF { MERGEFIELD AWARDSCH_DESC2 } <> "" "SCHOLARSHIPS
{ MERGEFIELD AWARDSCH_DESC2 }"}

I suspect also that what you are trying to do is produce a list entry which
Word is not at all comfortable with. See How to use mail merge to create a
list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686
Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi,
>
[quoted text clipped - 46 lines]
>>>>> I do not want Scholarships to show up uless there is something in
>>>>> the MERGEFIELD AWARDSCH_DESC, so I used teh \b switch.
 
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.