Search code examples
javams-wordoffice-2007mailmerge

What is the best format to use when creating a mail list for use in a Word 2007?


I'm writing a web app (Java) which allows users to select contacts. The contacts details can be downloaded (currently in CSV format) and used to perform a mail merge in Word 2007.

I would like to use a format which is a bit more 'robust' than CSV. Those of you in non-English areas will know the comma/semicolon problems!

Which format would you use?


Solution

  • I prefer TSV (Tab Separated Values) for this sort of task. I have never encountered a dataset containing literal tabs that were desired in the output.