Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With Time Formats When Doing A Mail Merge PLEASE | Mailmerge | |||
Controlling Merge Field Size? | Mailmerge | |||
How to remove unwanted formatting in mail merge for cells witn no | Mailmerge | |||
Home Phone field not getting picked up in Merge | Mailmerge | |||
suppress invalid merge field word 2003 | Mailmerge |