Reply
 
Thread Tools Display Modes
  #1   Report Post  
 
Posts: n/a
Default Mail merge query re date formatting

I am using Excel as the source document for a mail merge in Word. This
includes dates, but when merged they always appear in the American format of
month, date then year.
How do I get these in the European format of day, month & year.

I have tried reformatting the source document to no avail.

This did not happen in earlier versions of Word. (Using 2003 version)

  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?eXZvbm5lcGF0ZXJzb25Ac291bmRjb250cm9sLmNvLnVr?= ,

I am using Excel as the source document for a mail merge in Word. This
includes dates, but when merged they always appear in the American format of
month, date then year.
How do I get these in the European format of day, month & year.

I have tried reformatting the source document to no avail.

This did not happen in earlier versions of Word. (Using 2003 version)

You'll find information on this in the Word 2002/2003 section of my website's
mail merge FAQ. Basically, you need to either use the previous data connection
technology or add formatting switches to the merge fields.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I set up a query for my mail merge Laura Mailmerge 1 March 22nd 05 09:31 PM
How to remove unwanted formatting in mail merge for cells witn no Jim Mailmerge 3 March 4th 05 08:13 AM
English/American date formatting in XP mail merge John Diston Mailmerge 0 January 21st 05 04:17 PM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM


All times are GMT +1. The time now is 05:55 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"