![]() |
|
|
|
#1
|
||||
|
||||
|
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 '\@ "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'. • position the cursor anywhere in this field and press F9 to update it; • run your mailmerge. Other possible date formatting switches include: . \@ "dddd, d MMMM yyyy"; . \@ "ddd, d MMMM yyyy"; . \@ "d MMM yyyy"; . \@ "dd/MMM/yyyy"; . \@ "d-MM-yy". Note: You can swap the d, M, y expressions around, but you must use uppercase 'M's for months - lowercase 'm's are for minutes.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| mail merge date format |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
mail merge treating CITY as DATE
|
woody | Mail Merge | 6 | 01-30-2013 03:22 PM |
Issue with date format in mail merge document
|
walshjod | Mail Merge | 4 | 11-28-2012 04:46 AM |
| Change format of date when using Now function in VB code | Bondai | Excel Programming | 2 | 03-02-2012 05:09 PM |
Mail merge will not format date field generated by Excel IF statement
|
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Date not transfering to mail merge correctly
|
tonywatsonmail | Mail Merge | 1 | 07-01-2011 05:30 AM |