Originally Posted by babeyruth
OK, I give up, I have MS Office 2007 and nothing works, it only merges the first 3 addresses on the top line! No matter what I try! Sigh, I'll have to use my handwriting.
Originally Posted by QuilterMomma
It is going to be nice wokring with some of you gals that I have swapped with before on a few others. Looking forward to it. Now to decide which fabric to send.
On the labels question, depends on which version of Windows and Office you have. There is a help menue for Mailings in the Office 2007. See if that helps. It will take a lot to type up and I have to write it all out.
MS Word open
Mailings
Start mail merge
label - answer questions there
Then select Receipients, which will be the file April sent you. From there you will need to answer the questions on the tool bar to select the format of your information. Hope this helps a little.
:evil: :twisted: :evil: :evil: :shock: :shock:
try this:
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