Previous:
Next:

Workaround for the broken Mail Merge Wizard in OpenOffice

Open Office Mail Merge Wizard

Having just spent about eight hours trying to get my first mail merge to work, I thought I’d post the workaround here to save others a lot of head bashing. (There seems to be virtually no acknowledgement of the problem anywhere on the internet).

The Mail Merge wizard in OpenOffice is broken. It is broken in OpenOffice 3.0 (both Windows XP) and Linux and in OpenOffice 2.3.0 (Windows 2000).

The workaround

  • Open the document you want to merge in OpenOffice Writer
  • Go to View > Data Sources
  • Find your database in the left pane of the window that just opened up
  • Select your database
  • Drag and drop the fields you want into the places where you want them in your document
  • Now that you’ve worked around the broken part of the Mail Merge wizard, open the wizard (Tools > Mail Merge Wizard) and go straight to step 8. OpenOffice will perform the mail merge. When the merge has finished just select the appropriate radio button and make your final choices. It works both for letters and email. Hooray!

I didn’t need to personalise any of the individual documents so I’m not entirely sure how it would work. One way (for letters) would be to save your output and personalise manually afterwards. I can’t see any way to make this feature work for email.

I hope this was helpful to you. If you have any comments that could be useful for other people, please add them below.

Spread the word:
  • Facebook
  • del.icio.us
  • email
Previous:
Next:

Further Resources

Here are some ways I can help you further.

Wherever you live

  1. If you’re not already getting my free weekly article delivered to your inbox, then go here to get it.   Subscribe to “Back in Action”  (It’s free)
    When you subscribe you also get to download “The Hows & Whys of Semi-Supine”. This free e-booklet is indispensable to anyone serious about strengthening their bad back (or further strengthening an already-strong back).
  2. Repoise is our membership site for people who are serious about improving themselves (and getting out of pain as they do that). When you join, you will:–
    1. Have daily access to me. Together we will work out what’s going wrong for you and how to fix it
    2. Learn from reading other Repoise members’ questions and following their progress as they work with me
    Find out more about joining Repoise here.
  3. I’m writing a book about my work. It will come out on the 1st December 2010. If you're getting the free weekly articles, I'll send out more details about the up-coming book as soon as the information is available.

If you’re in Liverpool (or can get to Liverpool)

  1. I’m also running Friday lunchtime group lessons. Go here for details.
  2. There’s nothing better than individual lessons. Ring me on 0151 708 6172 to talk to me about booking individual lessons. (Leave your number so I can get back to you).

If you’re further away and can’t get to Liverpool

  1. There’s still nothing better than individual lessons. Here’s where you can find a teacher near you in the UK or elsewhere
  2. I suggest you also do the things I listed above for everyone:–
    1. Read my weekly articles
    2. Get direct day-to-day guidance from me by joining Repoise.
    If you’re having plain Alexander Technique lessons from someone else, you still need to learn the Smiling Back Method of the Alexander Technique. You’ll get a lot more out of your lessons when you do.
Previous:
Next:
January 25th, 2009 in Unrelated stuff

Leave a Reply