Reply
 
Thread Tools Display Modes
  #1   Report Post  
Sharon VA
 
Posts: n/a
Default Unwanted time inserted into merge field

Mail merge is inserting "12:00:00 AM" where a field should be left blank.
There is no data to merge into that field. The data that would be merged if
the field were not blank is a date i.e. 1/30/04
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Try inserting the following nested field:

{ IF "{ MERGEFIELD mydate }" = "12:00:00 AM" "" "{ MERGEFIELD mydate }" }

where mydate is the name of your date field.

The {} should all be inserted using ctrl-F9. The "12:00:00 AM" should be
exactly the same as the result you see if you insert

{ MERGEFIELD mydate }

Peter Jamieson
"Sharon VA" Sharon wrote in message
...
Mail merge is inserting "12:00:00 AM" where a field should be left blank.
There is no data to merge into that field. The data that would be merged
if
the field were not blank is a date i.e. 1/30/04



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
Help With Time Formats When Doing A Mail Merge PLEASE nylebella Mailmerge 3 March 18th 05 03:09 AM
Controlling Merge Field Size? Jim Mailmerge 1 March 8th 05 09:49 AM
How to remove unwanted formatting in mail merge for cells witn no Jim Mailmerge 3 March 4th 05 08:13 AM
Home Phone field not getting picked up in Merge Cathleen McGuire Mailmerge 4 January 7th 05 03:13 AM
suppress invalid merge field word 2003 Mike Mailmerge 3 December 9th 04 11:13 AM


All times are GMT +1. The time now is 12:29 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"