Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge from excel-date in excel January 1, 2005 -merged dbase.
I have an excel database with dates. I have formatted the dates in excel so
they are January 1, 2006 - When I do a merge using my excel sheet as the information database, the columns that have the date spelled out change to a date of 1/1/06. What can I do so the date colums format does not change during the merge. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge from excel-date in excel January 1, 2005 -merged dbase.
Word ignores any formatting from Excel so you have to apply it in Word using
a formatting switch http://www.gmayor.com/formatting_word_fields.htm In this case {Mergefield datefieldname \@ "MMMM d, yyyy"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Elaine Ballon wrote: I have an excel database with dates. I have formatted the dates in excel so they are January 1, 2006 - When I do a merge using my excel sheet as the information database, the columns that have the date spelled out change to a date of 1/1/06. What can I do so the date colums format does not change during the merge. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
Mail Merge document and Date field | Mailmerge | |||
Mail Merge: Excel (XP) fields scrambled during merge | Mailmerge | |||
Attaching different Excel files to emailed mail merge using merge. | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |