date format in mailmerge from excel file to word doc.

B

badhusha

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
VBA - exporting serial letters to single documents 0
Merging from an Excel file with graphics 1
Embedded Excel into Word with Tables 0
Date Formats 4
Integrating information from Word to Excel (not mail merge) 1
Doughnut Chart linked with the slicer in the pivot table 0
date format in mailmerge 3

Top