View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default mailmerge date conversion

In response to your three(?) questions - From the Tools menu in Word, select
Options and then go to the General tab and check the box against the
"Confirm conversions at open" item. Then when you attach the data source to
the mail merge main document, you will be given the option of using the DDE
method of connection which should read the data as you have it formatted in
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


tamee wrote:
I have a mailmerge document with excel source data. I have date
fields in excel, but when I merge it reverts to the original serial
number. How do I convert it back to display the desired date format.
Please Help. Thanks