Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Eagerly awaited - for a LO working mail merge from the newly released 3.4.1

Before I did this test, I completely cleaned 3.3.3 using revo-uninstaller to ensure a completely new install.

The 1st thing I did was to view existing mail merge data files from 3.3.3 - they were still all screwed up as before. I therefore deleted them, so at to not cause further confusion and start again from new. However, I could not find a way of deleting the old files from the internal list (there is no remove button), once I looked at them.

I started from fresh, I created a standard 2 name data base for Mr Smith & Mr Blogs.

I did this with ease. Now when the MM came to the part that places the data on the letter (6. Edit Document), a few strange things happened, the address line 2, the County and Company names were not present, the post code came before the town name and the title "Mr" is on a separate line to his name.

This is where you have a learn a new "game" called shuffle and add the field names. So you go back to "3. Insert Address Block", go into edit mode and play with the arrows and create a standard address pattern (which you would have thought would be the default). I considered that this could this be deliberate (because they are so bad) - so as to force you to look and make your own? However, you will only have to do this once, as LO remembers this layout for the next time.

Then Create Salutation (tick the boxes), >Adjust layout (I did not use this), > then Edit document

In Edit Document the Field Names are deposited on your letter for the 1st time, the next thing you notice is the weird Spacing between the address lines, you cannot adjust this in the document directly (its frozen), so you have to go to the Edit Document's:- "Edit Document" > (right click)> Edit Paragraph style> indents & spacing > Below Paragraph > set to 0.00cm - This puts it back to the letter default.

Then Personalise Document (this prints all your letters) - this is where you now can see (WYSIWYG) for the 1st time, the full document that will be printed and you realise that there are no spaces or comma's between the fields hence the 1st line looks like MrJohnSmith.

To resolve this, you have to go back to Edit Document to put in spaces (and comma's). I could find no way of doing this at making / inserting address block stage, so you will always need to do this on each new mail merge.

I saved and Exited

I then realised that there were no name(s) after the salutation Dear ......, so I went back and tried unsuccessfully to insert it again, the moment you go from Edit Document (where the Dear Mr Smith exists) to Personalise Document, it disappears ( a Bug me thinks). As a work around, whilst in Edit mode, I copied & pasted the name, this (the name) stayed when I went on to Personalise Document (annoying but it worked). So I would suggest don't use "Create Salutation, make your own, by copying & pasting from the main Address block.

Also, on testing,  other previously known bugs:-

As long as you do not click the "Insert address block" on the 2nd time around (leave it greyed out), then it does not insert a 2nd address block AND the links stay in place.

Having exited again, I then edited the data base file (*.csv) by adding a new name (a 3rd name in my case), in the spread sheet format *.csv (it takes a while to find this file and remember to read it in "tab" format). Re- started the mail merge - and it Worked!! - 3 names. So names & addresses can now be entered with ease and without having to open mail merge and mass data can now be pasted into the *csv file - if you so desire!

Summary:-

Other than a few minor niggles and only the one (easy to get around) "bug", that I could find, it's getting there, but most importantly :- its usable.

John B













--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.