Mail Merge Dates

[coyotem78]

Hi

I'm having some problems with Mail merge and date formats. I have a
spreadsheet which contains some dates in the dd/mm/yyyy date format

eg
Start_date Finish_Date
1/1/2005 30/6/2007

When I insert these fields in a mail merge document, I get them in the
mm/dd/yyyy date format.

My question is, Is there a way to change the format?

coyotem78

 

[Doug Robbins]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Sarah]

I also have a problem with dates. I have them in an excel spreadsheet the
English way 4/8/06 for 4th August but when merged it is changing it to
Amercian 8/04/06 how do I change it back

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP