The greatest of richness is the richness of the soul. Prophet Muhammad (Peace be upon him)
Idea Transcript
Make your own website
Create Mailing Labels in Word 2003 With Mail Merge by Brian Burgess on May 15th, 2007
You can use Mail Merge in Word 2003 to create mailing labels for a database full of customers.
The founder of the massive LOLcats meme-driven site ICanHazCheesburger, Ben Huh, is severely allergic to cats.
Open Word 2003 and click on Tools \ Letters and Mailings \ Mail Merge…
In the Mail Merge menu on the right under Select document type, select Labels. Then click Next: Starting document.
How to Select an Uninterruptible Power Supply (UPS) for Your Computer Nest vs. Ecobee3 vs. Honeywell Lyric: Which Smart Thermostat Should You Buy? How to Put Together Your First Smarthome (Without Getting Overwhelmed)
No, Windows 10 Won’t Require a Subscription: Here’s How Microsoft Plans on Making Money Instead
From step 2 Click on Label options…
How to Easily Reinstall Windows 10 Without the Bloatware How to Send and Receive Faxes Online Without a Fax Machine or Phone Line What Is the AppData Folder in Windows? 10 Quick Ways to Speed Up a Slow PC Running Windows 7, 8, or 10
This will bring up a menu allowing you to select the brand and style of the labels you want to print. Here I am using Avery 4013 on a Dot Matrix printer. Of course you will want to select what you have, Avery is the most popular in business from my experience. If you have oddball labels you can always choose custom settings as well. When your done with the label options click OK.
How to Use All of Windows 10’s Backup and Recovery Tools Best Desk Toys for Entertaining Yourself During Conference Calls
Join 100,000 other subscribers Enter Your Email Here Go
Now you are going to want to choose your data source. Under Use an Existing List; click on Browse… Use Explorer to find the data source you want to use and double click it. (Creating a data source will be covered in another how to).
You will click on a confirmation screen verifying your data source (I used an Excel spread sheet that I had imported from Access) and get to Mail Merge Recipients window. Here you can change the order of your information, delete certain users, and validate information. Since I know the data source is what I want I chose Select All. Now hit OK.
+
+
+
Ok, we’re almost complete, just a couple more steps. Click on Next: Arrange your labels.
Save On 2018 Beach Trips
Here Click on More items…
Now we can choose the order of the data we want presented on the labels we are creating. Just double click on each field you want to include.
Now if you look over at your document you will notice these fields are being added to your labels. You can edit them by highlighting the field and moving it to where you want. For instance on this label I would want the First Name before the Last Name.
Now over on the Mail Merge menu bar you will want to select the “update all labels” button. This will populate each label with the fields from the fist label. Then click on Next: Preview your labels.
Your document screen will look similar to this.
Now, on the mail merge menu you can click through the Recipients by clicking the back or forward arrows. If you doing hundreds of labels … I would just spot check them. If you’re satisfied with how they look let’s move to step 6 and complete the merge.
The Merge is complete! Make sure your labels are set up in the printer and hit Print…
You will be presented with the print select screen. Choose all, or a specific number to print. You will get a different record for each contact from your data source on each label.
:
:
Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+
About Us Contact Us Discussion Forum Review Geek How-To Geek Pro Advertising Privacy Policy Terms of Use
Enter your email address to get our daily newsletter. Enter Your Email Here