View Single Post
 
Old 08-07-2021, 08:35 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Nothing has changed, except the way the merge document is connected to the data source. Early Word versions used DDE which was notoriously flaky but it did provide the format from Excel.

That option is still available - From the File tab in Word, select Options and then go to the Advanced tab, General sub heading and check the box against the "Confirm file format conversion on 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.

However I don't recommend it as it is unreliable and no longer the default (and may be abandoned altogether). It is better to use formatting switches to provide the required format - see Formatting fields with switches
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote