Posted to microsoft.public.word.mailmerge.fields
|
|
Advance problem w/Mail Merge
Understood, but can you try the approaches that I suggested that return
either text results or numeric results?
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Tricia wrote:
Q3 is only going to be a 1, 2, or 3. Each number refers to a location
(there's only 3)
V$2... these are the specific instructions for each location where the
patient is having their procedure performed.
"Peter Jamieson" wrote:
As a temporary approach, can you pin the =IF down so that for example
you use either
a.
=IF(Q3=1,"TRUE",IF(Q3=2,"TRUE",IF(Q3=3,"FALSE")))
(or whatever the appropriate results are)
or perhaps return numeric values, along the lines of
b.
=IF(Q3=1,1,IF(Q3=2,1,IF(Q3=3,0)))
then in Word you would need a nested field along the lines of
{ IF { MERGEFIELD myfield } = 0 "FALSE" "TRUE" }
Other than that...
1.
=IF(Q3=1,V$2,IF(Q3=2,U$2,IF(Q3=3,W$2)))
What is the result if Q3 is not 1,2, or 3?
2. What is in V$2, U$2, W$2?
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Tricia wrote:
That is exactly what is happening. I created a mail merge for a co-worker
who has to send out confirmation information to several people after she gets
them scheduled for a procedure with all of their information. One of the
paragraph changes depending on the hospital they are having the procedure
performed at. So what I did is create a =IF(Q3=1,V$2,IF(Q3=2,U$2,
IF(Q3=3,W$2))) each of the columns have text in them. Any clue as to how to
get the text to show instead of "False"?
"Peter Jamieson" wrote:
Do you mean that you have a column in your Excel sheet that is populated
using an =IF formula?
If so, my best guess is that the OLE DB provider that Word uses to get
data from Excel has decided that the data type of the column containing
your =IF formulas is "text", in which case I think all the results may
be provided to Word as "false". (see http://tips.pjmsn.me.uk/t0003.htm
for more info. about this). I am not sure how to check that, but maybe
you could have a look around.
If not, can you spell out what you are doing.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Tricia wrote:
I have an excel database I'm pulling my information from into a Word 2007
document. One of the fields I am pulling from is a "IF" field. Every time I
merge my document it will not pull the correct information. It always pulls
"FALSE" instead of the value that is in the field.
|