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 / July 2004

Tip: Looking for answers? Try searching our database.

Conditional merging of "Merge fields"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Voorhees - 06 Jul 2004 22:19 GMT
I understand how insert different words conditionally into a Merge document.
E.G.:  if (Mergefield lastname) = "Smith"  type "Good Guy"  else type "Bad
Guy"

How do I conditionally insert Mergefields instead of words?  EG:  if
(Mergefield lastname) = "Smith"  insert (mergefield vacation)  else insert
(mergefield work)

Any thoughts appreciated.

Thanks,  Bill V.
Peter Jamieson - 06 Jul 2004 23:32 GMT
> I understand how insert different words conditionally into a Merge document.
> E.G.:  if (Mergefield lastname) = "Smith"  type "Good Guy"  else type "Bad
[quoted text clipped - 3 lines]
> (Mergefield lastname) = "Smith"  insert (mergefield vacation)  else insert
> (mergefield work)

You're nearly there - all you need do is actually insert the appropriate
merge field instead of plain text. e.g.

{ IF { MERGEFIELD lastname } = "Smith"
"{ MERGEFIELD vacation }"
"{ MERGEFIELD work }" }

Where all the {} are the special field code braces (you can insert pairs
of field code braces using ctrl-F9 and type all the other text in
between them.)

Peter Jamieson
William E Voorhees - 07 Jul 2004 01:38 GMT
Works Great!  Thanks

The ctrl-F9 key combo must be used.  I tried typing {} to no avail.

thanks again

Bill V

> > I understand how insert different words conditionally into a Merge document.
> > E.G.:  if (Mergefield lastname) = "Smith"  type "Good Guy"  else type "Bad
[quoted text clipped - 16 lines]
>
> Peter Jamieson

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.