I'm preparing a long list of labels with sequential numbers (000001 to
001000). I have no idea how to do macros. Any suggestions?
Three possibilities:
1. Use the "Plan A" part of the article
http://www.gmayor.com/Numbered_labels.htm. The article assumes you create the
labels with a mail merge, but it will work with any set of labels that you can
create with the unique text (in the article, a string of six asterisks) where
you want the numbers to be. To use the macro shown there, follow the
instructions in
http://www.gmayor.com/installing_macro.htm. To get the number
format you showed, you'll have to change one line of the macro from
myRange.Text = Format(startNum, "000")
to
myRange.Text = Format(startNum, "000000")
2. Use the "Plan B" part of the article instead.
2. Insert a Seq field in each label. To get the right number format, the code of
the field should be
{SEQ a \#"000000"}
