Mailmerge from csv into calc

[padut]

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.

[qubit1]

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

[mariosv]

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.org/en/project/FMM