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

Tip: Looking for answers? Try searching our database.

More 'How skip blank field' issues...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
awadmin - 19 Dec 2006 00:16 GMT
After reading earlier post 'How skip blank field', I have tried that method
and still can't get it right.  I'm not as savvy with the tech portion of
Word, so the {MERGE stuff} ="with other stuff"} instruction isn't as clear to
me as it might be to others...I can see it when I toggle, but don't really
know how to use it. When I open the If..Then..  dialog box to try there, it
seems to want to enter text that I provide...and I don't think I want that.

I want to have the data entered if it is there, but skip to the next FIELD
on the page if the field is left empty. I don't want to skip to the next
record (NextIf / SkipIf), and I don't want auto-text or a space entered every
time it is blank.

Practical Example:
A mortgage may have 1, or more than 1 name on it.  If there is a second, I
want the name printed on the letter, if not, just leave blank without a space
entered.
Peter Jamieson - 19 Dec 2006 01:55 GMT
Word IF fields are just a way to implement some simple IF..THEN..ELSE logic
using your field data. So the first thing to do is dscribe what you want to
do in those terms, e.g.
a. do you have two mortgage_name fields (let's say mortgage_name_1 and
mortgage_name_2) ? or what?
b. what do you want /exactly/ if
- mortgage_name_1 is blank and mortgage_name_2 is blank
- mortgage_name_1 is blank and mortgage_name_2 is not blank
- mortgage_name_1 is not blank and mortgage_name_2 is blank
- mortgage_name_1 is not blank and mortgage_name_2 is not blank

Once you have the logic, it should be possible to translate it into Word's
"field language". There are plenty of examples in this group, and when you
insert a complex set of field codes, I would advise that you start by  using
ctrl-F9 to insert every pair of special field braces and type everything
else in the usual way.

Peter Jamieson

> After reading earlier post 'How skip blank field', I have tried that
> method
[quoted text clipped - 18 lines]
> space
> entered.
 
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.