#1
|
|||
|
|||
time field issue in mail merge
Hi,
I am merging data from an Access 2007 query into a Word 2007 doc, including 2 date/time fields. For one I have added a field switch to only display the data in the desired format (\@ "dddd dd MMMM yyyy"), and am trying to do the same with the second field to only display the time in the hh:mm format. Unfortunately, it seems that whatever switch I try to use, the field still display as 30/12/1899 hh:mm:ss. I have also tried playing around with the field format in Acces, but this does not seem to change anything. Would be grateful for any advice! Aude |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - If a field is black, take the data from the row below? | mikeprent | Mail Merge | 5 | 01-05-2012 04:52 AM |
Use a mail merge Field as the final doc filename | DaveBF | Mail Merge | 1 | 10-22-2011 10:16 PM |
HTML Content in Mail Merge Field | Ilmater | Mail Merge | 1 | 09-04-2011 02:47 AM |
Mail merge erases field codes | Medievalguy88 | Mail Merge | 1 | 08-11-2011 05:21 AM |
Mail merge Field Code Manipulation | macjnr | Mail Merge | 0 | 09-10-2009 11:37 AM |