How do I insert a merge field by name; that is, without being connected to a database? If you’re asking yourself “Why?”, it’s because this mail merge document will be uploaded to our accounting software, which is a third-party website. There is no database on my computer with the merge fields that I can “select”. I know the merge field names I need to pull the information from our third-party vendor website. The mail merge document is used on their system, not mine. I can do it easily with MS Word by INSERT, QUICK PARTS, FIELD, MERGEFIELD.
In LibreOffice Writer I found that I could go to insert ->field ->Database(to add xlsx spreadsheet)->Mail Merge Fields(to see the sheets in the excel workbook)->the i could click on the arrow to reveal individual fields that could be inserted into my document.