IS THERE A MS WORD 2003/OUTLOOK GURU OUT THERE. I need some help creating contacts?

Question

I have a MS Excel spreadsheet with contact information of more than 4000 clients (work address, name, and job title) I add this information to a mailing label in MS Word.
Because of the size of the envelope I copy the contact information on to 4 x 3.5 mailing labels.
Recently the amount of mailing has increased; therefore I would like to know if there is a feature in MS Word were I can import this addresses from MS Excel and be able to select a random contact and have their contact information appear on the screen.

In other words, what I am trying to do is to: import a MS Excel 2003 spreadsheet in to MS Word 2003 be able select a random contact from that list, have their address appear on the screen and copy and paste the address on to a label.

I have a few other questions:

1. is this possible, if yes how can I do it
2. does MS Word 2003 has a contact information feature similar to MS Outlook, if not , can I download a template fro Microsoft.com

Answer 1

Click on Tools, point to Letters and Mailings and click on Mail Merge, then follow the on-screen instructions. I think this will give you more or less what you're after. Word doesn’t have a contacts feature like Outlook, but the idea of Mail Merge is that you can use the details from Outlook or your own Excel spreadsheet.

Answer 2

There isn't any direct connection between excel and word to manage address. But there is between outlook and word



THE WORD ADDRESS BOOK

There is the Word Address Book. As a result of the integration between Office programs, Word uses Outlook to store and retrieve Contact information. The Word Address Book is nothing more than a service that links Word to the Outlook Contacts Folders. To use any address book functions in Word, you must be using Outlook for Contact storage and default mail client so that you will have the ability to connect to your Contacts data, but you also need that the versions of Word and Outlook be the same.



SOLUTION: The option that a see is:

• Load your address in outlook by importing them from excel and then you could use them in word.



Watch this video: http://video.about.com/homebusiness/Make-Address-Labels-in-Word.htm

For more information

http://office.microsoft.com/en-us/word/HA011269731033.aspx?pid=CH011218841033

Answer 3

You can import contacts into Outlook from an Excel spreadsheet.



In Outlook, go to File -> Import and Export -> Import from another program or file -> MS Excel



You can then use your contacts to make labels by using the Mail Merge option in Outlook. (Tools -> Mail Merge)



You usually have to have the same version of Outlook, Word and Excel in order to do this.

Answer 4

You can use this reverse phone lookup service ( http://reversephones.info )



It can be useful in a lot of different situations. If the caller asks for your name reply by asking for their name. Do not give them any information about yourself. Ask what number they dialed and ask for their number. You will be able to use this number later when you carry out a reverse phone lookup to identify the caller. The individuals who make these calls intend to upset you in some way or even cause you more significant harm. This could be for many different reasons. Perhaps they wish to get revenge for you breaking off a relationship or they may simply just get some sort of twisted gratification from making you feel uncomfortable. Some criminals attempt to obtain useful information from unsuspecting children. Teach your children to ask for the caller's name and number and to inform the caller that someone will call them back.

Answer 5

Yes just copy the address you want to save and paste it into a blank MS Word document. Now you can save it.