help needed

[n1kki]

Hi i hope some can help, i work for an electrical company and as part of my job i have to print out hundreds of stickers that are numbered 1 - however many items a company has got, well something has gone wrong with the mailmerge that we use and i haven't got a clue what, so i'm hoping someone can help
below is part of an excel work sheet it has the numbers on that we use to number the stickers
it goes from 1 - 43 on the first row ,then on the second row it starts 36-78 then starts another row from 78 and carries on down the sheet into the 5 thousands.
In a word document we have a template of the stickers, 21 to a sheet. what normally hapeens is when we do the mail merge it merges the numbers on the excel sheet with the stickers in word. it still does that now but will only start on the second row starting at 36 rather than number one
If anyone has any ideas i would be eternally greatful.
I will try to show you an example in a post below.

thanks nikki

 

[n1kki]

numbers.xls
	A	B	C	D	E	F	G	H	I	J
1	1	2	3	4	5	6	7	8	9	10
2	36	37	38	39	40	41	42	43	44	45
3	79	80	81	82	83	84	85	86	87	88
4	122	123	124	125	126	127	128	129	130	131
5	165	166	167	168	169	170	171	172	173	174
6	208	209	210	211	212	213	214	215	216	217
7	251	252	253	254	255	256	257	258	259	260
8	294	295	296	297	298	299	300	301	302	303
9	337	338	339	340	341	342	343	344	345	346
10	380	381	382	383	384	385	386	387	388	389
Sheet1

 

[Smitty]

Have you gone back in to adjust the Mail Merge? It's possible that Word now sees your first row as a header row and is excluding it.

Hope that helps,

Smitty

 

[n1kki]

ELECTRICAL SAFETY TEST

Serial No. By GL/SS/KS/DS
«M_1»

TEST DATE NEXT TEST DATE
DECEMBER 04 DECEMBER 05

PASSED


this is a copy of what one of the stickers looks like in word.
I can figure out how to do the html thing in word soory.

thanks nikki

 

[n1kki]

It mentioned something like that how do i change it


nikki

 

[Smitty]

Have you tried to insert a row at Row 1 and see what happens?

Smitty

 

[n1kki]

Hi
i tried that but it still starts at 36
you'd think with another row above it would start at number 1 but it doesnt.

nikki

 

[n1kki]

Anyone else have any idea wots up with it.

thanks nikki