Ask Your Question

mailmerge wizard - select address list - cleanup? [closed]

asked 2014-03-21 03:36:10 +0200

lspolib gravatar image

updated 2016-03-03 17:56:30 +0200

Alex Kemp gravatar image

I was playing around with mailmerge earlier today, trying to learn how to use it - and I now have a couple of bad entries in the Select Address List window that comes up when I get to Insert Address Block - Select Different Address List. I say they are bad because they have a Name, but no Table, and the OK button is gray if I select one of those lines. (Edit and Change Table are always gray. Could be because I am using a Libreoffice spreadsheet as the data table...) I have one good entry in the table at the moment.

Anyway, I just wondered if there is any way to delete the bad entries? Or delete the whole table of address lists and start over? That would be OK now, since I have very little in there - but not a good solution long term. And I could just leave them - but that seems messy too.

This is Libreoffice, running on Windows 8.1 x64.

Thanks Dan

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 17:56:44.895549

1 Answer

Sort by » oldest newest most voted

answered 2014-09-10 20:10:05 +0200

Gillian gravatar image

updated 2014-09-10 20:14:59 +0200

Just found the answer by accident!

Open a mail merge document, click File > Print > answer [Yes] on the dialog box "Your document contains address database fields. Do you want to print a form letter?"

Next, in the Mail Merge dialog box, right click the database that is currently highlighted in blue and select "Registered databases ..." from the menu

image description

You'll see a list of .odb databases, probably in C:\Users\Username\Documents\ and, whilst they won't be the original data sources you linked to, deleting these will remove the data sources from the main list (only the list; it doesn't delete the original files). You can delete them all or leave the one you want if you're sure it's the right one.

I did not have any luck when I clicked the [New...] button at this point close the dialog box by clicking [OK] and [OK] again to close the Mail Merge window.

If you need to link a new database in the main document window, click Tools > Mail Merge Wizard > click on "3. Insert address block." then the [Select Address List...] button and in the new dialog box click the [Add...] button and browse to find your new data source.

Click [Ok] and then when you get back to the Mail Merge Wizard click [Cancel] or you'll end up merging everything.

Hope that helps.

edit flag offensive delete link more

Question Tools



Asked: 2014-03-21 03:36:10 +0200

Seen: 1,484 times

Last updated: Sep 10 '14