| 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 | |||
Linear Mode
