Boomerang Friendship Swap 7.0 Now Closed for Sign-ups!!Mailing deadline is July 15,
#254
can anyone send me instructions on how to do a mail merge with excel so I can print out labels. I have been sick with divriticulitis and all my fat 8ths are cut but I wont be mailing until Monday. You can send the instructions to my private email if you wish...Thanks so much for any help. I dont do it ofetn enough to remember.
#255
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.
This was posted to the Water group by Ruth. Worked for me.
Debra
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.
This was posted to the Water group by Ruth. Worked for me.
Debra
#256
Super Member
Join Date: Jan 2011
Location: Wyoming in the summer, Florida in the winter
Posts: 7,583
Just an update: scrapquilt, Abby's Mom, abonda,Cyndi H, dove911 and goldendog55 I got your fabric today and will start working on your blocks. Just so you know, those of you that only put a 45 cent stamp on your envelope, I had to pay 20 cents more to get your material. Please when you send back your blocks, have the postage checked. Thank you
#260
dove19 and scrapquilt...I hate to tell you this, but when your envelopes get to my post office the mailman will pay the extra 20 cents. The reason they charge 65 cents is because they hand cancel soft items because they get caught in their machines. A lot of the post office employees just test the little slot to see if they go through...they don't even think about how many of them get torn open and shipped in post office "body bags". When I get home tonight I will take a picture of one of the regular size envelopes after it went thru their machine.The post offices across the country do things differently, that's why the discrepencies. I know this subject has been beaten to death...I'm just trying to help people understand why they should just buy the 65 cents and get it over with. Having said all that...I will gladly pay the extra money to get my squishie from you...I will never send them back.
Thread
Thread Starter
Forum
Replies
Last Post
LovingIzabella
Member Swaps and Round/Row Robins
2099
08-05-2012 10:39 AM
Dagny
Member Swaps and Round/Row Robins
297
03-06-2012 09:26 AM
LovingIzabella
Member Swaps and Round/Row Robins
317
05-11-2011 02:41 PM
barbsbus
Member Swaps and Round/Row Robins
72
01-12-2011 08:30 PM
grammynan
Member Swaps and Round/Row Robins
116
12-28-2010 08:38 AM