Date mail merge from Excel

[Sam Horwood]

Dear All,
I've got an excel spreadsheet that holds people's names
and addresses etc.. including 4 date fields which are
used in the mail merge fields. These dates display
correctly in the excel spreadsheet, all the formatting on
the cells is the same (dd MMMM yy) and the date data is
correct (38048). Now, a mail merge word document is used
to extract data from the excel spreadsheet to the merge
fields. Originally the dates were displaying incorrectly.
for instance the 15th of march would display as
3/15/2004, but thanks to the help of this newsgroup, I've
put in the code to make that 15 March 2004 { MERGEFIELD
testdate \@ "d MMMM yyyy" \* MERGEFORMAT }. BUT, the
quirk that I have noticed is that I am currently getting
the second of march, displaying as 3 February 2004. This
is quite a pain for us, and I've checked the regional
settings, and that's all correct (English, Australia,
etc). I've tested this and it works for all the dates
where the day value is 13th or over, they display
correctly, but if the day is less than 12, they translate
the day as the month and vice versa. I'm not sure what to
do, and I hope that you learned people would be able to
help me. I have checked the data source, and the
formatting, but I'm not sure what else to check. Is there
an update or service pack that I could run? All versions
of Office are XP (2002). Any help would be of great use.
Thanks in advance.
Sam

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Sam,

See the article "Dates: day/month reversed" under the "Connection Methods"
topic of the Mailmerge in Word 2002 section of fellow MVP Cindy Meister's
website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP