For many years we have produced Invoices, Statements, Chasing Letters, Quotations, Tenders, etc. using Word by mailmerging information from Excel spreadsheets.
When we upgraded to XP we found that instead of "£1,234.00" appearing, we got "1234", and instead of " ", we got "0". This is due to the change to NT-protocol, or something.
No mention of this problem, or how to overcome it has come from Microsoft, but I gather we have to go back to basics and learn 'Field Codes' which have to be inserted at each point a merged figure is to appear.
Does anyone have a detailed list of these Codes and a simple guide how to enter/use them, together with the associated 'if, then, else' Functions?
Brian Ollis
Replies (2)
Please login or register to join the discussion.
An alternative...
If it helps, I recently used a product allowing you to mailmerge entirely in Excel (where you can easily control formats of numbers).
You can download it from http://patools.co.uk
if I have got this right...
...then go to Word's help function and search for switches. Should give you what you need to know about formatting merge fields.