Excel/Word - Mailmerge Field Codes

Excel/Word - Mailmerge Field Codes

Didn't find your answer?

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.

avatar
By User deleted
06th May 2005 23:20

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

Thanks (0)
avatar
By AnonymousUser
28th Apr 2005 13:18

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.

Thanks (0)