Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Field - Switch to Suppress
Hi
I'm creating a mailmerge with an Excel spreadsheet in Word 2002. A number of the fields are dates and sometimes the date is missing in the spreadsheet. In Word this blank date is showing as 12:00:00 AM. I have added the Switch \@ "dd/mm/yyyy" to stop this displaying, but it didn't work. How do I suppress this? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Field - Switch to Suppress
You would have to trap what the field actually produces with a conditional
field construction eg {IF {Mergefield Fieldname} "12:00:00 AM" "{Mergefield Fieldname \@ "dd/MM/yyyy"}"} The bracket pairs {} are each entered with CTRL+F9. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Charles wrote: Hi I'm creating a mailmerge with an Excel spreadsheet in Word 2002. A number of the fields are dates and sometimes the date is missing in the spreadsheet. In Word this blank date is showing as 12:00:00 AM. I have added the Switch \@ "dd/mm/yyyy" to stop this displaying, but it didn't work. How do I suppress this? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Field - Switch to Suppress
Thank very much Graham, as always, I can rely on great assistance here.
Regards Charles "Graham Mayor" wrote: You would have to trap what the field actually produces with a conditional field construction eg {IF {Mergefield Fieldname} "12:00:00 AM" "{Mergefield Fieldname \@ "dd/MM/yyyy"}"} The bracket pairs {} are each entered with CTRL+F9. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Charles wrote: Hi I'm creating a mailmerge with an Excel spreadsheet in Word 2002. A number of the fields are dates and sometimes the date is missing in the spreadsheet. In Word this blank date is showing as 12:00:00 AM. I have added the Switch \@ "dd/mm/yyyy" to stop this displaying, but it didn't work. How do I suppress this? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date switch/format | Microsoft Word Help | |||
How to suppress autotext US date format after typing current year | Microsoft Word Help | |||
Date Field Switch \@ "d MMM yyyy" | Mailmerge | |||
date field switch so it doesn't update every time you open docume. | Microsoft Word Help | |||
How can I suppress the date and time in tracked changes? | Microsoft Word Help |