Data Merge Error when using a DB created from a Spreadsheet

[StevieBlueboat]

I created a DB from a Spreadsheet to use in a Mail Merge. It worked fine after inserting the fields into the letter by drag and dropping the column names. I am able to print the letter, all seems to work fine. However… even though everything is saved when I close out the letter, when I bring up the merge letter again, it cannot find the database table again (Sheet1). I get the following error message.

When I hover over the field that was inserted, the address seems to be fine.

I have deleted the registered databases, and have redone everything over again, each time with the same results.

Help is appreciated!

Thank you.

[Ratslinger]

Hello,

Just tested this without issue using:

Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

On Ubuntu 20.04.3 Mate

I see you are using Windows but which one? Which specific LO version? Is the Base file just a link to the Calc file?

[RobertG]

Could it be something like bug 124680 ?
Do you see the Calc-file in the path, which appears in the dialog you posted?

[StevieBlueboat]

Sorry about the delay in replying. I got an old fashion respiratory flu virus, and was down for the count for a couple weeks. (It wasn’t the Big C).

Anyway, here are my Windows and Libre versions. This is a corporate computer, so I am not able to upgrade stuff without them doing it. The issue I’m having is that things used to work, but now they don’t.

Thanks.
/Steve

[StevieBlueboat]

I think I found the problem.

A few weeks back, I put the Merge documents on Google Drive. That is when I started having this problem.

Today, I started anew creating a folder on the Desktop independent of Google Drive. I recreated the spreadsheet, database and the merging documents, and things now seem to work fine. So, it seems to me, Google Drive must be mucking up the file addresses.

At least that is my hypothesis, hoping this problem does not crop up again.

Thanks, everyone, for the feedback.

/Steve