Formula to help mail merge

have found the wizard. Where do you tell it what order you want the labels in?

sorry to be nuisance

That I don't know -- I've never used the wizard. I just insert the fields manually. Did you do that?

done all the fields but cant do the order you have any idea how to do the excel formula method?

I don't understand. You insert the fields in which you want them to appear. Here is a Word doc ready to be merged with the Excel doc.

Is not the order of the fields is is the order of the records. Using your example I could have 2000 addresses and want to merge them so there are 8 on each page. If I print them and then want to order them I have to guilotine them and then stack them in order. This would take hours. What I want to be able to do is have the first record (address) in the top left of page 1 and the second under it in top left of page 2 (position 9). This then goes through to page 250. The 251st record would go in top right and then 25nd in top right of page two and so on. This means that when they are guilotined they are are all in order and one pile can go on top of the other.

Therefore I need to have a formula in a hidden column which puts row 1 as 1, 2 as 9 3 as 17 down to row 250 as 2000, then 251 as 2, 252, 10 and so on.

It does however need to be linked to how many rows there are as may not be exactly 2000.

Hope this makes it a bit clearer.

Many thanks for your help so far

How about posting a workbook that shows your data as you have it now, and a portion of it as you need it -- after confirming that if you get it as shown, it does indeed merge properly.

I have attached part of the workbook. The first sheet is the original order and the first column contains the numbers I want the formula to calulate so it can be sorted as it is in the second sheet.

You can see that seat 1 for Chemistry (SS) is no 1 and seat two is 9 and so it will appear in the same place but on page two as there are 8 records for sheet.