Ask Your Question

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

asked 2018-10-09 20:07:19 +0100

Tammymome gravatar image

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.


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-10-09 20:22:14 +0100

Ratslinger gravatar image

updated 2018-10-09 20:34:21 +0100


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.

edit flag offensive delete link more


@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.

Ratslinger gravatar imageRatslinger ( 2018-10-10 18:12:16 +0100 )edit

answered 2018-10-10 13:21:12 +0100

Tammymome gravatar image

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?

edit flag offensive delete link more


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

Ratslinger gravatar imageRatslinger ( 2018-10-10 18:08:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-09 20:07:19 +0100

Seen: 52 times

Last updated: Oct 10