View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair
 
Posts: n/a
Default Excel to word merge

In article , "Arvi Laanemets" wrote:
Hi

To use Excel table as a source for MS Word Mail Merge, better create a
special table for it, where all numeric and date values are replaces with
strings. I.e. when in your original table the date was p.e. in cell B5 on
sheet Data, then in new table in cell B5 you have the formula
=TEXT(Data!B5,"dd/mm/yyyy")


Other possibility is to make sure you get the data via DDE. The other
options certainly give other formating problems.



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)