MailMerge Date with Excel

[Paul Wadsworth]

When merging a date from an Excel spreadsheet with a Word
document, which ever way I enter or format the date entry
in Excel it turns it into an American date style in the
Word document. I want UK style ie dd/mm/yyyy. There are
answers here for a similar problem for Word/Access merges.
Can someone please help for a Word/Excel merge?

Regards

 

[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

 

[Graham Mayor]

The issues relating to Word and Excel are the same - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>