home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Applications and Operating Systems
Ask a Tech Support Question (free)!

Need help with Word/ Excel work

Reply
Get bargains at  »  Dealighted.com
 
Thread Tools Search this Thread
Currently Active Users: 2180
Discussions: 200,512, Posts: 2,374,434, Members: 245,837
Old April 2nd, 2002, 07:07 PM   Digg it!   #1 (permalink)
Si vis pacem, para bellum
 
daveleau's Avatar
 
Join Date: Sep 1999
Location: KBAD-Bossier City LA
Posts: 7,606
Send a message via ICQ to daveleau Send a message via AIM to daveleau Send a message via Yahoo to daveleau
Need help with Word/ Excel work

Hi everybody!

I need some help. I have 1300 names, addresses in an excel sheet that I need to take into a Word doc so it will print them onto labels. How would I go about this? I am using Word and Excel 2000.

Board_Num Board_Type Name Lic_Num Address 1 Address 2 City State Zip5 Zip4 Status
37 01 Ben JR Homer S 00**02 63 Victory PKY COLUMBUS GA 3***9 3**9 A


This is the way it is set up in Excel. I need just the name, address and title in the label and I need the labels that conform with a certain Avery label sheet for printing. Any ideas?

Thanks
Dave

Last edited by daveleau : April 2nd, 2002 at 07:09 PM.
daveleau is offline   Reply With Quote
Old April 2nd, 2002, 07:13 PM     #2 (permalink)
Mean Moderator
 
EvilRick's Avatar
 
Join Date: Oct 2001
Location: N of Music City, USA
Posts: 7,791
Use the "Mail Merge" feature found under the "Tools" menu.

It has a pretty straight forward wizard and you can use Excel docs.
EvilRick is offline   Reply With Quote
Old April 2nd, 2002, 07:13 PM     #3 (permalink)
mickwish
 
Posts: n/a
Easy - just use mail merge! There is a wiz to set this up in the newer versions of office, including 2000.
If you get stuck or dunno how to start, PM me and we'll walk though it.
Or maybe clippy could help?!?
Cheers
Mick

Edit: beaten by an evilrick!
  Reply With Quote
Old April 2nd, 2002, 07:21 PM     #4 (permalink)
Si vis pacem, para bellum
 
daveleau's Avatar
 
Join Date: Sep 1999
Location: KBAD-Bossier City LA
Posts: 7,606
Send a message via ICQ to daveleau Send a message via AIM to daveleau Send a message via Yahoo to daveleau
I get this error when I try that. It looks like it will work but appears to have some problems in trying to get the info from the doc.

"Word could not re-establish a DDE connection to MS Excel to complete the currect task"

Thanks!
Dave
daveleau is offline   Reply With Quote
Old April 2nd, 2002, 07:23 PM     #5 (permalink)
mickwish
 
Posts: n/a
How far does it get into the merge before the error, Dave? And has the Excel doc got a header row?
  Reply With Quote
Old April 2nd, 2002, 07:28 PM     #6 (permalink)
mickwish
 
Posts: n/a
OK Dave. Found this M$ support article. Maybe you need to select the correct method in Data Source.
Hope it helps
Mick
  Reply With Quote
Old April 2nd, 2002, 07:41 PM     #7 (permalink)
Si vis pacem, para bellum
 
daveleau's Avatar
 
Join Date: Sep 1999
Location: KBAD-Bossier City LA
Posts: 7,606
Send a message via ICQ to daveleau Send a message via AIM to daveleau Send a message via Yahoo to daveleau
Got it. Thanks! I had to select the area I wanted and then it worked fine. I think the xls doc was created on an Excel 97 machine which may be why I had to copy the data over to a new xls doc. Thanks for the help, mate.

Dave
daveleau is offline   Reply With Quote
Old April 2nd, 2002, 07:46 PM     #8 (permalink)
mickwish
 
Posts: n/a
Glad to help a hard working mod!
  Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Most Active Discussions
Is It Just Me? (1640)
windows 7 retail and rtm (5)
FT HOOD attack: 7 killed 12 injured (67)
HELP!!! What do you think of this s.. (20)
Review My Build (6)
Assosiations (21500)
Looking for a graphic card that wil.. (30)
My 1st pc build (40)
PC Modern Warfare 2: it's much wors.. (12)
core i7 extreme 975, nvidia 9400gt (9)
Aero in Vista (7)
How to Ship a PC (16)
Building my first computer (13)
[F@H SPAM 11/1/09]New month . . . n.. (33)
Recent Discussions
My Pc wont start after i interupted D.. (0)
HELP!!! What do you think of this sys.. (20)
windows 7 retail and rtm (5)
New processor technical problem (0)
boot from CD-ROM in chipset via P4M80.. (2)
Powe Director v8 (0)
Windows Experience Index is screwed u.. (3)
Review My Build (6)
FAT32 to NTFS file system in Win2kpro (4)
Internet very slow since updating AVG.. (8)
Motherboards and my curse... (25)
New Processor, Monitor will not turn .. (2)
2009 Build (4)
My 1st pc build (40)
Freezing During Music/Movies (1)
ext. sound card laptop to stereo syst.. (2)
Remote Desktop via SSH and error mess.. (2)
Help and Support disappeared from my .. (0)
[F@H SPAM 11/1/09]New month . . . new.. (33)
Basic applications needed for "r.. (1)
core i7 extreme 975, nvidia 9400gt (9)
hard drive problem (2)
Win7 TrustedInstaller Permissions (2)
Speed up Win 7 boot time a bit (1)
Hard Drive test program (2)


All times are GMT -4. The time now is 10:35 AM.
TechIMO Copyright 2008 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28