View Single Post
 
Old 01-08-2013, 05:53 PM
Claytocb Claytocb is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2012
Posts: 5
Claytocb is on a distinguished road
Default Command Button to Print Labels

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
Reply With Quote