Excel Sheet

[acerview]

I have a Excel database in xlsx format (hereafter called "Sheet1"). I entered each case in one row. And I used it as for my mail merge (hereafter called "Case Progress"). I used the "Sheet1" to merged into the "Case Progress". I would like to put each case (xslx) in each page of the Word document so that it will print out case by case on each page. I made a table (One case one page) in "Case Progress" and used next record function to merge all data from "Sheet1" to "Case Progress". It works.

Now, I have to put the case progress to the word document for each of the case. And after case concluded, I should delete that case. However, as part of the information in "case progress" were manual entered and part of the information were merged from "Sheet1". If I delete the entire row, the case in "Sheet1" will match the incorrect manual entered information.

I tried another method by using a new Sheet ("Sheet2") in excel. And I used "=Sheet1!A2" as copy the database information to the "Sheet2". However, it cannot be put as consecutive number because I merged some cells as one cell. When I used click and drag function, it missed many cases.

Can anyone help me in this regard?

 

[mole999]

word mail merge can be started from a set record, so you have no need to deleted the lines from excel.

merging cells looks pretty but causes issues, try unmerging and then use the format centre across selection