Hey,

I am using Excel 2010 and Word 2010 and trying to complete a mail merge in Word. I am having issues with the Excel not bringing over the formatting in Excel over to the mail merge. In past versions, 2003, I have had the option to bring over the Excel data in DDE, which keeps the formatting the same but no such luck so far in 2010. I am looking for a simple solution to pull over the Excel data in its format into the mail merge versus having to manually update the formatting in the mail merge with \$#,## etc.

THANKS!