View Single Post
Old 03-16-2012, 11:07 AM
  #32  
babeyruth
Senior Member
 
Join Date: Aug 2011
Location: Columbia, Md
Posts: 353
Default

This is what April sent me for the last Boom.

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.

- Ruth


Originally Posted by daisey View Post
can anyone post directions on how to mail merge with microsoft word/excel...I forgot how..Ive been trying to figure it out and not doing so good..Thanks for any help I can get,,,April sent me instructions last year and they worked perfectly but I cant find them...
babeyruth is offline