You are here:

Microsoft Word/Word 2007 - Mail merge - Numeric format switch


I am using Office 2007 on Windows 7 32bit. I have been using Mail merge function to create documents in Word with Excel databases including numeric format switches such as \# $#,##0.00 and \*CardText. Everything worked well until recently when I downloaded a Invoice template from Microsoft and tried to created invoices using mail merge with an Excel database. The numeric picture switches dont work. All numbers come across as text and cannot be formatted. Its not just this document, but all other documents which I was using previously.
Obviously there is a problem with the way the data connection works between Word and Excel, but I can't find an explanation or a solution.
The closest I can to understanding the problem was at Peter Jamieson's site
Any advice for me ?

It looks like this may be a nasty bug in mail merge - your link gave some useful background, but this link suggests that you should use DDE to do the merge - luckily it explains how.  I MIGHT be inclined to save my merge data as a csv file or something first and see if that solves it - I have noticed that merge (which used to be so well behaved in much earlier versions of Word) has been getting more and more problematic with each new release - possibly related to Microsoft making merge rely more on long winded Wizards (I used to say merge was as easy as 1-2-3 - because back in the day (!) there were just three steps on the wizard!)
About Microsoft Word
This topic answers questions related to Microsoft Word stand-alone or Microsoft Office Word including Word 2003, Word 2007, Office 2000, and Office XP. You can get Word help on formatting text, tables, tabs, fonts, styles, general Word layouts, bullets, headings, and outlines, using templates, toolbar modifications, and using Track Changes. You may also find tips on linking Word and Excel embedded objects including charts. This site does not provide a general Word tutorial nor the basics of using a word processor. It provides specific answers to using Microsoft Word only. If you do not see your Word question answered in this area then please ask a Word question here

Microsoft Word

All Answers

Answers by Expert:

Ask Experts


Aidan Heritage


I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions of Word from 2 onwards

©2017 All rights reserved.