How do I convert Excel data into MS Word for mailing lables?
I have 6 columns of data (company name, address 1, address 2, Address 3, Zip, Name) in excel that I need to convert into mailing labels for MS Word (30 Avery labels per page).
How do I do this?? Thank you so much!!!
You’re talking about a Mail Merge operation in Word, in fact, you’ve got Excel set up almost perfectly for it.
But there’s way too many details to a Mail Merge to give here. The best I can do is give you some pointers:
1.Word’s Mail Merge can be found in the Tools->Letters and Mailings menu item.
2.Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.
3.Don’t leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think.
4.For test runs, use only enough names to be sure you’re not losing any — a little over a page should do. Accidentally skipping every other name is real easy to do.
Keep a sense of humor while you’re wrestling with it. It will be worth it the second time around.
Categories: address lables Tags:
Don’t you find it amazing that "Geoge of the Jungle" didn’t die from eating a whole tin of grinded coffee…
at his girlfriends high-tech home? You should have seen it … my dear, he became so hyperactive I would imagine he would have collapsed of a heart attack or something similar. Don’t you think so?
Or that he kept slamming into that tree over and over again?
Categories: coffee tins Tags:
I need a handle for my oriental 4 cup teapot. Metal covered in bamboo about 5 inches across?
I don’t know about finding one that is metal covered in bamboo, but there are several varieties sold by ceramic suppliers such as:
http://www.chineseclayart.com/mall/c110/s25729/store_accessory.asp
http://www.bigceramicstore.com/Supplies/TeapotHandles.htm
http://www.axner.com/axner/supplies/teapothandles.php
http://www.aftosa.com/handles.html
I hope you can find something that will work for you. Good luck.
Categories: cup covers Tags:
Where can I find genuine lists of wholesale suppliers/distributors?
Why is it so hard to find something on the internet?! So many worthless spam sites!
All I’m looking for are whole GPS devices, particularly from Magellan and Garmin.
alibaba.com ull find everything here……….
Categories: best wholesale suppliers Tags:
Where can I search the web to purchase wholesale professional photography equipment and supplies.?
I am looking to set up my own professional photography stidio. I am looking for wholesale prices so that I can stock merchandise that I can sell also. I need a distributor who can sell me wholesale backgrounds, lighting, posing seats, posing stools and props. I would like to sell frames, photo albums and more cool artsy products.
ebay.com
Categories: wholesale supplies Tags:
Categories: product sourcing Tags:
Where do I go to print xbox 360 shipping labels?
From todays date if I ship it tomorrow, will I get back before Christmas?
log in to xbox.com and go to support, from there you can print the e-label……I’m on my second go around with this and the first time it took about 3 weeks.
Categories: shipping labels Tags:
do you ever lick your post- it notes because you are addicted to the flavor of the sticky stuff?
its like….. so addcting… i lick about five little packs a day. does anybody else do it besides me?
ROTFLMBO!!! Seriously. No.
I do know someone who eats Play-Doh though. And she’s over the age of 4….
Categories: post it notes Tags:
What information should I include on my Business cards?
Hello,
I am in the process of launching a small business ,and am meeting with potential investors soon.What information should I include on my business cards?
Thanks
Also important to remember that when you hand your business card to people that after a few days they may forget what type of service you offer. If your business name does not tell people what type of service you offer or business you are in, then pershaps it is worth adding some info about what you do.
Example: Estate Agent, admin assistant, accountant, etc.
I have now also started to add my VOIP service e.g. skype user to my business card.
Categories: business cards Tags:
Can I buy posts for scrapbooking at home depot?
I need bigger posts for scrapbooking. I dont like the extensions, they get week. Can you but larger posts at homedepot?
I doubt it and I know I saw some somewhere – can’t remember. Maybe scrapbook.com?
Categories: scrapbooking Tags: