Advertisement

10.24.2005 at 09:15PM PDT, ID: 21606330
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

Exporting your Outlook Address Book

Tags: export, outlook, address, book
I need a little help with a question over in the word forum (http://www.experts-exchange.com/Applications/MS_Office/Word/Q_21600912.html).  Really, we need to know how to do a mail merge using the entire outlook address book as the data source.  I don't have a machine setup to do that, but I think I can handle the actual merging part once we get the data source problem fixed!

Can anyone offer a little help?  The biggest thing we need is to know how, if possible, to use or to export the entire outlook address book for the purposes of doing a mail merge.

Thanks!
Start your free trial to view this solution
Question Stats
Zone: Software
Question Asked By: dopyiii
Solution Provided By: LuckyLuke57
Participating Experts: 3
Solution Grade: C
Views: 9
Translate:
Loading Advertisement...
10.25.2005 at 12:47AM PDT, ID: 15152603

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.25.2005 at 04:25AM PDT, ID: 15153349

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.25.2005 at 07:43AM PDT, ID: 15154621

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.25.2005 at 08:00AM PDT, ID: 15154816

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.25.2005 at 08:30AM PDT, ID: 15155133

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.25.2005 at 11:29AM PDT, ID: 15156829

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.26.2005 at 08:56AM PDT, ID: 15163762

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.02.2005 at 09:22AM PST, ID: 15209859

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.02.2005 at 11:26AM PST, ID: 15211008

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • Automotive
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Displays / Monitors
  • Handhelds / PDAs
  • Components
  • Peripherals
  • Laptops/Notebooks
  • Servers
  • Misc
  • Apple
  • Embedded Hardware
  • Networking Hardware
  • Storage
  • Desktops
  • New Users
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMware
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Virtualization
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • Web Computing
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Consulting
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMware
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Automation
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Web Services
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Web Computing
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Lounge
  • Business Travel
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
  • Automotive
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
10.25.2005 at 12:47AM PDT, ID: 15152603

Rank: Master

Hi dopyiii,

First of all, I always tell the users to use Excel spreadsheets for mailmerge in Word. It is an easy dataformat, but you can always use the power of Excel to do particular jobs on the data.

This said, I would export the adressbook to an Excel spreadsheet.

In Outlook 2003 do the following:

- In your folder list, select the contacts
- File / Import and Export / Export to a file / Next
- Microsoft Excel / Next
- Select folder to export from: Contacts / Next
- Choose a destination and a name for your xls file / Next
- With "map custom fields" you can do some finetuning, this is not necessarry.
- Finish

Now you have an Excel file which is usable as mail merge data in Word.

Lucky Luke
Accepted Solution
 
10.25.2005 at 04:25AM PDT, ID: 15153349
Lucky Luke,

Thanks for the info.  I agree that an excel worksheet makes a good data source.  However, we're not just trying to use his contacts, but rather the entire address book.  Can we do that?

 
10.25.2005 at 07:43AM PDT, ID: 15154621

Rank: Master

dopyiii,

Hmm, I'll look for that, but our new policies are to convert the classical "addressbooks" to "contacts".

Lucky Luke
 
10.25.2005 at 08:00AM PDT, ID: 15154816
Interesting.  You know what I mean, right?  We want to use the entire address book  (the global address book) as the data source, not just the individual person's contacts.

Thanks for looking into this for me.  When I did Word support, I always hated trying to deal with the outlook side of mail merges.  Just seemed like witchcraft to me ;)

 
10.25.2005 at 08:30AM PDT, ID: 15155133

Rank: Master

dopyiii,

I can't do the test for you because we have thousands and thousands of people in our global address book, but perhaps this gives you a good soluiton:

Tools / Send|Receive / download address book

Then you choose the global address book

Here I don't like to go further in my test, but I think that he will ask you "where to put these addresses" or something like that. Suggestion: prepare in advance an empty contactfolder, where you can put away these addresses.

After that, you can use my instructions of this morning (in my timezone ;-)

Lucky Luke
 
10.25.2005 at 11:29AM PDT, ID: 15156829
If you have access to Exchange Administrator you can export the addressbook from within that to a CSV file.  

You will have to do some doctoring up to add your domain name to the end of the SMTP addresses but that will get you everybody.

I get asked from time to time to provide a list of everyone's email address and thats how I do it.
Assisted Solution
 
10.26.2005 at 08:56AM PDT, ID: 15163762
LuckyLuke57 ,

I tried this and don't after that where I can go.
Tools / Send|Receive / download address book

bsanmiguel
<<If you have access to Exchange Administrator you can export the addressbook from within that to a CSV file.  >>>
can you show me how to do it?

thanks


Assisted Solution
 
11.02.2005 at 09:22AM PST, ID: 15209859
We're still waiting for some help on this one...
 
11.02.2005 at 11:26AM PST, ID: 15211008

Rank: Master

<<
I tried this and don't after that where I can go.
Tools / Send|Receive / download address book
>>

I don't understand what you mean with the above.

Lucky Luke
 
 
20080236-EE-VQP-29