I have a standard form letter template that I want to generate from a different CSV file every time (though the columns and data are always structured the same). I have a lot of fields throughout the text, so its quite onerous to have to click on each one every time to remap the whole thing to the new CSV file. Is there a way to just merge leaving the same field tags in the text, and just specifying the new file once for each batch? Or even a way to do it via command line, or a script perhaps?
This means the first line with the names of the columns doesn’t change?
.
IMHO the easiest solution on the command-line is to have a registered datasource say currCSV wich points to somepath/mycsv.csv so I can just copy any csv with same structure to mycsv.csv and use the contents of the file in mail-merge.
1 Like
Right - the column names wouldn’t change.
Writer menu:Edit>“Exchange Database”
Pick another table from the same csv database.
IF the column names would change, create a query with the right column aliases and use that.