ms excel help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

ms excel help

£0.00 @
in MS Word, i curently have a mail merge for 1000 labels (10 per page over 100 pages). labels on each page are printed (5 x 2) and numbered sequentially from left to right/top to bottom.   th… Read More
leitchyleck Avatar
5m, 1w agoPosted 5 months, 1 week ago
in MS Word, i curently have a mail merge for 1000 labels (10 per page over 100 pages).

labels on each page are printed (5 x 2) and numbered sequentially from left to right/top to bottom.

 

this works fine but when i cut them out ( i usually cut 10 pages at time) each bundle is out of sequence.

 

my question, is there a way to enter values into Excel that would allow me to mail merge the labels so they would be in sequence when cutting them out?

example, in excel my column values are 1 11 21 31 41 51 61 71 81 91 2 12 22 32 42 52 62 72 82 92 3 etc etc how can I auto fill these values up to 1000?
Tags:
leitchyleck Avatar
5m, 1w agoPosted 5 months, 1 week ago
Options

All Responses

(2) Jump to unreadPost an answer
Responses/page:
#1
You are using two programs to get a print-out - Word and Excel. This is probably causing the confusion. It needs to be one. You can do mail merge very easily in Word, copy and paste the details from the excel file into a Word table file and then both files will be used to print the labels. You should have precut label sheets for this and just pull the label off and stick on envelope. Not sure why your making it so difficult when it doesnt need to be. You can also specify part numbers to be printed like 100 - 250 if you dont want the whole lot.
#2
thx for your reply, i am not having problems printing out or mail merge, in fact i have 6 files with 1000 labels/tickets each ready to be printed.

My problem is with getting the numbering system in order to make cutting out tickets easier.

they are not labels as such but merely tickets handed out at work, each with a different number incremented by 1 every time.

Edited By: leitchyleck on Nov 14, 2016 09:26

Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!