Importing from CSV file to OL 03

S

SVCTech

Ready for some detail? ;)

===============
Background Info
===============
I have a client with a SBS 2K3 Standard Edition Network with OL 2003 as the
email client for each machine. They use a web based database application
that members of the public can use to sign up for thier mass mailings. This
application can save the members contact information to an Excel document
thereby allowing the user to create a CSV file to import that information
into an Outlook address book in thier Outlook. This has to be done every
Friday as the number of recipients of the email can fluctuate. Many of the
machines in this office have Office 2000 loaded on them (including the one in
question).

=============
Problem
=============
When they import the contacts from the CSV file into Outlook we can select
that address book in the main window and all the contacts are there.
However, if you view the address book from a new email, the fax application
(that comes with SBS), or go to the 'Tools' menu -> Address book...-> &
select the address book from the dropdown list, none of the contacts are
viewable. They are only viewable from the main OL window - Contacts - Fax
Phonebook (the address book with the imported contacts).

==================
Troubleshooting thus far
==================
I have double-checked and made sure that the address book service is
installed and that the address book in question is listed from the email
accounts, "view/change directories and address books". This was done
according to article KB 287563

I have double checked the properties of the address book in question,
outlook address book tab, and made sure that the "show this folder as an
e-mail address book" is checked. Have also confirmed that the address book
is displayed in the available address books when you create a new email, or
fax wizard -- it just displays as empty. This according to article KB 295664

I have tried importing the contacts from a different machine altogether, one
with Office 2003 and Outlook 2003 with the same results. It does not appear
to be a conflict between the OL 2003 and Office 2000 on her computer.

I have found that if, from the main OL window, I open one of the imported
contacts, click the business fax # button, click OK, and click 'Save &
Close', the contact will then display properly when creating a new email or
from the fax wizard. This suggests that there is something wrong with how
they are being imported, but I can't find what that is. If the number of
contacts were not so numerous and prone to change each week, I wouldn't care,
but doing this each week with a couple hundred contacts is not feasible.


Thank you for your patience
 
R

Russ Valentine [MVP-Outlook]

Why do you keep saying you are importing into the Address Book in Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
 
S

SVCTech

Thank you for your reply. I'm sorry to have caused you confusion. In the
interest of getting this resolved, I will rephrase my original post in a
longer and hopefully more clear fashion. I hope you will enjoy the challenge
of helping me figure out this problem that I'm sure has a simple solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email newsletter
or have the newsletter recieved via fax. The web-based database allows for
the contact information, collected from the willing members of the public, to
be downloaded into an Excel spreadsheet. The purpose of downloading this
information is to place the company name and business fax phone #'s into a
contact folder that we have created. The name of this contact folder is "Fax
phonebook". It is located in the user's mailbox, not a public folder. The
user in question has Office 2000 and Outlook 2003 installed on her machine.
The Outlook 2003 is supplied by the license that comes with the SBS server.

Currently, after downloading this Excel document, we open it up and save it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the 'File' menu
and select 'Import and Export...'. We then proceed to import the contact
information into the 'fax phonebook' contact folder that we had created. We
are careful to map the fields so that they appear correctly after the import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a fax"
wizard to do a mass fax every Friday from a user subscribed list provided by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click the
"To..." button, the 'Selected Names' dialog box will open. When you click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information into, not
one contact will appear. This should at least be visible even if it does not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the fax
printer on the server. You click next at the intro screen and are presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click and it
opens the Select Names dialog box again. And again if you select the "Fax
phonebook" contact folder that we created from the dropdown list labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it this, but
that is what it is labeled). In Outlook, go to the "Tools" menu and select
"Address Book..." A dialog box that is clearly labeled, "Address Book" will
open. It is nearly identical to the "Select Names" dialog box that opens
when you create an e-mail. Again, there is a drop down list labeled, "Show
Names From the:" and if you select the "Fax phonebook" contact folder from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only because I
can see other contact folders, but confirmed that the "Fax phonebook" contact
folder that we created is listed in the address book. I did this by doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact folder,
"Outlook Address Book" tab and ensured that the option for "Show this folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder in
OL and open one of the imported contacts and then click on the business fax #
button, click OK without making changes, and then click "Save & Close"; that
contact will then be visible utlizing any of three methods mentioned above
(in the section labeled, "Problem"). If the contacts were few in number, I
could see doing this every Friday without a problem. However, I've seen this
list be as few as 90 and as many as 1,000, so this is not a feasible solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003, and
Office 2003 with the same results on all machines. To me this seems to be a
desktop issue, Exchange shouldn't care. I could try it on other SBS networks
with similar setups but I expect the result would be the same on all of them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to make
it any more clear in identifying the problem. The only other thing I can
think of doing is taking screen shots, but I need someone to email them too.

Again, I thank you for your patience and I hope that we can resolve this
quickly.

--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Why do you keep saying you are importing into the Address Book in Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
 
R

Russ Valentine [MVP-Outlook]

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Thank you for your reply. I'm sorry to have caused you confusion. In the
interest of getting this resolved, I will rephrase my original post in a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading this
information is to place the company name and business fax phone #'s into a
contact folder that we have created. The name of this contact folder is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the 'File'
menu
and select 'Import and Export...'. We then proceed to import the contact
information into the 'fax phonebook' contact folder that we had created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a fax"
wizard to do a mass fax every Friday from a user subscribed list provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information into,
not
one contact will appear. This should at least be visible even if it does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click and
it
opens the Select Names dialog box again. And again if you select the "Fax
phonebook" contact folder that we created from the dropdown list labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned above
(in the section labeled, "Problem"). If the contacts were few in number,
I
could see doing this every Friday without a problem. However, I've seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003, and
Office 2003 with the same results on all machines. To me this seems to be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
make
it any more clear in identifying the problem. The only other thing I can
think of doing is taking screen shots, but I need someone to email them
too.

Again, I thank you for your patience and I hope that we can resolve this
quickly.

--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Why do you keep saying you are importing into the Address Book in
Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Ready for some detail? ;)

===============
Background Info
===============
I have a client with a SBS 2K3 Standard Edition Network with OL 2003 as
the
email client for each machine. They use a web based database
application
that members of the public can use to sign up for thier mass mailings.
This
application can save the members contact information to an Excel
document
thereby allowing the user to create a CSV file to import that
information
into an Outlook address book in thier Outlook. This has to be done
every
Friday as the number of recipients of the email can fluctuate. Many of
the
machines in this office have Office 2000 loaded on them (including the
one
in
question).

=============
Problem
=============
When they import the contacts from the CSV file into Outlook we can
select
that address book in the main window and all the contacts are there.
However, if you view the address book from a new email, the fax
application
(that comes with SBS), or go to the 'Tools' menu -> Address book...-> &
select the address book from the dropdown list, none of the contacts
are
viewable. They are only viewable from the main OL window - Contacts -
Fax
Phonebook (the address book with the imported contacts).

==================
Troubleshooting thus far
==================
I have double-checked and made sure that the address book service is
installed and that the address book in question is listed from the
email
accounts, "view/change directories and address books". This was done
according to article KB 287563

I have double checked the properties of the address book in question,
outlook address book tab, and made sure that the "show this folder as
an
e-mail address book" is checked. Have also confirmed that the address
book
is displayed in the available address books when you create a new
email,
or
fax wizard -- it just displays as empty. This according to article KB
295664

I have tried importing the contacts from a different machine
altogether,
one
with Office 2003 and Outlook 2003 with the same results. It does not
appear
to be a conflict between the OL 2003 and Office 2000 on her computer.

I have found that if, from the main OL window, I open one of the
imported
contacts, click the business fax # button, click OK, and click 'Save &
Close', the contact will then display properly when creating a new
email
or
from the fax wizard. This suggests that there is something wrong with
how
they are being imported, but I can't find what that is. If the number
of
contacts were not so numerous and prone to change each week, I wouldn't
care,
but doing this each week with a couple hundred contacts is not
feasible.


Thank you for your patience
 
S

SVCTech

Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from certain
"Address book" functions throughout the wide range of Microsoft products.

Third, you ignore the fact that I can open any of the imported contacts,
look at the business fax properties, click save & close, and the contact is
then visible from any of the "Address Book" functions. I can then send them
a fax, email, see them in the address book. So yes, the fax numbers resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible. Article
KB295664 entitled, "How to import contacts into outlook from excel". There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address book in
Outlook." Not only is it labeled thoughout OL 2003 and other MS programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from 4/26/2006 and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally so.

It would seem to me that the address book is the location within OL that
contains the contact folders, kind of like a phone book with white and yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs. Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Thank you for your reply. I'm sorry to have caused you confusion. In the
interest of getting this resolved, I will rephrase my original post in a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading this
information is to place the company name and business fax phone #'s into a
contact folder that we have created. The name of this contact folder is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the 'File'
menu
and select 'Import and Export...'. We then proceed to import the contact
information into the 'fax phonebook' contact folder that we had created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a fax"
wizard to do a mass fax every Friday from a user subscribed list provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information into,
not
one contact will appear. This should at least be visible even if it does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click and
it
opens the Select Names dialog box again. And again if you select the "Fax
phonebook" contact folder that we created from the dropdown list labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned above
(in the section labeled, "Problem"). If the contacts were few in number,
I
could see doing this every Friday without a problem. However, I've seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003, and
Office 2003 with the same results on all machines. To me this seems to be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
make
it any more clear in identifying the problem. The only other thing I can
think of doing is taking screen shots, but I need someone to email them
too.

Again, I thank you for your patience and I hope that we can resolve this
quickly.

--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Why do you keep saying you are importing into the Address Book in
Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
--
Russ Valentine
[MVP-Outlook]
Ready for some detail? ;)

===============
Background Info
===============
I have a client with a SBS 2K3 Standard Edition Network with OL 2003 as
the
email client for each machine. They use a web based database
application
that members of the public can use to sign up for thier mass mailings.
This
application can save the members contact information to an Excel
document
thereby allowing the user to create a CSV file to import that
information
into an Outlook address book in thier Outlook. This has to be done
every
Friday as the number of recipients of the email can fluctuate. Many of
the
machines in this office have Office 2000 loaded on them (including the
one
in
question).

=============
Problem
=============
When they import the contacts from the CSV file into Outlook we can
select
that address book in the main window and all the contacts are there.
However, if you view the address book from a new email, the fax
application
(that comes with SBS), or go to the 'Tools' menu -> Address book...-> &
select the address book from the dropdown list, none of the contacts
are
viewable. They are only viewable from the main OL window - Contacts -
Fax
Phonebook (the address book with the imported contacts).

==================
Troubleshooting thus far
==================
I have double-checked and made sure that the address book service is
installed and that the address book in question is listed from the
email
accounts, "view/change directories and address books". This was done
according to article KB 287563

I have double checked the properties of the address book in question,
outlook address book tab, and made sure that the "show this folder as
an
e-mail address book" is checked. Have also confirmed that the address
book
is displayed in the available address books when you create a new
email,
or
fax wizard -- it just displays as empty. This according to article KB
295664

I have tried importing the contacts from a different machine
altogether,
one
with Office 2003 and Outlook 2003 with the same results. It does not
appear
to be a conflict between the OL 2003 and Office 2000 on her computer.

I have found that if, from the main OL window, I open one of the
imported
contacts, click the business fax # button, click OK, and click 'Save &
Close', the contact will then display properly when creating a new
email
or
from the fax wizard. This suggests that there is something wrong with
how
they are being imported, but I can't find what that is. If the number
of
contacts were not so numerous and prone to change each week, I wouldn't
care,
but doing this each week with a couple hundred contacts is not
feasible.


Thank you for your patience
 
K

Karl Timmermans

To start, let me just say that for obvious reasons, I don't subscribe to
"importing contacts rarely works". The import process works just fine both
using Outlook's own import wizard or 3rd party products such as ours. There
are however times when importing OR exporting is the wrong approach for the
task at hand but your scenario isn't one of those. Having gotten that out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same thing
so see if the results are the same?

If the above items work on both of the above but not your client's specific
machine - you have a config issue - most likely best to delete and re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd suggest
you take a look at the imported data itself which would appear to be causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried it
using a few of our test files importing strictly name and fax numbers to an
empty contact folder using only Outlook's import function (using O'2K3 since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines, would
love to get a copy of the .XLS and .CSV file for analysis just to see if the
same behavior holds true on our systems using both the Outlook import wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

SVCTech said:
Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from certain
"Address book" functions throughout the wide range of Microsoft products.

Third, you ignore the fact that I can open any of the imported contacts,
look at the business fax properties, click save & close, and the contact
is
then visible from any of the "Address Book" functions. I can then send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from 4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally so.

It would seem to me that the address book is the location within OL that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs. Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Thank you for your reply. I'm sorry to have caused you confusion. In
the
interest of getting this resolved, I will rephrase my original post in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click
the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if it
does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click
and
it
opens the Select Names dialog box again. And again if you select the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to
the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder
in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003,
and
Office 2003 with the same results on all machines. To me this seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
make
it any more clear in identifying the problem. The only other thing I
can
think of doing is taking screen shots, but I need someone to email them
too.

Again, I thank you for your patience and I hope that we can resolve
this
quickly.

--
Lincoln Spencer
SVC
SBS MCP


:

Why do you keep saying you are importing into the Address Book in
Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
--
Russ Valentine
[MVP-Outlook]
Ready for some detail? ;)

===============
Background Info
===============
I have a client with a SBS 2K3 Standard Edition Network with OL 2003
as
the
email client for each machine. They use a web based database
application
that members of the public can use to sign up for thier mass
mailings.
This
application can save the members contact information to an Excel
document
thereby allowing the user to create a CSV file to import that
information
into an Outlook address book in thier Outlook. This has to be done
every
Friday as the number of recipients of the email can fluctuate. Many
of
the
machines in this office have Office 2000 loaded on them (including
the
one
in
question).

=============
Problem
=============
When they import the contacts from the CSV file into Outlook we can
select
that address book in the main window and all the contacts are there.
However, if you view the address book from a new email, the fax
application
(that comes with SBS), or go to the 'Tools' menu -> Address
book...-> &
select the address book from the dropdown list, none of the contacts
are
viewable. They are only viewable from the main OL window -
Contacts -
Fax
Phonebook (the address book with the imported contacts).

==================
Troubleshooting thus far
==================
I have double-checked and made sure that the address book service is
installed and that the address book in question is listed from the
email
accounts, "view/change directories and address books". This was
done
according to article KB 287563

I have double checked the properties of the address book in
question,
outlook address book tab, and made sure that the "show this folder
as
an
e-mail address book" is checked. Have also confirmed that the
address
book
is displayed in the available address books when you create a new
email,
or
fax wizard -- it just displays as empty. This according to article
KB
295664

I have tried importing the contacts from a different machine
altogether,
one
with Office 2003 and Outlook 2003 with the same results. It does
not
appear
to be a conflict between the OL 2003 and Office 2000 on her
computer.

I have found that if, from the main OL window, I open one of the
imported
contacts, click the business fax # button, click OK, and click 'Save
&
Close', the contact will then display properly when creating a new
email
or
from the fax wizard. This suggests that there is something wrong
with
how
they are being imported, but I can't find what that is. If the
number
of
contacts were not so numerous and prone to change each week, I
wouldn't
care,
but doing this each week with a couple hundred contacts is not
feasible.


Thank you for your patience
 
S

SVCTech

Karl,

Thank you for your analysis. For the most part, we are on the same page.
Answer's to your assumptions/questions are as follows:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder - Correct.
#2 - You actually see the "Fax Contacts" folder in the Outlook Address book
list - i.e. means that the "Use as an email address book" option is in
place - Correct
#3 - No contacts show in the Outlook Address book list for this folder until
"AFTER" you open a contact and then "save & close - 1/2 right. If I open
the a contact, and click save & close, nothing changes. To get the contact
to appear, I have to open the contact, click the business fax # button, make
no changes to the data already there, click OK, then save & close. It is as
if OL just realized that data was there by doing this.
#4 - Unless I misread your post, the issue is occuring on only one machine
which has O'2K but using data from different sources (that correct?) - all
machine's that I've tried with varying versions of Office software. It is
only critical on one machine.

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly? - yes, yes, no
2) Is there another O'2K system available where you can try the same thing
so see if the results are the same? - yes and the result are the same.

In addition, I have loaded both Office 2k and Office 2k3 on my laptop. I
use OL 2k3 on my laptop as well. I first saved the csv file using Excel 2k
and imported it into my OL. Same results. I then saved the csv file using
Excel 2k3 and imported it into my OL. Same results. This happens on nearly
every machine I try, no matter the Office software that is loaded on the
machine (let me make clear that I am using OL 2k3 in each instance).

More to come...
--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
To start, let me just say that for obvious reasons, I don't subscribe to
"importing contacts rarely works". The import process works just fine both
using Outlook's own import wizard or 3rd party products such as ours. There
are however times when importing OR exporting is the wrong approach for the
task at hand but your scenario isn't one of those. Having gotten that out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same thing
so see if the results are the same?

If the above items work on both of the above but not your client's specific
machine - you have a config issue - most likely best to delete and re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd suggest
you take a look at the imported data itself which would appear to be causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried it
using a few of our test files importing strictly name and fax numbers to an
empty contact folder using only Outlook's import function (using O'2K3 since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines, would
love to get a copy of the .XLS and .CSV file for analysis just to see if the
same behavior holds true on our systems using both the Outlook import wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

SVCTech said:
Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from certain
"Address book" functions throughout the wide range of Microsoft products.

Third, you ignore the fact that I can open any of the imported contacts,
look at the business fax properties, click save & close, and the contact
is
then visible from any of the "Address Book" functions. I can then send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from 4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally so.

It would seem to me that the address book is the location within OL that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs. Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion. In
the
interest of getting this resolved, I will rephrase my original post in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click
the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if it
does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click
and
it
opens the Select Names dialog box again. And again if you select the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to
the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder
in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003,
and
Office 2003 with the same results on all machines. To me this seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
 
S

SVCTech

Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and e-mail
address are all apparently imported into Outlook. However when you go to the
address book and view that contact folder - the contacts now appear for some
strange reason except it only shows the e-mail addresses, nothing of the fax
numbers. The same is true though - if I open one of the contacts, click the
business fax #, click OK, and then click save & close, that contact will then
appear in the Address book looking at that contact folder. I had tried this
previously, but must have selected something wrong, because they didn't show
up at all previously.

I have also tried importing directly from Excel, exporting the data to a
table in Access and then into Outlook, and have tried changing the field data
types in both Excel and Access. All of this comes to the same result. The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
To start, let me just say that for obvious reasons, I don't subscribe to
"importing contacts rarely works". The import process works just fine both
using Outlook's own import wizard or 3rd party products such as ours. There
are however times when importing OR exporting is the wrong approach for the
task at hand but your scenario isn't one of those. Having gotten that out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same thing
so see if the results are the same?

If the above items work on both of the above but not your client's specific
machine - you have a config issue - most likely best to delete and re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd suggest
you take a look at the imported data itself which would appear to be causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried it
using a few of our test files importing strictly name and fax numbers to an
empty contact folder using only Outlook's import function (using O'2K3 since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines, would
love to get a copy of the .XLS and .CSV file for analysis just to see if the
same behavior holds true on our systems using both the Outlook import wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

SVCTech said:
Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from certain
"Address book" functions throughout the wide range of Microsoft products.

Third, you ignore the fact that I can open any of the imported contacts,
look at the business fax properties, click save & close, and the contact
is
then visible from any of the "Address Book" functions. I can then send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from 4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally so.

It would seem to me that the address book is the location within OL that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs. Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion. In
the
interest of getting this resolved, I will rephrase my original post in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click
the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if it
does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click
and
it
opens the Select Names dialog box again. And again if you select the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to
the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder
in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003,
and
Office 2003 with the same results on all machines. To me this seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
 
R

Russ Valentine [MVP-Outlook]

All I meant was that importing Contacts rarely works as expected without
having to do some tweaking afterwards. So the fact that you imported
Contacts is the most likely cause of the problem and the one we needed to
troubleshoot first.
The first step in doing so is to open a Contact Record and see if the
address is resolved. So that's what I asked you to do. Many times, the
addresses are imported correctly but will not be resolved by the import
process. Hence, they will not appear in the Outlook Address Book. Many times
these Contacts must be opened and saved before the addresses become
resolved.
What we did next depended on what you reported back, which in this case was
to throw a tantrum because I hadn't solved your problem yet.
The Outlook Address Book is merely a dynamic display of the valid (i.e.,
resolved) addresses in your Contacts Folders. It contains no data. All data
resides in Contacts Folders.
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from certain
"Address book" functions throughout the wide range of Microsoft products.

Third, you ignore the fact that I can open any of the imported contacts,
look at the business fax properties, click save & close, and the contact
is
then visible from any of the "Address Book" functions. I can then send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from 4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally so.

It would seem to me that the address book is the location within OL that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs. Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


Russ Valentine said:
Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved fax
addresses?
--
Russ Valentine
[MVP-Outlook]
SVCTech said:
Thank you for your reply. I'm sorry to have caused you confusion. In
the
interest of getting this resolved, I will rephrase my original post in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to do
=================================================
We have an SBS 2003 Standard edition network. We are making use of the
faxing capability of this server. We also have an online database that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click
the
"To..." button, the 'Selected Names' dialog box will open. When you
click
the drop down list labeled, "Show Names from the:" and select the 'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if it
does
not
have e-mail addresses in it. Subsequently I have tried it with e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can click
and
it
opens the Select Names dialog box again. And again if you select the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate to
the
Contacts folder, and select the "Fax phonebook" contact folder that we
created and imported the contacts into. However, if these contacts are
not
visible from any of the three places listed above, they are virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax phonebook"
contact
folder that we created is listed in the address book. I did this by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact folder
in
OL and open one of the imported contacts and then click on the business
fax #
button, click OK without making changes, and then click "Save & Close";
that
contact will then be visible utlizing any of three methods mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL 2003,
and
Office 2003 with the same results on all machines. To me this seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all of
them.

I would be in heaven if I got half as complete of a picture as this for
troubleshooting from one of my clients. I'm sorry I don't know how to
make
it any more clear in identifying the problem. The only other thing I
can
think of doing is taking screen shots, but I need someone to email them
too.

Again, I thank you for your patience and I hope that we can resolve
this
quickly.

--
Lincoln Spencer
SVC
SBS MCP


:

Why do you keep saying you are importing into the Address Book in
Outlook?
There is no address book in Outlook.
The import destination should be a Contacts Folder.
To what "Fax Phonebook" are you referring? Outlook has no such thing.
--
Russ Valentine
[MVP-Outlook]
Ready for some detail? ;)

===============
Background Info
===============
I have a client with a SBS 2K3 Standard Edition Network with OL 2003
as
the
email client for each machine. They use a web based database
application
that members of the public can use to sign up for thier mass
mailings.
This
application can save the members contact information to an Excel
document
thereby allowing the user to create a CSV file to import that
information
into an Outlook address book in thier Outlook. This has to be done
every
Friday as the number of recipients of the email can fluctuate. Many
of
the
machines in this office have Office 2000 loaded on them (including
the
one
in
question).

=============
Problem
=============
When they import the contacts from the CSV file into Outlook we can
select
that address book in the main window and all the contacts are there.
However, if you view the address book from a new email, the fax
application
(that comes with SBS), or go to the 'Tools' menu -> Address
book...-> &
select the address book from the dropdown list, none of the contacts
are
viewable. They are only viewable from the main OL window -
Contacts -
Fax
Phonebook (the address book with the imported contacts).

==================
Troubleshooting thus far
==================
I have double-checked and made sure that the address book service is
installed and that the address book in question is listed from the
email
accounts, "view/change directories and address books". This was
done
according to article KB 287563

I have double checked the properties of the address book in
question,
outlook address book tab, and made sure that the "show this folder
as
an
e-mail address book" is checked. Have also confirmed that the
address
book
is displayed in the available address books when you create a new
email,
or
fax wizard -- it just displays as empty. This according to article
KB
295664

I have tried importing the contacts from a different machine
altogether,
one
with Office 2003 and Outlook 2003 with the same results. It does
not
appear
to be a conflict between the OL 2003 and Office 2000 on her
computer.

I have found that if, from the main OL window, I open one of the
imported
contacts, click the business fax # button, click OK, and click 'Save
&
Close', the contact will then display properly when creating a new
email
or
from the fax wizard. This suggests that there is something wrong
with
how
they are being imported, but I can't find what that is. If the
number
of
contacts were not so numerous and prone to change each week, I
wouldn't
care,
but doing this each week with a couple hundred contacts is not
feasible.


Thank you for your patience
 
K

Karl Timmermans

Interesting.......

One approach that is commonly used to "prevent" a fax entry in the AB is to
prefix it with something. Reason I mention that is in the event that there
is some "non-printable" (ergo non-visible ) character(s) being added to your
fax number when initially created by the source application. That could
cause the symptom your experiencing. Not going to mention the number of
times we've had data sent to us that was generated from some program which
embedded superflous characters. User had no way of knowing that was the
case - only evident when doing a byte level analysis of the data. If this
was in fact true, everyone could tell you "well it works on my system" (as I
did) and you'd never be farther ahead. Without being able to compare results
using the exact same data - could speculate on potential causes until dooms
day easily just writing it off as another "Outlook problem" or
"configuration" problem. Given what you've tried already - seems unlikely
that to be the case. What isn't immediately clear is what changes when you
simply access the field and re-save it but could be something as simple as
Outlook stripping illegal characters itself within the UI process which it
wouldn't do during an update process (there are a number of fields where the
actions that Outlook takes differs within the UI versus importing).

We do strip out illegal characters in CSV files so you can also do a quick
check by simply downloading either ContactGenie Importer or DataPorter from
our site for a quick 50 record test and see if you get the same results. If
you don't - you have your answer. If you do - we definitely would be
interested in knowing what's causing it so feel free to send us a sample
test file and it will be investigated (you can download either one of the
products from http://www.contactgenie.com/cg20dlorder.htm - if the issue
persists - just send a message along with a sample file to support AT
claxton.com and reference this thread).

Karl

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


SVCTech said:
Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the
following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and e-mail
address are all apparently imported into Outlook. However when you go to
the
address book and view that contact folder - the contacts now appear for
some
strange reason except it only shows the e-mail addresses, nothing of the
fax
numbers. The same is true though - if I open one of the contacts, click
the
business fax #, click OK, and then click save & close, that contact will
then
appear in the Address book looking at that contact folder. I had tried
this
previously, but must have selected something wrong, because they didn't
show
up at all previously.

I have also tried importing directly from Excel, exporting the data to a
table in Access and then into Outlook, and have tried changing the field
data
types in both Excel and Access. All of this comes to the same result.
The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
To start, let me just say that for obvious reasons, I don't subscribe to
"importing contacts rarely works". The import process works just fine
both
using Outlook's own import wizard or 3rd party products such as ours.
There
are however times when importing OR exporting is the wrong approach for
the
task at hand but your scenario isn't one of those. Having gotten that out
of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address
book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder
until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one
machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same
thing
so see if the results are the same?

If the above items work on both of the above but not your client's
specific
machine - you have a config issue - most likely best to delete and re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd
suggest
you take a look at the imported data itself which would appear to be
causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried it
using a few of our test files importing strictly name and fax numbers to
an
empty contact folder using only Outlook's import function (using O'2K3
since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which may
not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines, would
love to get a copy of the .XLS and .CSV file for analysis just to see if
the
same behavior holds true on our systems using both the Outlook import
wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

SVCTech said:
Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it
were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it into
Outlook via the CSV import and that they are only not visible from
certain
"Address book" functions throughout the wide range of Microsoft
products.

Third, you ignore the fact that I can open any of the imported
contacts,
look at the business fax properties, click save & close, and the
contact
is
then visible from any of the "Address Book" functions. I can then send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address
book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS
programs,
but you specifically refer to it in many of your other posts! The most
recent two I saw were "I have contacts missing every day" from
4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally
so.

It would seem to me that the address book is the location within OL
that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs.
Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


:

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved
fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion.
In
the
interest of getting this resolved, I will rephrase my original post
in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to
do
=================================================
We have an SBS 2003 Standard edition network. We are making use of
the
faxing capability of this server. We also have an online database
that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database
allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact
folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public
folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after
the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of
the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you click
the
"To..." button, the 'Selected Names' dialog box will open. When
you
click
the drop down list labeled, "Show Names from the:" and select the
'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if it
does
not
have e-mail addresses in it. Subsequently I have tried it with
e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to
the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can
click
and
it
opens the Select Names dialog box again. And again if you select
the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu and
select
"Address Book..." A dialog box that is clearly labeled, "Address
Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list
labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact
folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate
to
the
Contacts folder, and select the "Fax phonebook" contact folder that
we
created and imported the contacts into. However, if these contacts
are
not
visible from any of the three places listed above, they are
virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax
phonebook"
contact
folder that we created is listed in the address book. I did this by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show
this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact
folder
in
OL and open one of the imported contacts and then click on the
business
fax #
button, click OK without making changes, and then click "Save &
Close";
that
contact will then be visible utlizing any of three methods mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL
2003,
and
Office 2003 with the same results on all machines. To me this seems
to
be
a
desktop issue, Exchange shouldn't care. I could try it on other SBS
networks
with similar setups but I expect the result would be the same on all
of
them.

I would be in heaven if I got half as complete of a picture as this
for
troubleshooting from one of my clients. I'm sorry I don't know how
to
 
R

Russ Valentine [MVP-Outlook]

Why would simply opening and saving the Contact resolve the fax address and
make it appear in the Outlook Address Book?
I have seen this happen countless times, which is why I maintain that
Outlook's import process is deeply flawed.
--
Russ Valentine
[MVP-Outlook]
Karl Timmermans said:
Interesting.......

One approach that is commonly used to "prevent" a fax entry in the AB is
to prefix it with something. Reason I mention that is in the event that
there is some "non-printable" (ergo non-visible ) character(s) being added
to your fax number when initially created by the source application. That
could cause the symptom your experiencing. Not going to mention the number
of times we've had data sent to us that was generated from some program
which embedded superflous characters. User had no way of knowing that was
the case - only evident when doing a byte level analysis of the data. If
this was in fact true, everyone could tell you "well it works on my
system" (as I did) and you'd never be farther ahead. Without being able to
compare results using the exact same data - could speculate on potential
causes until dooms day easily just writing it off as another "Outlook
problem" or "configuration" problem. Given what you've tried already -
seems unlikely that to be the case. What isn't immediately clear is what
changes when you simply access the field and re-save it but could be
something as simple as Outlook stripping illegal characters itself within
the UI process which it wouldn't do during an update process (there are a
number of fields where the actions that Outlook takes differs within the
UI versus importing).

We do strip out illegal characters in CSV files so you can also do a quick
check by simply downloading either ContactGenie Importer or DataPorter
from our site for a quick 50 record test and see if you get the same
results. If you don't - you have your answer. If you do - we definitely
would be interested in knowing what's causing it so feel free to send us a
sample test file and it will be investigated (you can download either one
of the products from http://www.contactgenie.com/cg20dlorder.htm - if the
issue persists - just send a message along with a sample file to support
AT claxton.com and reference this thread).

Karl

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


SVCTech said:
Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the
following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and e-mail
address are all apparently imported into Outlook. However when you go to
the
address book and view that contact folder - the contacts now appear for
some
strange reason except it only shows the e-mail addresses, nothing of the
fax
numbers. The same is true though - if I open one of the contacts, click
the
business fax #, click OK, and then click save & close, that contact will
then
appear in the Address book looking at that contact folder. I had tried
this
previously, but must have selected something wrong, because they didn't
show
up at all previously.

I have also tried importing directly from Excel, exporting the data to a
table in Access and then into Outlook, and have tried changing the field
data
types in both Excel and Access. All of this comes to the same result.
The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
To start, let me just say that for obvious reasons, I don't subscribe to
"importing contacts rarely works". The import process works just fine
both
using Outlook's own import wizard or 3rd party products such as ours.
There
are however times when importing OR exporting is the wrong approach for
the
task at hand but your scenario isn't one of those. Having gotten that
out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the "Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address
book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder
until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one
machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same
thing
so see if the results are the same?

If the above items work on both of the above but not your client's
specific
machine - you have a config issue - most likely best to delete and
re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd
suggest
you take a look at the imported data itself which would appear to be
causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried
it
using a few of our test files importing strictly name and fax numbers to
an
empty contact folder using only Outlook's import function (using O'2K3
since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which may
not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines,
would
love to get a copy of the .XLS and .CSV file for analysis just to see if
the
same behavior holds true on our systems using both the Outlook import
wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of importing
contacts rarely works. You and I both know that is a farse. If it
were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it
into
Outlook via the CSV import and that they are only not visible from
certain
"Address book" functions throughout the wide range of Microsoft
products.

Third, you ignore the fact that I can open any of the imported
contacts,
look at the business fax properties, click save & close, and the
contact
is
then visible from any of the "Address Book" functions. I can then
send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address
book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS
programs,
but you specifically refer to it in many of your other posts! The
most
recent two I saw were "I have contacts missing every day" from
4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are so
important when presenting a problem to you guys, you must be equally
so.

It would seem to me that the address book is the location within OL
that
contains the contact folders, kind of like a phone book with white and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs.
Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


:

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved
fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion.
In
the
interest of getting this resolved, I will rephrase my original post
in
a
longer and hopefully more clear fashion. I hope you will enjoy the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to
do
=================================================
We have an SBS 2003 Standard edition network. We are making use of
the
faxing capability of this server. We also have an online database
that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database
allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of
downloading
this
information is to place the company name and business fax phone #'s
into a
contact folder that we have created. The name of this contact
folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public
folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the SBS
server.

Currently, after downloading this Excel document, we open it up and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after
the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send
a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it
as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of
the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you
click
the
"To..." button, the 'Selected Names' dialog box will open. When
you
click
the drop down list labeled, "Show Names from the:" and select the
'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if
it
does
not
have e-mail addresses in it. Subsequently I have tried it with
e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to
the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can
click
and
it
opens the Select Names dialog box again. And again if you select
the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu
and
select
"Address Book..." A dialog box that is clearly labeled, "Address
Book"
will
open. It is nearly identical to the "Select Names" dialog box that
opens
when you create an e-mail. Again, there is a drop down list
labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact
folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate
to
the
Contacts folder, and select the "Fax phonebook" contact folder that
we
created and imported the contacts into. However, if these contacts
are
not
visible from any of the three places listed above, they are
virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax
phonebook"
contact
folder that we created is listed in the address book. I did this
by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only
profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show
this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact
folder
in
OL and open one of the imported contacts and then click on the
business
fax #
button, click OK without making changes, and then click "Save &
Close";
that
contact will then be visible utlizing any of three methods
mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However, I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a
feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL
2003,
and
Office 2003 with the same results on all machines. To me this
seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other
SBS
networks
with similar setups but I expect the result would be the same on
all of
them.

I would be in heaven if I got half as complete of a picture as this
for
troubleshooting from one of my clients. I'm sorry I don't know how
to
 
K

Karl Timmermans

Hi Russ

Lincoln kindly sent some sample data and now just waiting for confirmation
as to what's causing this based on what we found along with that I want to
get some other testing for different variations (absolutely nothing to do
with the data itself so that's a non-issue). Am sure one of us will post the
cause of the problem just to complete this thread in due course but given
it's late Friday - may not be until next week.

Beyond that, going to refrain responding about Outlook's import process
being "deeply flawed" as much as it's in our best interest for that to be
true - would just sidetrack the main subject. However, Outlook's import
process is certainly something that "needs to be understood" and has a
variety of "idosyncracies" which can be a painful exercise for anyone who
doesn't do this on a regular basis. If we're right in what was found in
terms of cause, this issue will get chalked up to one of those and you'll
have an answer (workaround) for those who report this in the future. Just
keep learning something new about Outlook every day :).

Karl
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Russ Valentine said:
Why would simply opening and saving the Contact resolve the fax address
and make it appear in the Outlook Address Book?
I have seen this happen countless times, which is why I maintain that
Outlook's import process is deeply flawed.
--
Russ Valentine
[MVP-Outlook]
Karl Timmermans said:
Interesting.......

One approach that is commonly used to "prevent" a fax entry in the AB is
to prefix it with something. Reason I mention that is in the event that
there is some "non-printable" (ergo non-visible ) character(s) being
added to your fax number when initially created by the source
application. That could cause the symptom your experiencing. Not going to
mention the number of times we've had data sent to us that was generated
from some program which embedded superflous characters. User had no way
of knowing that was the case - only evident when doing a byte level
analysis of the data. If this was in fact true, everyone could tell you
"well it works on my system" (as I did) and you'd never be farther ahead.
Without being able to compare results using the exact same data - could
speculate on potential causes until dooms day easily just writing it off
as another "Outlook problem" or "configuration" problem. Given what
you've tried already - seems unlikely that to be the case. What isn't
immediately clear is what changes when you simply access the field and
re-save it but could be something as simple as Outlook stripping illegal
characters itself within the UI process which it wouldn't do during an
update process (there are a number of fields where the actions that
Outlook takes differs within the UI versus importing).

We do strip out illegal characters in CSV files so you can also do a
quick check by simply downloading either ContactGenie Importer or
DataPorter from our site for a quick 50 record test and see if you get
the same results. If you don't - you have your answer. If you do - we
definitely would be interested in knowing what's causing it so feel free
to send us a sample test file and it will be investigated (you can
download either one of the products from
http://www.contactgenie.com/cg20dlorder.htm - if the issue persists -
just send a message along with a sample file to support AT claxton.com
and reference this thread).

Karl

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


SVCTech said:
Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the
following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and e-mail
address are all apparently imported into Outlook. However when you go
to the
address book and view that contact folder - the contacts now appear for
some
strange reason except it only shows the e-mail addresses, nothing of the
fax
numbers. The same is true though - if I open one of the contacts, click
the
business fax #, click OK, and then click save & close, that contact will
then
appear in the Address book looking at that contact folder. I had tried
this
previously, but must have selected something wrong, because they didn't
show
up at all previously.

I have also tried importing directly from Excel, exporting the data to a
table in Access and then into Outlook, and have tried changing the field
data
types in both Excel and Access. All of this comes to the same result.
The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


:

To start, let me just say that for obvious reasons, I don't subscribe
to
"importing contacts rarely works". The import process works just fine
both
using Outlook's own import wizard or 3rd party products such as ours.
There
are however times when importing OR exporting is the wrong approach for
the
task at hand but your scenario isn't one of those. Having gotten that
out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the
"Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address
book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder
until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one
machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder
on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same
thing
so see if the results are the same?

If the above items work on both of the above but not your client's
specific
machine - you have a config issue - most likely best to delete and
re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd
suggest
you take a look at the imported data itself which would appear to be
causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried
it
using a few of our test files importing strictly name and fax numbers
to an
empty contact folder using only Outlook's import function (using O'2K3
since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which
may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines,
would
love to get a copy of the .XLS and .CSV file for analysis just to see
if the
same behavior holds true on our systems using both the Outlook import
wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of
importing
contacts rarely works. You and I both know that is a farse. If it
were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it
into
Outlook via the CSV import and that they are only not visible from
certain
"Address book" functions throughout the wide range of Microsoft
products.

Third, you ignore the fact that I can open any of the imported
contacts,
look at the business fax properties, click save & close, and the
contact
is
then visible from any of the "Address Book" functions. I can then
send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address
book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS
programs,
but you specifically refer to it in many of your other posts! The
most
recent two I saw were "I have contacts missing every day" from
4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are
so
important when presenting a problem to you guys, you must be equally
so.

It would seem to me that the address book is the location within OL
that
contains the contact folders, kind of like a phone book with white
and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs.
Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


:

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved
fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion.
In
the
interest of getting this resolved, I will rephrase my original
post in
a
longer and hopefully more clear fashion. I hope you will enjoy
the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to
do
=================================================
We have an SBS 2003 Standard edition network. We are making use
of the
faxing capability of this server. We also have an online database
that
members of the public can use to sign up for either a mass email
newsletter
or have the newsletter recieved via fax. The web-based database
allows
for
the contact information, collected from the willing members of the
public,
to
be downloaded into an Excel spreadsheet. The purpose of
downloading
this
information is to place the company name and business fax phone
#'s
into a
contact folder that we have created. The name of this contact
folder
is
"Fax
phonebook". It is located in the user's mailbox, not a public
folder.
The
user in question has Office 2000 and Outlook 2003 installed on her
machine.
The Outlook 2003 is supplied by the license that comes with the
SBS
server.

Currently, after downloading this Excel document, we open it up
and
save
it
as "samefilename.csv". We then open Outlook 2003 (OL), go to the
'File'
menu
and select 'Import and Export...'. We then proceed to import the
contact
information into the 'fax phonebook' contact folder that we had
created.
We
are careful to map the fields so that they appear correctly after
the
import.
Everything appears to go well, we do not recieve any errors or any
indication that anything goes wrong. All the contacts will show
up
correctly
when you navigate to the "Fax phonebook" in Outlook.

We want to be able to browse to this contact folder from the "Send
a
fax"
wizard to do a mass fax every Friday from a user subscribed list
provided
by
a database and imported into a contact folder in OL.

===================================================
Problem - This can be confusing so read carefully, I will make it
as
clear
as I possibly can
===================================================
Now that the contacts are supposedly 'imported', if you do any of
the
following - the imported contacts will not be visible.

1. Create a new e-mail. When the new message opens up and you
click
the
"To..." button, the 'Selected Names' dialog box will open. When
you
click
the drop down list labeled, "Show Names from the:" and select the
'Fax
Phonebook' contact folder that we imported the contact information
into,
not
one contact will appear. This should at least be visible even if
it
does
not
have e-mail addresses in it. Subsequently I have tried it with
e-mail
addresses and it still shows nothing.

2. Send a fax wizard. When you open any document and print it to
the
fax
printer on the server. You click next at the intro screen and are
presented
with the recipient form in which you fill out the recipient's fax
information. There is an "Address book..." button that you can
click
and
it
opens the Select Names dialog box again. And again if you select
the
"Fax
phonebook" contact folder that we created from the dropdown list
labeled,
"Show Names From the:", no contacts will be visible.

3. Open the Outlook Address book (I know you don't want to call it
this,
but
that is what it is labeled). In Outlook, go to the "Tools" menu
and
select
"Address Book..." A dialog box that is clearly labeled, "Address
Book"
will
open. It is nearly identical to the "Select Names" dialog box
that
opens
when you create an e-mail. Again, there is a drop down list
labeled,
"Show
Names From the:" and if you select the "Fax phonebook" contact
folder
from
this list, nothing is visible.

It is great that we can see the contacts when we open OL, navigate
to
the
Contacts folder, and select the "Fax phonebook" contact folder
that we
created and imported the contacts into. However, if these
contacts are
not
visible from any of the three places listed above, they are
virtually
useless. This is the problem that must be fixed.

============================================
Troubleshooting done thus far
============================================
I have ensured that the address book service is installed not only
because
I
can see other contact folders, but confirmed that the "Fax
phonebook"
contact
folder that we created is listed in the address book. I did this
by
doing
the following:
1. Open OL
2. "Tools" menu, Email Accounts...
3. Under "Directory", I selected the option for "View or change
existing
directories or address books".
4. Click "Next" button and then "Change" button for the only
profile
present
5. At the "Microsoft Office Outlook Address Book" dialog box, "Fax
phonebook: Mailbox - username mailbox" is listed.

I have also gone to the properties of the "Fax Phonebook" contact
folder,
"Outlook Address Book" tab and ensured that the option for "Show
this
folder
as an email address book" is selected.

I have noticed that if I navigate to the "Fax Phonebook" contact
folder
in
OL and open one of the imported contacts and then click on the
business
fax #
button, click OK without making changes, and then click "Save &
Close";
that
contact will then be visible utlizing any of three methods
mentioned
above
(in the section labeled, "Problem"). If the contacts were few in
number,
I
could see doing this every Friday without a problem. However,
I've
seen
this
list be as few as 90 and as many as 1,000, so this is not a
feasible
solution.

I have tried another machine that has Office 2003 and Outlook 2003
(installed from the server) with the same results.

I have even tried this from my office on my SBS 2K3 network, OL
2003,
and
Office 2003 with the same results on all machines. To me this
seems to
be
a
desktop issue, Exchange shouldn't care. I could try it on other
SBS
networks
with similar setups but I expect the result would be the same on
all of
them.

I would be in heaven if I got half as complete of a picture as
this for
troubleshooting from one of my clients. I'm sorry I don't know
how to
 
S

SVCTech

Thank you Karl,

It is confirmed. After following your instructions in your email, you and I
are reflecting the same results in regards to what we discussed via email. I
consider that the problem has an acceptable solution for the client.

I agree that it was a painful exercise to discover such a simple solution.
Your help is greatly appreciated.

I await you to post the solution so that I may give you the proper credit at
least.



--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
Hi Russ

Lincoln kindly sent some sample data and now just waiting for confirmation
as to what's causing this based on what we found along with that I want to
get some other testing for different variations (absolutely nothing to do
with the data itself so that's a non-issue). Am sure one of us will post the
cause of the problem just to complete this thread in due course but given
it's late Friday - may not be until next week.

Beyond that, going to refrain responding about Outlook's import process
being "deeply flawed" as much as it's in our best interest for that to be
true - would just sidetrack the main subject. However, Outlook's import
process is certainly something that "needs to be understood" and has a
variety of "idosyncracies" which can be a painful exercise for anyone who
doesn't do this on a regular basis. If we're right in what was found in
terms of cause, this issue will get chalked up to one of those and you'll
have an answer (workaround) for those who report this in the future. Just
keep learning something new about Outlook every day :).

Karl
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Russ Valentine said:
Why would simply opening and saving the Contact resolve the fax address
and make it appear in the Outlook Address Book?
I have seen this happen countless times, which is why I maintain that
Outlook's import process is deeply flawed.
--
Russ Valentine
[MVP-Outlook]
Karl Timmermans said:
Interesting.......

One approach that is commonly used to "prevent" a fax entry in the AB is
to prefix it with something. Reason I mention that is in the event that
there is some "non-printable" (ergo non-visible ) character(s) being
added to your fax number when initially created by the source
application. That could cause the symptom your experiencing. Not going to
mention the number of times we've had data sent to us that was generated
from some program which embedded superflous characters. User had no way
of knowing that was the case - only evident when doing a byte level
analysis of the data. If this was in fact true, everyone could tell you
"well it works on my system" (as I did) and you'd never be farther ahead.
Without being able to compare results using the exact same data - could
speculate on potential causes until dooms day easily just writing it off
as another "Outlook problem" or "configuration" problem. Given what
you've tried already - seems unlikely that to be the case. What isn't
immediately clear is what changes when you simply access the field and
re-save it but could be something as simple as Outlook stripping illegal
characters itself within the UI process which it wouldn't do during an
update process (there are a number of fields where the actions that
Outlook takes differs within the UI versus importing).

We do strip out illegal characters in CSV files so you can also do a
quick check by simply downloading either ContactGenie Importer or
DataPorter from our site for a quick 50 record test and see if you get
the same results. If you don't - you have your answer. If you do - we
definitely would be interested in knowing what's causing it so feel free
to send us a sample test file and it will be investigated (you can
download either one of the products from
http://www.contactgenie.com/cg20dlorder.htm - if the issue persists -
just send a message along with a sample file to support AT claxton.com
and reference this thread).

Karl

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the
following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and e-mail
address are all apparently imported into Outlook. However when you go
to the
address book and view that contact folder - the contacts now appear for
some
strange reason except it only shows the e-mail addresses, nothing of the
fax
numbers. The same is true though - if I open one of the contacts, click
the
business fax #, click OK, and then click save & close, that contact will
then
appear in the Address book looking at that contact folder. I had tried
this
previously, but must have selected something wrong, because they didn't
show
up at all previously.

I have also tried importing directly from Excel, exporting the data to a
table in Access and then into Outlook, and have tried changing the field
data
types in both Excel and Access. All of this comes to the same result.
The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


:

To start, let me just say that for obvious reasons, I don't subscribe
to
"importing contacts rarely works". The import process works just fine
both
using Outlook's own import wizard or 3rd party products such as ours.
There
are however times when importing OR exporting is the wrong approach for
the
task at hand but your scenario isn't one of those. Having gotten that
out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the
"Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook Address
book
list - i.e. means that the "Use as an email address book" option is in
place
#3 - No contacts show in the Outlook Address book list for this folder
until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one
machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact folder
on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same
thing
so see if the results are the same?

If the above items work on both of the above but not your client's
specific
machine - you have a config issue - most likely best to delete and
re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd
suggest
you take a look at the imported data itself which would appear to be
causing
whatever the problem is. Importing fax numbers to a contact folder does
result in those contacts to appear in an OAB list (actually just tried
it
using a few of our test files importing strictly name and fax numbers
to an
empty contact folder using only Outlook's import function (using O'2K3
since
don't have an O'2K test system available at the moment) and all worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which
may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines,
would
love to get a copy of the .XLS and .CSV file for analysis just to see
if the
same behavior holds true on our systems using both the Outlook import
wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Unacceptable. Your so willing to write it off as, "Importing contact
information rarely works"?

First, your statement is general implying that any method of
importing
contacts rarely works. You and I both know that is a farse. If it
were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it
into
Outlook via the CSV import and that they are only not visible from
certain
"Address book" functions throughout the wide range of Microsoft
products.

Third, you ignore the fact that I can open any of the imported
contacts,
look at the business fax properties, click save & close, and the
contact
is
then visible from any of the "Address Book" functions. I can then
send
them
a fax, email, see them in the address book. So yes, the fax numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no address
book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS
programs,
but you specifically refer to it in many of your other posts! The
most
recent two I saw were "I have contacts missing every day" from
4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics are
so
important when presenting a problem to you guys, you must be equally
so.

It would seem to me that the address book is the location within OL
that
contains the contact folders, kind of like a phone book with white
and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs.
Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


:

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid, resolved
fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you confusion.
In
the
interest of getting this resolved, I will rephrase my original
post in
a
longer and hopefully more clear fashion. I hope you will enjoy
the
challenge
of helping me figure out this problem that I'm sure has a simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want to
do
=================================================
 
K

Karl Timmermans

Cause and solution to this (from our test results) is as follows; Will
summarize this thread so everything is all in one msg:

----------------------------------------
Outlook version this was tested with:

Outlook '2003 but suspect that the same issue applies '2000 & 'XP (no idea
about '98) since the Outlook import import/export engine doesn't appear to
have changed at all since O'2000.

----------------------------------------
AddressBook definition

As found under the tools menu or when opening an email message and choosing
to "Select Names" from either To: CC: BCC: - the contact folder used is
properly set us to be used an Email Address Book.
----------------------------------------

The Problem/Issue (simplified)

Importing contacts with a fax number some or all of which don't show up in
the AB after using Outlook's import process in terms of the FAX entry.

----------------------------------------

How to replicate this:

#1 - Create a 2 field file (CSV, Access, Excel - doesn't matter). One field
being the Fax# - the other being whatever you want it to be i.e. CompanyName
#2 - Import to a new folder (for ease of tracking) and map fields - Fax# to
any of the Outlook fax numbers - the other to anything OTHER then the
FullName field (or any part thereof)
#3 - No entries will show up in the AB

- Repeat the process above except in step #2 - map the 2nd field to the
FullName field (or any part thereof)
- Entries will appear as expected in the AB

-----------------------------------------
Solution (workaround)

#1 - Simply opening an imported contact and opening the appropriate fax
field (no changes required) will result in the contact showing up in the AB
(not really a practical solution in most cases .........................
#2 - Make sure you have some data going into the Name field. If you don't
have a field in your input file for the name, make one up and put some data
into it. Just having spaces in the field WILL NOT WORK.

*** note that the same behavior doesn't occur if importing only an email
address with nothing else - these will appear in the AB as SMTP addresses as
expected
-----------------------------------------

Suspected cause:

This is speculation but everything indicates that the Outlook import process
updates some internal fields used by the AB for fax entries when the name
field is updated. The Outlook UI does this automatically when accessing the
fax field involved (by accessing - mean opening the entry, no change to the
field is required - not just moving the mouse and setting focus on the
field) and then re-saving the contact record.

Is this a bug? or one of Outlook's many "undocumented features"? Will leave
others to define it as they will. Bottomline is that this is the way it
works and most people would typically have a contact name associated with
their import data.
-----------------------------------------

Karl

PS - Just for the record, the exact same data (& field map) imported via
either ContactGenie Importer or DataPorter does not exhibit this issue.
Everything appears as expected which is why it wasn't a familiar problem.

__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

SVCTech said:
Thank you Karl,

It is confirmed. After following your instructions in your email, you and
I
are reflecting the same results in regards to what we discussed via email.
I
consider that the problem has an acceptable solution for the client.

I agree that it was a painful exercise to discover such a simple solution.
Your help is greatly appreciated.

I await you to post the solution so that I may give you the proper credit
at
least.



--
Lincoln Spencer
SVC
SBS MCP


Karl Timmermans said:
Hi Russ

Lincoln kindly sent some sample data and now just waiting for
confirmation
as to what's causing this based on what we found along with that I want
to
get some other testing for different variations (absolutely nothing to do
with the data itself so that's a non-issue). Am sure one of us will post
the
cause of the problem just to complete this thread in due course but given
it's late Friday - may not be until next week.

Beyond that, going to refrain responding about Outlook's import process
being "deeply flawed" as much as it's in our best interest for that to be
true - would just sidetrack the main subject. However, Outlook's import
process is certainly something that "needs to be understood" and has a
variety of "idosyncracies" which can be a painful exercise for anyone who
doesn't do this on a regular basis. If we're right in what was found in
terms of cause, this issue will get chalked up to one of those and you'll
have an answer (workaround) for those who report this in the future. Just
keep learning something new about Outlook every day :).

Karl
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Russ Valentine said:
Why would simply opening and saving the Contact resolve the fax address
and make it appear in the Outlook Address Book?
I have seen this happen countless times, which is why I maintain that
Outlook's import process is deeply flawed.
--
Russ Valentine
[MVP-Outlook]
Interesting.......

One approach that is commonly used to "prevent" a fax entry in the AB
is
to prefix it with something. Reason I mention that is in the event
that
there is some "non-printable" (ergo non-visible ) character(s) being
added to your fax number when initially created by the source
application. That could cause the symptom your experiencing. Not going
to
mention the number of times we've had data sent to us that was
generated
from some program which embedded superflous characters. User had no
way
of knowing that was the case - only evident when doing a byte level
analysis of the data. If this was in fact true, everyone could tell
you
"well it works on my system" (as I did) and you'd never be farther
ahead.
Without being able to compare results using the exact same data -
could
speculate on potential causes until dooms day easily just writing it
off
as another "Outlook problem" or "configuration" problem. Given what
you've tried already - seems unlikely that to be the case. What isn't
immediately clear is what changes when you simply access the field and
re-save it but could be something as simple as Outlook stripping
illegal
characters itself within the UI process which it wouldn't do during an
update process (there are a number of fields where the actions that
Outlook takes differs within the UI versus importing).

We do strip out illegal characters in CSV files so you can also do a
quick check by simply downloading either ContactGenie Importer or
DataPorter from our site for a quick 50 record test and see if you get
the same results. If you don't - you have your answer. If you do - we
definitely would be interested in knowing what's causing it so feel
free
to send us a sample test file and it will be investigated (you can
download either one of the products from
http://www.contactgenie.com/cg20dlorder.htm - if the issue persists -
just send a message along with a sample file to support AT claxton.com
and reference this thread).

Karl

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


Ok. I've tried a few other things.

First, I tried importing the contacts in from a csv file with the
following
fields:
Company
Business Fax
E-mail

The result of this is that the company name, business fax #, and
e-mail
address are all apparently imported into Outlook. However when you
go
to the
address book and view that contact folder - the contacts now appear
for
some
strange reason except it only shows the e-mail addresses, nothing of
the
fax
numbers. The same is true though - if I open one of the contacts,
click
the
business fax #, click OK, and then click save & close, that contact
will
then
appear in the Address book looking at that contact folder. I had
tried
this
previously, but must have selected something wrong, because they
didn't
show
up at all previously.

I have also tried importing directly from Excel, exporting the data
to a
table in Access and then into Outlook, and have tried changing the
field
data
types in both Excel and Access. All of this comes to the same
result.
The
business fax number will not display.
--
Lincoln Spencer
SVC
SBS MCP


:

To start, let me just say that for obvious reasons, I don't
subscribe
to
"importing contacts rarely works". The import process works just
fine
both
using Outlook's own import wizard or 3rd party products such as
ours.
There
are however times when importing OR exporting is the wrong approach
for
the
task at hand but your scenario isn't one of those. Having gotten
that
out of
the way............

To summarize your post just to make sure I'm on the same page re:
understanding the problem:

#1 - You are importing your contacts and all contacts appear in the
"Fax
Contacts" folder
#2 - You actually see the "Fax Contacts" folder in the Outlook
Address
book
list - i.e. means that the "Use as an email address book" option is
in
place
#3 - No contacts show in the Outlook Address book list for this
folder
until
"AFTER" you open a contact and then "save & close
#4 - Unless I misread your post, the issue is occuring on only one
machine
which has O'2K but using data from different sources (that correct?)

Questions

1) Have you tried importing the same data into another contact
folder
on
another machine using O'2K3? If so, does that work correctly?
2) Is there another O'2K system available where you can try the same
thing
so see if the results are the same?

If the above items work on both of the above but not your client's
specific
machine - you have a config issue - most likely best to delete and
re-add
the OAB.

If the above attempts didn't work on any of the machines - then I'd
suggest
you take a look at the imported data itself which would appear to be
causing
whatever the problem is. Importing fax numbers to a contact folder
does
result in those contacts to appear in an OAB list (actually just
tried
it
using a few of our test files importing strictly name and fax
numbers
to an
empty contact folder using only Outlook's import function (using
O'2K3
since
don't have an O'2K test system available at the moment) and all
worked
exactly as it should with all names showing up that a phone number).

If none of the import functions worked on any of the machines then
unfortunately, the other unknowns in this are:
#1) the original Excel data file created from your web
app,
#2) the resulting CSV file created
The assumption so far is that this is an Outlook related issue which
may not
be a correct one if the data isn't importing correctly at any point.

Karl

PS - if your data isn't importing correctly on any of the machines,
would
love to get a copy of the .XLS and .CSV file for analysis just to
see
if the
same behavior holds true on our systems using both the Outlook
import
wizard
along with testing it with our own import products.

--
__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

Unacceptable. Your so willing to write it off as, "Importing
contact
information rarely works"?

First, your statement is general implying that any method of
importing
contacts rarely works. You and I both know that is a farse. If
it
were
true, why have OL at all?

Secondly, you completely ignore the fact that the contacts make it
into
Outlook via the CSV import and that they are only not visible from
certain
"Address book" functions throughout the wide range of Microsoft
products.

Third, you ignore the fact that I can open any of the imported
contacts,
look at the business fax properties, click save & close, and the
contact
is
then visible from any of the "Address Book" functions. I can then
send
them
a fax, email, see them in the address book. So yes, the fax
numbers
resolve
to valid fax addresses.

Fourth, Microsoft's own KB documentation says that it is possible.
Article
KB295664 entitled, "How to import contacts into outlook from
excel".
There
has to be a setting somewhere that is interferring with this.

Finally, in your first post you generally said, "There is no
address
book
in
Outlook." Not only is it labeled thoughout OL 2003 and other MS
programs,
but you specifically refer to it in many of your other posts! The
most
recent two I saw were "I have contacts missing every day" from
4/26/2006
and
"Outlook 2003 email address book" from 4/26/2006. If specifics
are
so
important when presenting a problem to you guys, you must be
equally
so.

It would seem to me that the address book is the location within
OL
that
contains the contact folders, kind of like a phone book with white
and
yellow
pages. I shouldn't have to tell you that.

Is anyone else paying attention to these post? Mr. Tillman? Mrs.
Staples?
Anyone?
--
Lincoln Spencer
SVC
SBS MCP


:

Importing Contact information rarely works.
Have you verified that these imported Contacts have valid,
resolved
fax
addresses?
--
Russ Valentine
[MVP-Outlook]
Thank you for your reply. I'm sorry to have caused you
confusion.
In
the
interest of getting this resolved, I will rephrase my original
post in
a
longer and hopefully more clear fashion. I hope you will enjoy
the
challenge
of helping me figure out this problem that I'm sure has a
simple
solution
somewhere.

=================================================
Background - what we have, what we are doing, and what we want
to
do
=================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top