time field issue in mail merge

iAltair · #1 05-18-2014, 02:22 AM

Quote:

Originally Posted by macropod

Hi Aude,

I've tracked down the problem, but I'm not sure what you'll be able to do about it without changing both your existing data and your data input procedures for the future. It's all to do with the default year that your database assumes where there is no date present. Word doesn't handle dates earlier than 1/1/1901, but your data outputs 31/12/1899 (plus the time). As an interim measure, you could:
• do a Directory/Catalogue merge of the data;
• use Find/Replace to change all instances of 31/12/1899 to 1/1/1901;
• then use the merged Directory/Catalogue data as the source for the final mailmerge.

Hi,

I have the same problem. I create a access database in access 2010 on windows 8. My date and time field after using (\@ "dd/MM/yyyy" and\@ "HH:mm") displays as i want. The problem starts when i transfer my access file to another PC using XP 32bit and office 2010. When i merge my data the date field is correct but my time fields is like this...31/12/1899 19:00:00. I would like some advise how to correct that, analytical and simple even in pm.

Thanks
Michael

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