View Single Post
 
Old 06-04-2014, 03:42 PM
macropod's Avatar
macropod macropod is online now Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,345
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi bigUKfan,

Although DDE can preserve formatting, it's also a whole lot less capable than the default OLE DB provider Word 2002 & later use. For starters, with an Excel data source, it only works with the first worksheet and won't accept named ranges. The use of field switches also means your mailmerge output can be independent of the data format. Without that, you'd need have separate fields in the data source for every data format you wanted to use.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote