Mail Merge in Office 2007 misses characters
April 17, 2008 1 Comment
We have a user who runs a regular mail merge, and since migrating to Office 2007 has been experiencing problems merging using an Excel source into a Word document. The merge fails to display characters following the decimal point.
The resolution is to highlight the merge field in the document template and press ALT+F9. This will then display
{MERGEFIELD FIELD_NAME}
This needs to be edited to include the number of characters before and after the decimal place using the \# switch. # then defines the number of characters. It’s worth noting that if no characters exist then Word ignores the #. To get around this, adding a subsequent .00 ensures that if there is a 0 value after the decimal place then it is included. Our edited mergefield therefore looks like:
{MERGEFIELD “FIELD_NAME” \# £##,###.00}
With the new Office (the 2007) design, look & feel, Microsoft have made a giant leap. True that it takes time to get use to the new ribbon and to get around quickly.. But once you are familiar with it, you rock!
We do a lot of researches on the web, and using Excel macros,
we have improved our research speed in 30%. That huge!!
Using OneNote have improved our research information control (nothing get lost now) and with the sharing files abilities, now everyone can contribute to the project.
So to summary it all, we are more then happy with the tools that comes in the Office 2007.
We looking forward to the new one…
With the SP2 support for open source files,
our CRM improved since we don’t have to “fight”
with our clients anymore
The 2007 was a great investment with benefits to us.