Ask Your Question

changing formatting using mailmerge

asked 2018-10-01 11:44:17 +0200

aj gravatar image

updated 2018-10-01 11:45:03 +0200

I am making a set of id cards with participant's name and details on it (in writer). Participants are grouped into a dozen categories based on their choices during registration. All these info are available as an ODS spreadsheet file. I want to change the background color of the id card based on the each person's group. The color can be made available as an additional column (in words or as hex format) in the ODS spread sheet.

Is there a way I can use mail merge to set the background color of the page or a table based on a field in the record?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-02 00:31:58 +0200

I believe that what you want to achieve is only possible using several mail merge templates (with required settings), and then doing mail merge on a subset (filtered set) of records.

edit flag offensive delete link more


Thanks. I ended up doing this. I will wait for any other options before accepting this as an answer.

aj gravatar imageaj ( 2018-10-02 05:25:21 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-01 11:44:17 +0200

Seen: 23 times

Last updated: Oct 02 '18