Trying to create an address directory using mail merge with a database. Word does this nicely, cant figure out LO

I need to be able to merge a database creating an address directory where I can define where FNAME1 FNAME2, ADDRESS, PHONE, EMAIL1 they are to be placed in a document. also it needs to print on one page not individual pages. I did this very easily in WORD but am trying to move it into LO. Wondering if this is possible?

This would be one member and the others would continue to print below. In desperate need of help!!! Thanks in Advance.

LAST NAME FNAME1 FNAME2
EMPLOYMENT1 EMPLYMENT2
PHONE PHONE
ETC.


Hello,

The LO documentation has specifics on how to do this. See → LibreOffice Writer Guide. Details are in Chapter 14 - Mail Merge.

This chapter does explain how to create & register an address data source.

The LO documentation page given above has documentation for all the modules - Calc, Base, etc.

@Tammymome Have seen you comment about being unclear. Please state just what you have done and what you specifically don’t understand. The documentation is clear based upon what I see in your question. Also, if you are dealing with a LO spreadsheet it is Calc not Excel - that is MS Office.

Thank you however I’m still unclear. I’m able to pull my database in from excel with no problems, I don’t know how to layout the page for my directory. It seems to be limited to envelopes, label, or letters, is there something else i’m missing?

Please do not respond with an answer. Answers are to respond to original question. Instead use add a comment. Please delete this answer.