We have created a Microsoft Word document (see attached) which is intended to be a label template. It is one page only which will be edited to add the information that needs to display on the label e.g. PO, STYLE NO, DEPT NO, QUANTITY.
All text is static apart from 'CARTON: XXX OF XXX' which is comprised of two fields - Page and NumPages.
We need a macro creating to select everything on page 1, display a pop up to ask 'How many labels do you require in total?' if we enter 50, then the original label will be copied 49 times.
The macro then needs to update all fields in the document so that 'CARTON: XXX OF XXX' will show the correct numbers, i.e. page 1 would show 'CARTON: 001 of 0050', page 2 'CARTON 002 of 0050' etc.
I already have a working macro (see attached) which updates all of the fields in the document, however I cannot find a working macro to select the whole of page 1 and successfully copy it x amount of times.
If you have any questions about this project please feel free to direct them to me. I think this is quite a simple project to complete.
5 freelancers are bidding on average £20 for this job
WAYMOX Global services (WGS) mainly focus on providing services to our clients on KPO, Web Designing, Data entry, Transcription and as well as Data Management for e-commerce portals and back-office o...