Base Writer Mailmerge Issue

asked 2021-04-19 05:47:10 +0200

gkick gravatar image

LO 7.1.2.2 Win 10 Hsql2.51

Hi,

Putting together a mail merge from a query to a writer document which works okay, however I am a little puzzled about Writer telling me there are 17 pages whereas the document actually only contains 9 address headers and so does the query. So the number of records match but am at a loss where the 17 pages come from and what the (p1) means. Have to admit not familiar with writer.

image description

Is this normal or a bug ? Thank you

edit retag flag offensive close merge delete

Comments

Sounds as if it is your formatting. Look what is on each of the pages. Can't see you results but seems like the original design overflowed to a second page when the merged information appeared. I believe the p. 1 means page 1 - multiple pages for each merged document. Again back to formatting.

Ratslinger gravatar imageRatslinger ( 2021-04-19 06:04:30 +0200 )edit

@Ratslinger , thanks for the quick response. I have applied no format at all, just opened a blank file, nominated the datasource and pulled down the field headers to create an address block. Also weird if I want to edit the document by inserting a space between a couple of fields I end up crashing. Only resolve is to recreate the doc

gkick gravatar imagegkick ( 2021-04-19 06:11:01 +0200 )edit

Have nothing further right now. Do not recall at this time having had that issue.

Edit:

Just did quick test with three records. All is OK unless I save all as one document. Then the three pages registers as 5 but only seems to print as three. Possible a bug although on my system it actually shows (lower left on status bar):

Page 1 of 5 (Page 1 of 3 to print)

This on Ubuntu 20.04.2 with LO v 7.1.2.2 from TDF

Ratslinger gravatar imageRatslinger ( 2021-04-19 06:18:38 +0200 )edit

Yes the merge is generated into a single document. I can live with that issue. But alas, after running the merge, closing the db and restarting, the db is no longer registered. Is there a way of re registering the db if not registered, sort of conditional register ?

gkick gravatar imagegkick ( 2021-04-19 07:25:50 +0200 )edit

If your DB is no longer registered, I have not sen this happen simply by doing a mail merge. Something else may cause this such as moving the Base file.

You can add/delete/modify Base registrations. From menu Tools->Options. Then under LibreOffice Base->Databases on the right are the registered databases with buttons to make changes.

Ratslinger gravatar imageRatslinger ( 2021-04-19 17:45:43 +0200 )edit

Thank you @Ratslinger

gkick gravatar imagegkick ( 2021-04-19 20:22:31 +0200 )edit