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

Mail Merging not working because no data source is available

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
maemst
Newbie
Newbie


Joined: 09 May 2008
Posts: 1

PostPosted: Fri May 09, 2008 3:10 am    Post subject: Mail Merging not working because no data source is available Reply with quote

I'm suddenly having the same problem as Donny Bahama http://www.oooforum.org/forum/viewtopic.phtml?p=284247 experienced although I've done many Mail Merges before: When I create a new Mail Merge, I can choose an ODS file. But when I try to select a table of the spreadsheet, nothing is displayed. I tested it with XLS and CSV files as well, nothing worked, I couldn't access any data sources. It seems like all database connections are broken. Interestingly, hitting F4 (database source browser) is not working as well.

Does anybody know how to repair this?

I'm using OOo 2.4.0 on an Ubuntu Hardy Heron.
Back to top
View user's profile Send private message
Frank Billington
OOo Advocate
OOo Advocate


Joined: 10 Feb 2004
Posts: 226

PostPosted: Wed Jun 04, 2008 2:47 pm    Post subject: Reply with quote

At the risk of taking this off of the unanswered list, I have the identical problem, also with OOo 2.4.0 on Ubuntu 8.04.

I see that the original post has been here for a while. Hopefully someone will know the answer by now.

Frank.
_________________
Single-booting Linux, all day, every day, at home and at work.
Back to top
View user's profile Send private message
Wandering
OOo Enthusiast
OOo Enthusiast


Joined: 18 Oct 2007
Posts: 190

PostPosted: Wed Jun 04, 2008 5:45 pm    Post subject: Reply with quote

It is necessary for any datasource you wish to use to be registered before OO will recognize it. Go to any OO module and

Tools
Options
OpenOffice.org Base
Databases
and add your database to the list.

It should then be recognized as a datasource by all modules.

Good luck.
Back to top
View user's profile Send private message
Frank Billington
OOo Advocate
OOo Advocate


Joined: 10 Feb 2004
Posts: 226

PostPosted: Wed Jun 04, 2008 6:31 pm    Post subject: Reply with quote

Wandering:

It is there, and it is registered. It still does not show up when I press F4. In fact, not even the default ones show up!

This is what is confusing me. I have used this document and this database before. Now, with an install of OOo 2.4 (I was using 2.3 before) pressing the F4 key does absolutely zip, and "View" menu item has no entry for "datasources".

Either there is a problem with OOo 2.4, or the Ubuntu version has a problem. I have not found out which yet.

Frank.
_________________
Single-booting Linux, all day, every day, at home and at work.
Back to top
View user's profile Send private message
Frank Billington
OOo Advocate
OOo Advocate


Joined: 10 Feb 2004
Posts: 226

PostPosted: Thu Jun 05, 2008 3:45 pm    Post subject: Reply with quote

OK, seems the problem lies with OOo 2.4. A friend has the same problem with the version of OOo 2.4 packaged with OpenSuSE. He also advises that the developers are not likely to fix it, as they are working on the release of version 3.0.

If you have 2.4 and are having problems, go back to 2.3.

Frank.
_________________
Single-booting Linux, all day, every day, at home and at work.
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Fri Jun 06, 2008 7:57 am    Post subject: Reply with quote

Try the release available directly from http://download.openoffice.org/index.html instead of the Linux customized versions. I'm using V2.4 from this source on Windows and I don't see your problem.
Back to top
View user's profile Send private message
Wandering
OOo Enthusiast
OOo Enthusiast


Joined: 18 Oct 2007
Posts: 190

PostPosted: Fri Jun 06, 2008 2:08 pm    Post subject: Reply with quote

2.4 runs fine under Vista here without your problem. I am using it under Ubuntu with similar results. Could be your distribution.

There is a toolbar tool near top right that should open all datasources, and let you attach the one you wish to your document. Perhaps that will work for you.

Good luck.
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 Writer 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