Printing Address books with Merge

kentsin · General User Joined: 21 Mar 2005 Posts: 5

I have a csv export of address book. I want to print the address book to paper.

I use to do this in Word, but I want to learn the open source way. In word, I will create a merge form which allow records follow one by other. Then I set the formating rules such that they only break between records. Then I will try to Insert more space between records to allow futher handwrite additions.

However, when trying to do so in OOO, I was:

unable to import the csv files:

The merge function in write seems not able to open the csv file directly;
base can not import the csv file without first create the database table (which is rather troublesome with all the fields defined in csv already)

I wan unable to do such a merge also, it seems that merge in write only merge to printer, pr mail not to a new document.

Is it possible to do this in OOO?
_________________
kentsin

DrewJensen · Posted: Mon Feb 20, 2006 7:36 pm Post subject:

Not sure this will do what you want, and perhaps you have already found it.

You can create a base file that is of type TEXT.

File>New>Database

On the first page of the wzard select 'Connecto to an existing database'
In the drop down list select type of TEXT

Set the options for your csv file on the second page of the wizard
path to the files
'Comma seperated CSV file
Delimiters.

Save the file.

When you open it the csv file should be available without you needing to do any further editng to it.

Once this is done you can use the standard mail merge functionality of writer to bring the records into a file.
_________________
Blog - http://baseanswers.spaces.live.com/

JohnV · Posted: Tue Feb 21, 2006 5:33 am Post subject:

After you follow Drew's advice to register the csv data source see this link for an easy way to get it on paper.
http://www.oooforum.org/forum/viewtopic.phtml?t=32152&highlight=

There are other ways that will let you do formatting but I'm rushed right now. Respond here and I will show you more if needed.

MSPhobe · Posted: Wed Feb 22, 2006 1:57 am Post subject:

There is a "How to do mailing labels" tutorial among my introdutory guides, which are at....

http://sheepdogguides.com/fdb/fdb1main.htm

(There's also information on importing csv files.)

Tom