| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
date format in mailmerge from excel file to word doc.
I need to send out automatic emails (with different data to different
customers). I have created an excel file wherein there is one cell for "date". I have merged with the word document. While other details are shown in the word as per the excel sheet, the date format is not shown as in the excel cell. The date format in the excel sheet is "dd-mmm-yy". i need the same to be shown in the word doc. however, it is showing "mm-dd-yy". can you help. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
date format in mailmerge from excel file to word doc.
See
http://www.gmayor.com/formatting_word_fields.htm and possibly http://homepage.swissonline.ch/cindy...2.htm#DatesBug -- Peter Jamieson http://tips.pjmsn.me.uk "badhusha" wrote in message ... I need to send out automatic emails (with different data to different customers). I have created an excel file wherein there is one cell for "date". I have merged with the word document. While other details are shown in the word as per the excel sheet, the date format is not shown as in the excel cell. The date format in the excel sheet is "dd-mmm-yy". i need the same to be shown in the word doc. however, it is showing "mm-dd-yy". can you help. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show date / currency format in mailmerge from Excel? | Mailmerge | |||
| Strange behaviour of date fields in Excel-Word mailmerge | Mailmerge | |||
| Date format in Word 2003 mailmerging from excel file. | Mailmerge | |||
| Mailmerge in Word, date format in merged doc | Mailmerge | |||
| Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Linear Mode
