Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
When I run my mail merge, word is changing the format of the date. My excel
spreadsheet has the date formatted as "May 17, 2007". After the mail merge is done, the date shows up in the body of the letter as "5/17/07". How can I make word retain my date formatting? |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "AAA Mailing" AAA wrote in message ... When I run my mail merge, word is changing the format of the date. My excel spreadsheet has the date formatted as "May 17, 2007". After the mail merge is done, the date shows up in the body of the letter as "5/17/07". How can I make word retain my date formatting? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retain formatting of my data source using mail merge in Word? | Mailmerge | |||
Switches in Table of Authorities - retain formatting does not retain character styles | Formatting Long Documents | |||
How do I get Word to retain Excel formatting, eg zip code, ssn? | Mailmerge | |||
How do I retain formatting from an Excel Data File to a Word Merg. | Microsoft Word Help | |||
Word Templates don't retain formatting | Microsoft Word Help |