create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

users
#1

HI,
i'm facing a problem which doing mailmerge without using BASE to registered
to the data source.
i did successfully do it with base but now i do not wan to using base to
registered the data from spreadsheet table librecalc because i wan to edit
the spreadsheet data table easily for me to remove or del or update new
data...
may i know is there any solutions TQ
i have try using file -> wizard-> address data souirce-> other external data
source -> no SDBC driver found

#2

Hi Sonic,

I would think you could register the new database in the spreadsheet by going to tool>options>LibreOffice Base>Databases. I've never tried that though. I know it works for odb files.

Don

#3

Hi :slight_smile:
It 'should' be reasonably easy to update, delete or add new records to an address book using Base.  Is it possible to use a different connector to your data?
Regards from
Tom :slight_smile:

#4

Once you have registered in Base as spredsheet, you can do the modifications directly in the spreadsheet without using base.
Only the registration in base is needed.

Maybe this extension (FastMailMerge)is what you need:
http://extensions.services.openoffice.org/en/project/FMM

Miguel Ángel

  * Inglés - detectado
  * Inglés
  * Español

  * Inglés
  * Español

  <javascript:void(0);>

#5

Dear Tom,
yes my problem is after i using spreadsheet creating a data table ,however than registered in data source,
now i wan make an easy ways if i wan to edit the data which in table but already registered in data source, but i got no ways to edit the data table in the data source , how to do it without opening librercalc and reedit the table on the spreadsheet and redo the registered in data source.
is possible to use other connect for my data as long as the ways doing it is easy =) hope u can help TQ

#6

Hi Sonic,

may i know is there any solutions TQ
i have try using file -> wizard-> address data souirce-> other external data
source -> no SDBC driver found

Have you tried with LibreOffice 3.5RC2 ? There were known issues on some
OSes with previous 3.4.x versions.

Alex

#7

hi alex,
I had try libreoffice 3.5RC2 but problem same.. in linux version,
but i tested 3.5RC2 windows version it solve the problem....
do u have any ideal on linux version ?

#8

anyone can help pls

#9

Have you with the stock 3.5RC2? No, I'm not being factitious or
disrespectful... but you keep claiming that this all works with your own
build from Master & I'd appreciate an answer.

#10

It's a problem that I doubt will be solved anytime soon.

Your best bet is to simply use a Calc spreadsheet, open that with the
MailMerge Wizard, and go from there. With that you neither need Base or
Java.

#11

HI NoOp
BRO,
YES go to FILE wizard-> address data source ->this connection to external
data source could not be establish.NO SDBC Driver was found for the given
url.
NO SDBC DRIVER FOUND FOR LIBRE OFFICE 3.5RC2 linux version
or LIBRE OFFICE 3.4.5 as well linux version.

HOwever only Libreoffice 3.5RC2 Windows version can function for data
source.

Else have any alternative ways using librebase only to do mail merge
regards,
sonic

#12

Hi,

Have you with the stock 3.5RC2? No, I'm not being factitious or
disrespectful... but you keep claiming that this all works with your own
build from Master& I'd appreciate an answer.

It even works for me with :
LibreOffice 3.4.5
OOO340m1 (Build:502)

Provided by Ubuntu from the Oneiric repositories.

I clicked on Other external data source, then Parameters, and chose Spreadsheet. It appears to work fine, as in I can thereafter press F4, select a tuple from the table, copy it into a Writer document, the merge data wizard starts up, and I can choose how I want the data merged.

Alex

#13

ALex,
hi are you refering to windows version or linux if windows version yes it's
working, but i'm using linux version is not working ? LibreOffice 3.4.5
OOO340m1 (Build:502)

#14

Hi Sonic,

ALex,
hi are you refering to windows version or linux if windows version yes it's
working, but i'm using linux version is not working ? LibreOffice 3.4.5
OOO340m1 (Build:502)

As I said in my mail "provided by Ubuntu", i.e. Linux version.

Alex

#15

Hi Alex,
FYI, We also have been tested on
LibreOffice 3.4.5
OOO340m1 (Build:502)
installer is download from www.libreoffice.org
deb installer
now going to try RPM installer
Currently i'm using Ubuntu 10.04 LTS
sorry i'm newbie in linux ubuntu very sorry about that ... for complaining a
problem

#16

Hi Sonic,

Currently i'm using Ubuntu 10.04 LTS
sorry i'm newbie in linux ubuntu very sorry about that ... for complaining a
problem

No problem, I didn't feel you were complaining, we just need to try and get to the bottom of the problem.

Alex

#17

Am 28.01.2012 04:39, sonic wrote:

HI,
i'm facing a problem which doing mailmerge without using BASE to registered
to the data source.

This is impossible. Mail merge reads data from a registered Base file regardless of any file formats.
For various reasons, spreadsheets are by far the worst choice for list keeping. A most simple dBase file performs much better and can be edited directly in the data source window without opening nor saving any document at all.

#18

Am 01.02.2012 05:21, NoOp wrote:

Your best bet is to simply use a Calc spreadsheet, open that with the
MailMerge Wizard, and go from there. With that you neither need Base or
Java.

As a matter of course, the wizard creates a Base document.

#19

Am 28.01.2012 17:46, sonic wrote:

Dear Tom,
yes my problem is after i using spreadsheet creating a data table ,however than registered in data source,
now i wan make an easy ways if i wan to edit the data which in table but already registered in data source, but i got no ways to edit the data table in the data source , how to do it without opening librercalc and reedit the table on the spreadsheet and redo the registered in data source.

Your data are still in the spreadsheet, editable in a spreadsheet program.

#20

Hi bro,
Do you have any alternative ways to do in libre base.. directly is there any tutorial for doing mail merge in libre base.
yes i found out already can upgrade or edit data in spreadsheet after registered the spreadsheet in base..
TQ
regards,
sonic