Perfect. It works.
My major problem was I misread Ctrl+F9 for Alt+F9
People tend to read what they expect and not necessarily with is.
Thank you VERY much for your help and patience.
"Graham Mayor" wrote:
Make that my *first* post in this thread 
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Graham Mayor wrote:
If you step back to my second post in this thread, all is explained.
Enter the fields directly into the document from the keyboard using
CTRL+F9 for each pair of brackets {} (four pairs in the example I
posted).
Forget the dialogs (though you can use the insert merge field
dialog to confirm the spelling of any fields used) insert the lot
manually at the location where you want it to appear.
sos-DC wrote:
Now the only question is where and how do I enter it. I tried under
Insert Merge Field, but the "IF" field does not allow you to enter a
formula. I entered data as was suggested by someone in my office and
then did ALT-F9 to view and edit.
The brackets {} in the first part of the formula have a faint box
around them but the ones I entered did not.
This is my actual problem. I'm pretty good with formulas in Excel so
eventually I would have figured it out (I hope), but knowing where
and how to enter the formula is my current problem.
Thanks for any help you can give.
"Graham Mayor" wrote:
The basic setup is
{IF {Mergefield Home} "" "{Mergefield Home}" "{Mergefield Word}"}
however this assumes that the whole address is in one field. If you
have separate streets for streets, towns etc, test one of the home
fields that should always be present (such as the town) and put all
the fields that represent the addresses formatted as you require
them between the quotes.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
sos-DC wrote:
You're right - it would help if you knew what I was trying to
achieve.
The data base is in Excel, slightly over 400 entries.
There are separate columns for HOME addresses and WORK addresses.
Most of the entries have home addresses only, approximately 325.
The rest are WORK addresses only or both HOME and WORK addresses
provided.
What I am trying to do is create a Mail Merge document that will
print the home addresses. If the home address column is blank it
will automatically go to the work address columns.
I have created a great many additional columns (17 columns) into
which I entered a great many formulas so that I can use just one
merge document for the entire data base. (Haven't tested it yet.)
I am hoping to find a simple way to use IF...THEN...ELSE... in Word
(MERGE) to handle the problem.
I'm comfortable with Excel but the next person to take over the
task may not be and the extra columns will definitely confuse them.
Is it possible to use IF...THEN... ELSE... in Word (Merge) to solve
my problem.
"Graham Mayor" wrote:
The basics of mail merge are covered at
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
If you tell us exactly what you are trying to achieve, we will
tell you what is possible.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
sos-DC wrote:
I previously tried that but could not get it to work.
I did notice that the original field brackets {} hand lines
around them but the ones I entered did NOT. Could that make a
difference? I checked the link you provided but an unable to find
anything.
I'm not very good at searching the web.
"Graham Mayor" wrote:
If you are building complex conditional fields, it is better to
insert them manually using CTRL+F9 for each set of field
brackets {}. The field dialogs are too inflexible. See
http://www.gmayor.com/formatting_word_fields.htm for some
examples of field construction.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
sos-DC wrote:
Under
Tools Letters Mail Merge Insert Word Field (in merge tool
bar) is
If...Then...Else...
This window allows for adding text under specific
circumstances. During an online class for Mail Merge, I was shown a
similar
window, but instead of inserting text, you would add
Mergefields.
The window had the first row (Field name, Comparison, Compare
to) or something similar on the succeeding rows.
I didn't realize I did not know where it is and I would like to
find it.
If this makes sense, can anyone tell me how to open this
window? I have no way of reconnecting with the instructor for
the online class.