Mail Merge with data from Google Spreadsheet

Discuss the word processor

Mail Merge with data from Google Spreadsheet

Postby jhammon1 » Mon Dec 16, 2019 6:51 am

I have created a letter in OO Writer and have address data in Google sheets. I cannot figure out how to use mail merge from that data source. I always get message that it cannot open the data source. What do I need to do do? Thanks for help!
Open Office 4.1.6 on Windows 10
Posts: 1
Joined: Mon Dec 16, 2019 6:43 am

Re: Mail Merge with data from Google Spreadsheet

Postby John_Ha » Mon Dec 16, 2019 2:37 pm

See Chapter 11 - Using Mail Merge in the Writer Guide.

You need three things

1. a spreadsheet with the data
2. a database file which must be registered
3. a letter with fields to accept the data.

Come back if you have problems or, preferably, search the forum for 1,265 threads about Mail Merge and labels.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 7785
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Return to Writer

Who is online

Users browsing this forum: No registered users and 14 guests