View Single Post
  #5   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

See the answer to your other post! There is no need to post the same thing
in several places.

--

Graham Mayor - Word MVP

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


tamee wrote:
Hope you could help me again. How Do you align currency figures so
that the values are right justified or all decimal points aligned
together?

"Graham Mayor" wrote:

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