Command Button to Print Labels

[Claytocb]

Hello,



Looking for a VBA code that will allow a user to click and print an address label using the information entered into a cell range. For example, have a cell range that contains Company Name, Address, City, State, Zip. When user clicks the command button the information in these cells will create an address label with this information. I assume the code would have to open MS Word. I also assume this would be similar to mail merge.. but looking for a way to automate this with a command button..

Thanks

[macropod]

Hi Claytocb,

Unless you're prepared to waste a lot of label stationery, want a full page of the same label, or have a label printer, a lot of code would be required to send the printout to a specified label, regardless of whether Word was involved (though I see no particular reason that it should be).