I'm using LibreOffice Version: 5.1.6.2
What I'd like to do is to take an existing writer document that has a bunch of text in it & personalize it based on information that I have in a spreadsheet. However, this isn't a form letter type of document. So, what I'd like to do is to have various fields like price, industry, business name that I insert where relevant in the writer document.
I want to pull that information from the spreadsheet into the document. Then I'd like to create a final document where I can save each file individually based upon the number of rows in the spreadsheet.
I've been having not so good success trying to do this with the Mail Merge wizard (and without) & I figured that I would ask for guidance on the best way to do this.
Does anyone have any suggestions on how to do this?
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].
[Solved] Merge spreadsheet data into Writer file
[Solved] Merge spreadsheet data into Writer file
Last edited by MrProgrammer on Sun Dec 27, 2020 11:05 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
NeoOffice 2.2.3 with MacOS 10.4
Re: Merge spreadsheet data into Writer file
I'll suggest reading this old but still applicable article on mail merge http://www.freesoftwaremagazine.com/art ... office_org. It should help answer your questions.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Merge spreadsheet data into Writer file
You have just described a form letter.anhnn1234 wrote:I'd like to create a final document where I can save each file individually based upon the number of rows in the spreadsheet.
Create a database whose source is your spreadsheet. Insert → Fields → Other → Database → Mail Merge Fields → {database} → {table} → {field} → Insert. Repeat as needed to select all fields. File → Print → Form letter? → Yesanhnn1234 wrote:I want to pull that information from the spreadsheet into the document.
Similar topics with various solutions which you could use instead:
Create multiple documents from database?
Merge spreadsheet data into Writer form
Reports?
Read about Mail Merge in Help → Index or in User Guides (PDF) or searching for topics about it (there are hundreds) in the Calc Forum or the Writer Forum.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).