Merge spreadsheet data into Writer form

Discuss the word processor

Merge spreadsheet data into Writer form

Postby fdsverna » Sat Nov 04, 2017 6:58 am

I've created a form in writer and I need to merge some data into it.

I've created a calc spreadsheet with the necessary data.

It's essentially a mail merge - but writer wants and address block ... I don't need an address block. So I can't get past choosing the document type. Very limiting.

Anyone know how to get data merged without having to choose a letter or email?
Open Office 4.1.1 on Windows 7
fdsverna
 
Posts: 1
Joined: Sat Nov 04, 2017 6:48 am

Re: Merge spreadsheet data into Writer form

Postby MrProgrammer » Thu Nov 09, 2017 1:09 am

Hi, and welcome to the forum.

fdsverna wrote:Anyone know how to get data merged without having to choose a letter or email?
Create a new database and use your spreadsheet as its source. OpenOffice can't perform mail merge without a database.
Open the form in Writer
View → Data Sources → {database} → {table}/{query}
Drag field names from Data Sources into document
Select desired record in Data Sources
Data Sources toolbar → Data to Fields.

If you have multiple (say 3) copies of the fields in the document, you can select three records, but you'll need to tell Writer when to fetch the next record with Insert → Fields → Other → Database → Next record → {database} → {table}/{query} → Insert → Close.

Creating mailing labels using a Calc file as data base

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 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3954
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Writer

Who is online

Users browsing this forum: No registered users and 31 guests