I'm trying to use the Mail Merge Wizard and can't get past the Select Address List

Asked by Judy Fort on 2011-11-13

I have a form letter complete with address data fields from a MS file, saved as an .odt file. I have also tried to create a 'letter' from the Mail Merge Wizard. Either way I can't get past the 'Select Address List' window. I have an address data base MS file, saved as an .odt file. I also created a database file from the Wizard. 1. I have only been able to create one address block. The arrows don't hi-lite to allow me to create a 2nd one. 2. When I choose either data base file, the 'Ok' button doesn't hi-lite, nor the 'Next' button.
Maybe it doesn't recognize the data fields in the letter file (originally created from MS) but I don't seem to be able to create a new letter, creating new data fields in ubuntu's mail merge wizard.
I'd like to be able to merge my original, complete letter file and data base file, with the click of a button!
Thanks,
Judy

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2011-11-15
Last reply:
2011-11-30
Tony Pursell (ajpursell) said : #1

Hi

I suggest you read this FAQ (I wrote it). Although it describes Labels rather that a Mail Merge, the description of how to set up a spreadsheet as a data file will help you.

As far as I know, OpenOffice cannot use tables in text files as data source like MS Office can, so you will need to transfer your data into a spreadsheet. You can do that by selecting the whole table and merely copying it into a spreadsheet.

Hope that helps.

Tony

PS If this answers your question, please mark it as Solved. If you need more help, don't hesitate to ask.
FAQ #1433: “How do I print Labels from data in a spreadsheet?”.

Tony Pursell (ajpursell) said : #2

A further point...

I don't know if data field imported from a MS document to and odt will work. Unfortunately, I do not have the means to test it.

If you open a new text document, and press F4, for data sources, then select the data source created as above, you can drag and drop the column headings onto the document to create data fields.

Tony

ahambidge (ahambidge) said : #3

Hello,

You should download the free Full Circle Magazine at: http://fullcirclemagazine.org/

The last few issues have a section on how to use LibreOffice.

There are also lots of other articles related to Ubuntu.

Regards,

Allan :)

Tony Pursell (ajpursell) said : #4

Hi again,

This is the issue of Full Circle Magazine you need:

http://dl.fullcirclemagazine.org/issue52_en.pdf

That is the link to download the pdf of the English version. The article is on pages 16-18. It refers to LibreOffice but the instructions will be the same for OpenOffice.org.

Tony

Judy Fort (judy-l) said : #5

Hello Tony,

Thank you ever so much for your response.
I have spent a good part of the day on this and in the end I've had to
insert addresses by hand. I had to get the letters out today. I'm not
sure when I will get a chance to look at it again but I haven't given up!
I will be in touch and hopefully be able to remember what all I did today.
Thanks again,
judy

On 11-11-13 02:41 PM, Tony Pursell wrote:
> Your question #178646 on openoffice.org in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/178646
>
> Tony Pursell proposed the following answer:
> A further point...
>
> I don't know if data field imported from a MS document to and odt will
> work. Unfortunately, I do not have the means to test it.
>
> If you open a new text document, and press F4, for data sources, then
> select the data source created as above, you can drag and drop the
> column headings onto the document to create data fields.
>
> Tony
>

Launchpad Janitor (janitor) said : #6

This question was expired because it remained in the 'Open' state without activity for the last 15 days.