1

I have an Excel sheet like in this example

example 1

Each row (labeled "Name n") is a person and the columns are the data related to it (Data 1, Data 2, etc., until "COD"). What I need to do is to print a single page for each person containing its data. Referring to the example above, I need to get something like in the below example, repeated for each row (person) and I would like to be able to set the page layout as needed.

example 2

How can I do it? Thanks.

4
  • Your easiest way is probably to use mail merge option of Word, there you can set up your template and automatically fill the data from Excel, one page per row. support.office.com/en-us/article/… and support.office.com/en-us/article/… Commented Jun 16, 2017 at 12:55
  • @KevinAnthonyOppegaardRose this is a valid question, without knowing Excel it's really difficult to find the good direction. Commented Jun 16, 2017 at 12:57
  • @KevinAnthonyOppegaardRose You are right, but Excel and Word are, at least for me, two of a series of extremely large softwares where even the smallest task might be a bit difficult if you have never done it before. What I asked was just a cue from where to start.
    – Dadex
    Commented Jun 16, 2017 at 13:19
  • Infact as @MátéJuhász suggested, mail merge is the solution I was looking for. It works perfectly. Thanks a lot!
    – Dadex
    Commented Jun 16, 2017 at 13:19

1 Answer 1

0

As I've mentioned in the comment, the right tool for you is to use Word's mail merge feature (official help here and here).

There you can set up a template, then fill it with data from Excel, one page from each row.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .