Mail Merge?

  • Thread starter Thread starter @mospheric
  • Start date Start date
@

@mospheric

I need to print 170,000 small labels, quite simply numbered 000001 to
170,000. I suspect Mail Merge might be the answer if I can get the
numbers to increment by 1 for each label. (I don't know any VBA), but I
could also do with a print "From" and "To" user input facility.

Can anyone point me in the right direction, or possibly advise me on
what literature I need to be reading.

(First Post on this Board, not sure what sort of response I'm going to
get)

@mospheric

If you see someone without a smile, give them one of yours
 
If you go to the site in my signature block, select FAQ tab and then
Numbering, you will find several examples of Sequentially Sequenced numbers
using several scenarios.

--
Terry Farrell - Word MVP
http://www.mvps.org/word/

I need to print 170,000 small labels, quite simply numbered 000001 to
170,000. I suspect Mail Merge might be the answer if I can get the
numbers to increment by 1 for each label. (I don't know any VBA), but I
could also do with a print "From" and "To" user input facility.

Can anyone point me in the right direction, or possibly advise me on
what literature I need to be reading.

(First Post on this Board, not sure what sort of response I'm going to
get)

@mospheric

If you see someone without a smile, give them one of yours
 
There's a limit of 65,365 rows in Excel so it will have to be done in 3
batches

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
Suzanne S. Barnhill said:
It's easiest to create a data source in Excel. See
http://www.mvps.org/word/FAQs/MailMerge/NumberCopiesOfDocMMerge.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
Click to expand...
 
Thanks people that's a good start, especially the links referred to. I'm
using Office XP and the instructions seem to differ slightly, but I
think I've got it worked out.......:confused:
 
Doing well so far folks, just one small formatting problem. I used the
Excel solution of creating a list of numbers to merge, but I need the
numbers formatted as 6 digits, so No1 is 000001. I've formatted in this
style in Excel, but the merged result drops the leading zero's. Any
suggestions?

Thanks for everyones help so far, it's been most instructive
 
Back
Top