Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
JethroUK© JethroUK© is offline
external usenet poster
 
Posts: 110
Default Empty 12:00:00 AM?

Empty date field in XL when mailmerged reads:

12:00:00 AM

The merge field contains {MERGEFIELD "MDP"} no additional formatting

Any Ideas? I was wondering whether i can use an 'If' command with this, or
maybe some formatting option?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Empty 12:00:00 AM?

You can use a conditional field to trap it

{IF {Mergefield MDP} "12:00:00 AM" "{Mergefield MDP}" }

should do the trick.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



JethroUK© wrote:
Empty date field in XL when mailmerged reads:

12:00:00 AM

The merge field contains {MERGEFIELD "MDP"} no additional formatting

Any Ideas? I was wondering whether i can use an 'If' command with
this, or maybe some formatting option?



Reply
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
Empty 12:00:00 AM? JethroUK© New Users 1 October 13th 07 11:54 AM
Last Saved By is Empty Rachelle Microsoft Word Help 0 March 6th 07 03:16 PM
Word attachment is empty renee Microsoft Word Help 1 July 24th 06 06:41 PM
How do I remove empty headers? Jeff Rowe Microsoft Word Help 2 July 7th 06 11:12 AM
Omitting empty field Rob Mailmerge 3 July 23rd 05 12:12 PM


All times are GMT +1. The time now is 06:41 PM.

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"