bastrax.blogg.se

I my case, I made a copy of addresses.csv, named it a.csv, and moved it into the temporary folder. Make a temporary working copy and name the copy using a single-character file name. In my case, the folder is called temp and it was created on the desktop.Ĭlose the original address spreadsheet if it’s currently open. Sample address spreadsheet in LibreOffice CalcĬreate a temporary folder to hold the working files, which can all be deleted afterwards. The exact structure of the spreadsheet doesn’t matter, but using fewer columns makes layout easier, so one could also use a single column for full name and a single column for city, state and zip if that makes more sense. My example file is called addresses.csv and contains columns for first, last, address, city, state and zip. These instructions work with version 5.4.5.1.īegin with a spreadsheet of addresses. MailMerge in LibreOffice is somewhat fiddly and the recommended method seems to change from version to version. I only need to do this once a year, and every year I forget how.