OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Printing Address books with Merge

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
kentsin
General User
General User


Joined: 21 Mar 2005
Posts: 5

PostPosted: Mon Feb 20, 2006 6:41 pm    Post subject: Printing Address books with Merge Reply with quote

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
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Mon Feb 20, 2006 7:36 pm    Post subject: Reply with quote

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/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Tue Feb 21, 2006 5:33 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Wed Feb 22, 2006 1:57 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group