![]() |
|
#1
|
||||
|
||||
![]()
That suggests you may have mixed data formats in the source (ie some data is stored as dates, whilst others are stored as text) or, if there's more than one instance of the date in the document, that the field switch has been entered incorrectly for the one producing the wrong output.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
The issue is not mixed data format in the source as I have checked this (I even recreated the column from scratch). Also there isn't any problem with the coding for the switch - my mail merge is to create letters that contain the date ie the date format is correct on some letters but not others.
I don't think I have explained my problem very well. Below is an example of the output of my mail merge: 10/01/2013 Tuesday, 1 October 2013 (This is incorrect)It seems that the Word can only create the date in the format that I want when the day is greater than "12". Surely there has to be a work around. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
time field issue in mail merge | Aude | Mail Merge | 16 | 05-18-2014 06:22 AM |
![]() |
dan1 | Mail Merge | 7 | 06-28-2012 03:00 AM |
![]() |
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
![]() |
tonywatsonmail | Mail Merge | 1 | 07-01-2011 05:30 AM |
Word 2007 mail merge issue | steelervince | Mail Merge | 0 | 02-17-2010 02:26 PM |