Is there a way to automate the mail merge process? My goal is to find a process in LO that will regularly export a csv file to an FTP. Is that a thing in LO? Sorry for the Newbie question!
I don't know of a way to export directly to an FTP but you can schedule Report Writer reports to run on a schedule and it will send you a .csv that you could then upload. Once you have a Report Writer report created, just go to Run Report and then under option c you can set the schedule. By default, the report will be sent to your LO account but you can also list others under option d if someone else is going to be doing the upload.
I know our organization makes use of the DataSync but that was setup long before I started and I have no idea how that works. You could probably contact LO Support to ask about the configuration.
You might explore webservices (currently available at open.convio.com but moving soon to the developer site developer.blackbaud.com). With webservices, you can set up a data sync operation which can place the file on your ftp site and then automate the pickup.
I don't have particular expertise in automating the transfer but there are lots of automation tools available. There was a webservices session at the Nov 9th #bbdevdays conference you can watch on demand:
Have you tried the download action in the Reports Records? I'm not sure if this is what you are looking for. If you click download it will create a csv file.