mail Merge & Excel Y or N

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

Hi all

I have an excel file with variosu data in, Each colum has a heading and each
candidate will either have some info in that colum (if so then the data will
be a date), if no data then it will be blank.

What I really need for my mail merge is for word to check if there is data
in the cell or not and give me a result.
For example if B3 = (blank) display in mail merge N
or if B3 = 01/09/2008, display Y

Can someone guide me through this
Thanks

PS: new user to mail merge so please be specific and think fo me as a newbie!
 
Let's assume the heading for column B is MyDate then

{IF {Mergefield MyDate} <> "" "Y" "N" }

In theory if B3 is empty then Mydate for that row should be "" hence if the
result is not equal to "" Insert Y otherwise insert N
The problem is that when merging from Excel empty date fields do not
necessarily return "". So check what the field {Mergefield MyDate} actually
returns for an 'empty' field and use that result between the quotes instead
of "".

The field brackets {} are inserted with CTRL+F9

You might find http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm and
http://www.gmayor.com/formatting_word_fields.htm useful


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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
You may want to do this "calculation" in Excel first and then just mailmerge
the results. In Excel it would be really easy to do with an IF formula.
 
Back
Top