Discussion Locked

Word Address Labels

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I recorded a macro to generate address labels and pasted the code created into VB. When I run the macro in word I get 3 columns, which is what I want. The problem is that when I run the code from VB, I get one column and the wrong size of the label.What can I do to make sure that I get a correctly formated address label report? How do I specify the label size, my default printer uses A4 page size paper?

3 replies

by dklippert

Record a "Tools>Envelopes and Labels" macro in Word and look at the code. You'll see which template is used to produce the labels you need. The templates will use A4 paper if that's the default printer.

This discussion is closed to new replies.