Address book in Word

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Dsquared

Thread Starter
Joined
Jun 2, 1999
Messages
200
Can I use my Outlook Express address book to address envelopes and labels in Word? Word keeps asking for Microsoft Exchange. I don't have Microsoft Exchange on my computer. If I can't use my "Microsoft" Outlook Express address book in my "Microsoft" Word program, how can I set up another address book to use in Word?
 
Joined
Aug 30, 2003
Messages
2,702
Outlook Express 6? I'm not sure about "Word keeps asking for Microsoft Exchange" -- what are you trying to do at this point?

One thing I do know is you can do this if you have 5 mins to spare and Excel.

In OE, File -- Export -- Address Book. Highlight "Text File (CSV)", click Export. Save as eg: "addresses.csv". Click Next, the next bit "select the fields ..." is self-explanatory. Click Finish, then close the window.

Open the file in Excel (you'll need "All Files" for Files of Type), then Save As (Save as Type = "Excel Worbook").

Then you can use the XL version as your data source in Word merge. NB - under step 2 (Get Data -- Open Data Source), you'll need to change Files of Type to "Excel Worksheets", then OK the "Entire Spreadsheet" prompt.

HTH,
Andy
 

Dsquared

Thread Starter
Joined
Jun 2, 1999
Messages
200
Yes, I have Outlook Express 6 and Word 2000.

What happens in Word is this: I go into Word's Envelopes & Labels screen and click the address book icon where I assumed I could either create a directory specific to Word or import the address book in OE6. Instead I get an error message that says: "Loggon failed. You must log on to Microsoft Exchange to access your address book." Why in the world would Exchange be necessary?

I used to use WordPerfect on a previous computer. WP allowed me to set up an address book to use on letters, labels, and envelopes.

I do not have Excel on this computer. I do have MS Works Suite.
 
Joined
Aug 30, 2003
Messages
2,702
>> I do not have Excel on this computer

Then it doesn't really count as a computer. <g>

Try this first (since I never have done) -

(In Word,) Tools -- MailMerge. Create Main Document -- Form Letters -- Active Window. Get Data -- Use Address Book. At this point, do you have "Outlook Address Book" or "Personal Address Book" options?

Post back with how you get on.

Rgds,
Andy
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Believe it or not...

Open Internet Explorer.
Go to Tools-Internet options.
Programs tab.
What's your email program?
Make sure it's OE and not Outlook.
 
Joined
Aug 30, 2003
Messages
2,702
Blimey, this one's a pig.

Found this on MSKB at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;211206

"The Outlook Express Address Book is not designed for use with Microsoft Word 2000. Therefore, when you try to perform a mail merge with the Outlook Express Address Book, either it will not be an available address book, or you may receive one of the following error messages:

Logon failed. You must log on to Microsoft Exchange to access your address book.

-or-

Error code: Unspecified error"

... but it doesn't really go on to give a fix. One thing I did manage using OE6, Word 2K and Works 2K -- in OE6, export as CSV. In Works d-base, open the file and Save As dBase IV (tho' this trunced some fields). Then use that as the data source (Confirm Data Source = dBase files via ODBC *.dbf).

HTH,
Andy
 

Dsquared

Thread Starter
Joined
Jun 2, 1999
Messages
200
XL Guru:

tools/document type/form letter/ I then get the option of: "merge from address book" or "merge from another type of document" When I choose address book, I get a blank document.
 

Dsquared

Thread Starter
Joined
Jun 2, 1999
Messages
200
Thanks for all your help but at this point, it's just not worth spending any more time on it. So whenever I need to address an envelope or label in Word, I just have to do it manually....or go back to a real word processor like WP which also does "reveal codes"
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
If you have people you regularly send to, create autotext entries for them. Look it up in help.

Tips:
Always use 4-letter, lower-case "names" for your autotext entries.
Never use 4-letter "names" that spell real words.

Let me know if you cannot figure out how to make autotext entries. It's so cool.
 
Joined
Aug 30, 2003
Messages
2,702
Dsquared,

Sorry you couldn't get going with this, it does seem pretty horrendous. You wade thru Word Help & it says stuff like "you can use *the Personal Address Book*" ; rilly? -- where's that? IT DOESN'T SAY.

I don't like Word much. & I've never used WP, but have read some articles that it's far better. But to (try and) be fair, you did say "WP allowed me to" set it up. Well of course you can do the same in Word at the Create Data Source stage. However, I understand your frustration.

Regrets,
Andy
 
Joined
May 20, 2004
Messages
8
I am having a similar experience.

WinXP Pro, just installed Office 97. Trying to print an envelope using Word 97 and XP Windows Address Book (WAB). Word does not know about WAB, only Personal Address Book (PAB), and Microsoft Exchange, and Microsoft Mail, and Personal Folder. None of these formats support WAB.

Outlook 97 won't even load. Program Compatability Wizard no help.

XL Guru posted:
In OE, File -- Export -- Address Book. Highlight "Text File (CSV)", click Export. Save as eg: "addresses.csv". Click Next, the next bit "select the fields ..." is self-explanatory. Click Finish, then close the window.

Open the file in Excel (you'll need "All Files" for Files of Type), then Save As (Save as Type = "Excel Worbook").

Then you can use the XL version as your data source in Word merge. NB - under step 2 (Get Data -- Open Data Source), you'll need to change Files of Type to "Excel Worksheets", then OK the "Entire Spreadsheet" prompt.


XL Guru, this is cool. As you say, this can be used as data source for Word merge. Will Mail Merge print one envelope at a time?

TIA, Dan
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Do a google for "meister merge", Dan. You'll find Cindy Meister's site, where she's got a macro that'll break a merge doc into individual files. In case that's what you were looking for.
 
Joined
Aug 30, 2003
Messages
2,702
>> Will Mail Merge print one envelope at a time?

It will for me. I know a little more about Word these days, all my names & adds are in a table doc ; I prefer this to using 2 different apps. I use this doc as the merge source for various other docs. One is a doc with Envelope DL as the paper size. I just open it & scroll through the records to print off the one(s) I want. If I have more than a few to do, I'll merge the envelope doc to a new doc with a query option for LastName Equal to Smith, Jones, etc.

Rgds,
Andy
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Of course that's what he meant.
I thought he mean something really stupid like that his printer will only allow him to feed one envelope at a time.
Where was my head??
Probably playing Gold Miner.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top