Ask Your Question
0

mailmerge from csv into calc [closed]

asked 2013-02-04 00:21:22 +0200

padut gravatar image

Hi,

I have a csv file (name;address;nbr_of_days;price_per_day).

I want to mailmerge this into a Calc document. In that calc document I have a simple formula in cell B1 = A1 * A2. Now I want to create several files : one for each record in the csv (that I already have put in an odb). The value of nbr_of_days should go into cell A1, and will be used in the calculation for B1.

Currently, when I drop a field (after pressing F4) from the ODB to my spreadsheet, I get a Text Editbox. But instead I want that value to go into cell A1, so it gets used in the calculation. Used to create basic invoices from csv, but with possibility to add stuff before printing.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 04:36:23.260595

Comments

@padut -- Are you still looking for an Answer to this question? Did mariosv's Answer help you out?

qubit gravatar imagequbit ( 2013-03-10 04:51:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-02-04 02:48:37 +0200

m.a.riosv gravatar image

Hi padut,
I think without develop a macro program you ca not do it in calc, mail merge is for run in writer.
But you can import the csv values in calc Menu/Insert/sheet or sheet from file. do the calculation you need in calc and use calc (after register as database) as source of the mail merge in writer.

I think this extension can help, to an easy use the spreadsheet as mail merge source. http://extensions.services.openoffice...

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-02-04 00:21:22 +0200

Seen: 441 times

Last updated: Feb 04 '13