Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Syntax
Hi Using word with Excel as a datasource:
I want to say: I want to say: If the data (date of birth) in that cell means the person is over 60yrs, Then "we welcome volunteers that are more mature", Else "All volunteers welcome". {IF {MERGEFIELD DoB}= "=Today()-21900" "we welcome volunteers that are more mature" "All volunteers welcome"} Can someone tell me what i have done wrong please Thanks A |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Syntax
I would suggest that you use Excel to determine the age and then use the age
mergefield in your If...then...else construction in Word { IF { MERGEFIELD age } 60 "We welcome volunterrs that are more mature." "All volunteers welcome." } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "alex" wrote in message ... Hi Using word with Excel as a datasource: I want to say: I want to say: If the data (date of birth) in that cell means the person is over 60yrs, Then "we welcome volunteers that are more mature", Else "All volunteers welcome". {IF {MERGEFIELD DoB}= "=Today()-21900" "we welcome volunteers that are more mature" "All volunteers welcome"} Can someone tell me what i have done wrong please Thanks A |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Syntax
Alternatively, if you are hell bent on doing it in Word, to see how to do
this and just about everything else you might want to do with dates in Word, check out fellow MVP, Macropod's Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 or at the following page of fellow MVP Graham Mayor's website http://www.gmayor.com/downloads.htm#Third_party where he has an item titled 'Date and Time Calculations In A Mailmerge' -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "alex" wrote in message ... Hi Using word with Excel as a datasource: I want to say: I want to say: If the data (date of birth) in that cell means the person is over 60yrs, Then "we welcome volunteers that are more mature", Else "All volunteers welcome". {IF {MERGEFIELD DoB}= "=Today()-21900" "we welcome volunteers that are more mature" "All volunteers welcome"} Can someone tell me what i have done wrong please Thanks A |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Syntax
See also comparing dates at http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org alex wrote: Hi Using word with Excel as a datasource: I want to say: I want to say: If the data (date of birth) in that cell means the person is over 60yrs, Then "we welcome volunteers that are more mature", Else "All volunteers welcome". {IF {MERGEFIELD DoB}= "=Today()-21900" "we welcome volunteers that are more mature" "All volunteers welcome"} Can someone tell me what i have done wrong please Thanks A |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
syntax errors | Microsoft Word Help | |||
Find syntax for /*..........*/ ? | Microsoft Word Help | |||
Formula - Syntax Error | Tables | |||
Mailmerge calculations syntax | Mailmerge | |||
Macro Syntax | New Users |