Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2015, 04:29 PM
dmlongo dmlongo is offline How to? Please help! Windows 8 How to? Please help! Office 2013
Novice
How to? Please help!
 
Join Date: Jan 2015
Posts: 1
dmlongo is on a distinguished road
Default How to? Please help!

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!
Reply With Quote
  #2  
Old 01-08-2015, 09:55 PM
Guessed's Avatar
Guessed Guessed is offline How to? Please help! Windows 7 32bit How to? Please help! Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Use a SEQ field
eg {SEQ mynum \# "00000"}
where the field braces are put in by pressing Ctrl-F9. Copy and paste the field as many times as required and select them all and press F9 to update them.
Reply With Quote
  #3  
Old 01-08-2015, 11:26 PM
gmayor's Avatar
gmayor gmayor is offline How to? Please help! Windows 7 64bit How to? Please help! Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

For some alternative methods, see http://www.gmayor.com/Numbered_labels.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
Old 01-10-2015, 09:01 AM
Bobbye Rhea Bobbye Rhea is offline How to? Please help! Windows 7 32bit How to? Please help! Office 2007
Novice
 
Join Date: Jan 2015
Posts: 2
Bobbye Rhea is on a distinguished road
Default

This is exactly what i needed, Thanks for this post it's really a big help.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft