Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Katie Katie is offline
external usenet poster
 
Posts: 52
Default Mail Merge Date Format from Excel to Word

I have date data in my excel sheet. I have formatted it dd month yyyy, but
when I perform the mail merge, in the word document it displays the time
"12:00AM". I am using Word 2003. How do I fix this?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mail Merge Date Format from Excel to Word

Hi Katie,

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 '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM
yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM 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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Katie" wrote in message ...
I have date data in my excel sheet. I have formatted it dd month yyyy, but
when I perform the mail merge, in the word document it displays the time
"12:00AM". I am using Word 2003. How do I fix this?


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
Mail merge date from Excel 2003 to Word 2003 in same format TP[_2_] Mailmerge 4 January 30th 09 06:44 AM
US date format in word 7.0 mail merge William Howard Mailmerge 2 January 12th 09 02:16 AM
Incorrect date format coming across in mail merge from excel Ames Mailmerge 13 October 23rd 08 11:04 AM
Word converts English date to USA date in mail-merge from Excel? DaveCujoPI Mailmerge 1 April 20th 07 03:04 PM
Date field in Excel loses format in Word merge Cone Mailmerge 1 February 24th 07 04:13 PM


All times are GMT +1. The time now is 09:49 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"