double quotes from Excel to Word mailmerge

Hi,

I'm trying to do a mailmerge from Excel to Word 2000. The data includes some rather cryptic codes (after laying a truetype over the mergefield it will become a barcode) an can contain things like :

„„" (two lower double quotes followed by an upper double quote)

Now Word seems to ignore all lower quotes before an upper quote in a mergefield, which messes up my barcode. I know I can escape upper quotes but that doesn't work with lower quotes.

The only way I've been able to solve the problem is by importing the Excel table into a Word .rtf but that isn't very efficient when dealing with about 20.000 records in the data source.

I'd be very grateful for any ideas or hints on VBA code that may resolve the problem.

Thanks in advance

Christian

:wave: