I am trying to create a page of Avery labels similar to the ones you would use for an address on an envelope. I need to input a number range from 00001 to 00500 for example, and I do not want to do this manually as it is very tedious and time consuming.

How can I create a macro to do this for me and have it generate the sequence of numbers and fill the labels?

Any advice is surely appreciated! Thanks in advance!