There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
audio avg avg 8 backup bios boot browser bsod computer cpu crash css desktop driver drivers dvd email error excel explorer firefox firefox 3 freeze game graphics hard drive hardware help please hijackthis hjt install internet internet explorer itunes javascript keyboard lan laptop malware missing monitor msn network networking openoffice outlook outlook 2003 outlook express php popups problem router screen seo slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp wireless word
Archive: Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
{SOLVED} How to create Address Records


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
pattoppa's Avatar
Junior Member with 7 posts.
 
Join Date: Feb 2001
26-May-2001, 09:15 PM #1
Again, regarding labels. If someone could tell me where in microsoft I could creat a mailing list, maybe I could start all over? I have microsoft, network,word, publisher,outlook, and outlook express. Does anyone know if those programs have an address book that I can create my mailing list, and then print labels?

thank you for your help
pattoppa
rkselby98's Avatar
Distinguished Member with 4,015 posts.
 
Join Date: May 2000
Location: Gettysburg, PA
Experience: Still Learning
27-May-2001, 09:38 AM #2
Both Outlook and Outlook Express both have an address book and both can be used with mail merge to make your labels from.
rkselby98's Avatar
Distinguished Member with 4,015 posts.
 
Join Date: May 2000
Location: Gettysburg, PA
Experience: Still Learning
27-May-2001, 10:31 AM #3
Both Outlook and Outlook Express have an address book you can use with mail merge.
pattoppa's Avatar
Junior Member with 7 posts.
 
Join Date: Feb 2001
28-May-2001, 06:18 PM #4
Exclamation labels
I love this web site and I thank all those who responded to my question. Someone jogged my brain and I went to the correct tools and created a document that would fit the labels that I bought and I typed the addresses into that doc. Then easily printed it to the labels, and then saved the doc. for future reference.

Thanks again,
Pat Toppa
Anne Troy's Avatar
Computer Specs
Administrator with 11,442 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Microsoft Word MVP
29-May-2001, 02:18 AM #5
Check this out, it might be easier.

Decide how many columns you'll need. For the following example, you need 8 columns. (You do not need to USE all these columns in your mailmerge, so you can use this as a "database" of sorts too.)

FirstName
LastName
Address
Address2
City
State
Zip
Phone

In Word, open blank doc. File-page setup, change orientation to landscape and put very small (.25") margins all the way around, top, bottom, left, right--OK.

Go to Table-Insert-Table, 8 columns by 2 rows. Put your column headings across the first row. Put your first person in the next row. When you're in the last cell of the second row, just hit tab and it'll create a new row for you. Just put a few addresses in for now--see how you like the mailmerge thing. (I personally hate using address books because I use that for my email and I've got tons of people in there that I don't want..., of course you can use a separate folder--either way the mailmerge part will be the same).

Save this doc as mrgdata.doc. Close it.

Open new doc. Tools-Mailmerge-Create-Labels. You'll use mrgdata.doc as your data source. You should be able to go from there until you've got all the codes you need in your file. Once your label is set up and it creates what I call the "coded" document, check it by hitting the <<abc>> button on the mailmerge toolbar. If it's good, hit Fiile-Save as, at the bottom, change it to Document template and save the file as mrglabel.dot. DO NOT CHANGE THE DIRECTORY IT SAVES IT TO. Close it.

Now, anytime you want to create labels, hit File-New and pick your mrglabel template. Then, just hit Tools-Mailmerge-Merge-Merge. Print.
__________________
Microsoft Word MVP
www.OfficeArticles.com
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 04:53 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.