Novell Cool Solutions

Importing Address Book Info into Excel



By:

February 20, 2007 5:45 am

Reads:9,392

Comments:0

Score:Unrated

Print/PDF

Problem

How do you get the address information from all your business contacts into an application such as Microsoft Excel to use for a mailing? You enter so much information in GroupWise, there’s got to be a way to export the information for use in other applications.

Solution

Here’s the best way I’ve found …

1. Open GW Addressbook.

2. Choose the desired Address Book.

3. Select File > Export.

4. Choose the desired option (whole AB or selected entries).

5. Save to a *.NAB file at the desired location.

6. Open Miocrosoft Excel.

7. Create a new sheet.

8. Select Data > Import external data > Import data (these menu items my vary – I’ve just transated them from German excel).

9. Find and select your saved *.NAB file to open (select ‘All Files (*.*)’ as
filetype!)

The text conversion wizard/assistant pops up (if installed).

10. Run through that wizard with your options.

You’re done! All tre contacts are listed in your Excel spreadsheet, ready for further processing.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.
Loading...Loading...

Categories: Uncategorized

0

Disclaimer: This content is not supported by Novell. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

Comment

RSS