As the topic suggests, I want to know if it’s possible to have information from Calc/Excel which contains names, emails and say phone numbers, and have that automatically fill out a premade form in Writer/Word in which I can just select the name for?
Say the form on Writer/Word has a pre-made form that has
Name:
Email:
Phone Number:
and by connecting to the said Calc/Excel spreadsheet full of information, I can just search for the name and all the information would be filled out as the form follows.
Is this possible?
I’m utterly new to using LibreOffice/Microsoft 365, I personally want to learn it so I can maybe improve the work flow a bit better, I have never fully explored the Office era when I was younger as there was zero need for it until recently.
Any type of video source that could also explain it would be beneficial to me in the long run or a detailed run down on how to make that happen would be greatly appreciated.