Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pepper
 
Posts: n/a
Default Empty merge fields come over as 12:00:00

When merging from Excel into Word 2002 the fields that are empty (a date
field) comes over with 12:00:00 instead of blank. I am putting together a
roster that shows birthdates. When the birthdate is unknown the field in
Excel is empty. When it merges into word the field indicates the time instead
of being blank. How can I insert this field without the time.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form fields versus mail merge fields [email protected] Microsoft Word Help 2 February 16th 06 02:12 PM
How to supress blank merge fields in Word 2002 DiTab1 Microsoft Word Help 9 November 10th 05 04:56 PM
"Insert Merge fields" button is inactive Robert Judge Mailmerge 2 September 27th 05 07:47 AM
Populate Merge Fields via VB.NET ben Mailmerge 5 June 21st 05 05:43 PM
Word 2002 Mail Merge - merging to new doc displays blank empty dia Steve Vincent Mailmerge 1 December 15th 04 06:28 PM


All times are GMT +1. The time now is 08:03 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"