Chat Forum
10
Posts
8
Users
0
Reactions
78
Views
Topic starter
I need to create a few hundred sequentially numbered ‘vouchers’ and was hoping to do this by using Word or Excel with a minimum of 6 vouchers per A4 sheet. Googled it and didn’t get very far.
Along with a number each voucher will have a basic graphic on it along with Text.
Any ideas how I can do this and print out on a normal printer?
TIA
Posted : 24/10/2020 5:24 pm
Do a search for "creating consecutive numbered labels in word" basically the same thing.
Posted : 24/10/2020 5:28 pm
Topic starter
I’ll give it another go
Posted : 24/10/2020 5:30 pm
Set page size to A7 to give you 8 per a4 sheet. Use page number as voucher number. You can place page number anywhere on page by inserting it as a data field.
Print as many as you need.
Use print, save as pdf with 8 pages per page.
Posted : 24/10/2020 5:32 pm
Topic starter
Sounds good - thanks
Posted : 24/10/2020 5:34 pm
This is vague as it's half-remembered from years ago and I could be talking out of the top of my head, but look at setting Word's page size to 'Label' like one of the nearest Avery LaserLabels.
Posted : 24/10/2020 6:07 pm
I think a Mail merge would also do it.
Posted : 24/10/2020 6:46 pm
Topic starter
Cheers guys
Posted : 24/10/2020 7:52 pm
In excel just draw out the vouchers however may you want to a row (set print and page margin to zero, then leave some white space in the edges of the vouchers so they all cut to the same size).
Then drag/copy down. Change the voucher number to =voucher number above + number of vouchers on each row.
Then drag/copy as far down as you need.
View -> print layout, then set the blue vertical line to the outer edge of the rightmost voucher.
Posted : 24/10/2020 8:03 pm
Would it work just buying some raffle tickets?
Posted : 24/10/2020 8:44 pm
If you get stuck, email me - happy to do it in seconds for you on Monday at work.
Posted : 25/10/2020 7:22 pm
