Today's author is MVP Bill Jelen of MrExcel.com . The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels. The workbook must contain two sheets, one named "Addresses" and one named "Labels". The addresses on the Addresses sheet must be arranged as one address per row, with the Name in Column A, Address Line 1 in Column B, Address Line 2 in Column C, and the City
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2010/04/14/creating-address-labels-from-a-spreadsheet-programmatically.aspx
Posted
Apr 14 2010, 04:00 AM
by
Microsoft Excel 2010