View Single Post
Old 09-30-2011, 09:02 AM
  #28  
LovingIzabella
Super Member
 
LovingIzabella's Avatar
 
Join Date: Jul 2009
Location: New York
Posts: 4,532
Default

Just in case anyone needs help with labels try this:
Open and save the excel spreadsheet in your documents. Open up word, click on mailings, start mail merge and then choose the step by step wizard. From the right choose labels, then next, then choose label options from right, the box that pops up 5160 is generally the 3 rows 10 per row address label format, then next to select recipients, browse and choose the excel spreadsheet, click next arrange labels click address block, match fields in the lower right, first name should be swapper name, last name & suffix not matched, company (this is optional) you can put their boardname here or not matched, address 1 will be street name, address 2 not matched, city will be city, state & zip, state & postal code will be not matched and country or region will be country. Once you select these fields click okand then ok again and then update all labels on the right hand side. Then click on next preview your labels then next complete the merge and then print on the right. You should be good to go. I would recommend not putting their board name on the labels as this may make them too large.
Hugs
April
LovingIzabella is offline