Date and Day issue in Mailmerge
Hi cjshaffer,
Are you sure the date stored in Excel isn't actually 3 October 1909 (a Sunday) displayed as 3/10/09 or something such?
--
Cheers
macropod
[Microsoft MVP - Word]
"cjshaffer" wrote in message ...
I am wondering if anyone has seen the day of the week change from an excel
data source in a mailmerge. I have an event date column in which i had the
date of the event ie October 3, 2009 in it. I formatted the column in Excel
to display the day...Saturday, October 3, 2009. When I choose the data
source for the mail merge it bumps the day up by one day and displays Sunday,
October 3, 2009. Does anyone know why this happens and how I can resolve it?
Thanks
|