![]() |
#1
|
|||
|
|||
![]() I have linked a Word document to an Excel spreadsheet using Mail Merge.
I have changed the date format in Excel to match what is required (dd-Mmm-yyyy), however the Word format is displayed as dd/yy/mm. Any ideas? Thanks. |
#2
|
||||
|
||||
![]()
Changing the date format in Excel won't help unless you also change the mailmerge data connection method to DDE. You'd do better to add a date formatting switch to the mailmerge field instead of messing with Excel.
To get the date format you want, you can add a formatting picture switch as follows: • 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 '\@ "dd MMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "dd MMM yyyy"}. With this switch your date will come out as '02 Aug 2008', for example. • position the cursor anywhere in this field and press F9 to update it; • run your mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Tags |
date, mailmerge |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Baldeagle | Mail Merge | 8 | 02-11-2013 04:40 AM |
![]() |
Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |
Changing format of time data | Sammael | Excel | 2 | 04-08-2012 12:13 PM |
![]() |
Sammael | Excel | 6 | 11-05-2011 06:52 AM |
![]() |
kilosub | Mail Merge | 12 | 05-05-2011 12:27 AM |