Thread: time field issue in mail merge
View Single Post
 
Old 05-03-2012, 04:43 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote