View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging Excel to Word

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/cindy...r/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

"Geri" wrote in message
...
Hi Peter, sorry for taking so long to get back to you, but thanks for your
help the versions are;

Word 2003 SP2
Excel 2003 SP2
XP Professional 2002 SP2

I am really stumped with this one, any help would be much appreciated

Warmest regards
Geri

"Peter Jamieson" wrote:

If you are using Word/Excel XP (2002) as far as I know this problem
should
have been fixed by a service pack some years ago (I think 2002 is up to
Service Pack 3 (SP3) now - you can get these packs from the microsoft web
site - see http://www.microsoft.com/downloads ,or if you are in a
corporate
environment you would typically have to ask your I.T. support people.

Otherwise, which version of Word, Excel and Windows?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Geri" wrote in message
...
Hi there, I'm merging an excel sheet into Word and the date format is
coming
out americanised ie mmddyyyy instead of ddmmyyyy, someone via this site
has
given me the correct codes but they are still not working, when I'm
pressing
shift F9 to change they are coming up as the correct format, but still
showing wrongly, is there any known bugs with this that there is a
patch
to
fix it?

Any help would be greatly received
Warmest Regards
Geri