Page 1 of 1

Mail Merge with data from Google Spreadsheet

PostPosted: Mon Dec 16, 2019 6:51 am
by jhammon1
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!

Re: Mail Merge with data from Google Spreadsheet

PostPosted: Mon Dec 16, 2019 2:37 pm
by John_Ha
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.