Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SEBBY SEBBY is offline
external usenet poster
 
Posts: 1
Default Mail merge date formats

I have the date on my excel datasource in english UK format; but when it
transfers to my word mail merge document it reads in US format. HOw can I
prevent that? Windows is set to run UK English
  #2   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 Mail merge date formats

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" section of fellow MVP Cindy
Meister's website at

http://homepage.swissonline.ch/cindy...r/MergFram.htm

You may also be able to control it by the use of a formatting switch. See
"Formatting Word fields with switches" on fellow MVP Graham Mayor's website
at

http://www.gmayor.com/formatting_word_fields.htm

Here is some information on using such switches in another thread by fellow
MVP Macropod:

To get the date format you want, you can add a formatting picture switch. In
Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like
{MERGEFIELD MyDate} where 'MyDate' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "MMMM d,
yyyy"' to the field, as in {MERGEFIELD MyDate \@ "MMMM
d, yyyy"}. With this switch your date will come out as November 11, 2009'.
Other possible date formatting switches include:
. \@ "dddd MMMM d, yyyy";
. \@ "ddd MMMM d, yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: Note: you can swap the d, M, y expressions around, but you must
use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.


--
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, originally posted via msnews.microsoft.com

"SEBBY" wrote in message
...
I have the date on my excel datasource in english UK format; but when it
transfers to my word mail merge document it reads in US format. HOw can I
prevent that? Windows is set to run UK English


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
Date MERGE formats Phil Stokes Mailmerge 1 May 9th 09 03:23 PM
Mail merge date field formats in word Slim Mailmerge 2 December 20th 07 02:02 PM
Mail merge formats Shey Mailmerge 5 October 26th 06 06:24 AM
How can I maintain Excel date formats in a mail merge? MKLeisure Mailmerge 1 August 30th 05 08:09 PM
Help With Time Formats When Doing A Mail Merge PLEASE nylebella Mailmerge 3 March 18th 05 03:09 AM


All times are GMT +1. The time now is 06:41 AM.

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

About Us

"It's about Microsoft Word"