Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / October 2007

Tip: Looking for answers? Try searching our database.

can't import address from access to outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rose - 09 Jun 2006 19:13 GMT
I am trying to import addresses from an access 2003 database into my contacts
in outlook 2003. The database is information I exported from outlook before
have to reinstall windows etc.  I have followed all the directions and the
window says it is copying to contacts but there is nothing in my contacts
after the import. I have even tried it through excel with same thing
happening.  I recently reinstalled office professional edition 2003 after
reinstalling windows xp. I had imported my contacts from my hand held Palm
and all was fine until my husband syncronized with his new treo and wiped out
the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 19:26 GMT
Did you click the Map Custom Fields and tell Outlook how to match the Access table fields with Outlook properties?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

>I am trying to import addresses from an access 2003 database into my contacts
> in outlook 2003. The database is information I exported from outlook before
[quoted text clipped - 5 lines]
> and all was fine until my husband syncronized with his new treo and wiped out
> the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 20:14 GMT
Thanks Sue but I did do that. Most of the fields were already mapped and I
added those that were not.  
Rose

> Did you click the Map Custom Fields and tell Outlook how to match the Access table fields with Outlook properties?
>
[quoted text clipped - 7 lines]
> > and all was fine until my husband syncronized with his new treo and wiped out
> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 20:21 GMT
What folder are you importing into? It's wise to import into a new empty folder.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Thanks Sue but I did do that. Most of the fields were already mapped and I
> added those that were not.  
[quoted text clipped - 12 lines]
>> > and all was fine until my husband syncronized with his new treo and wiped out
>> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 20:55 GMT
Do you mean to create a new contacts folder.  The contacts folder under
Personal folders is the one I have trying to import to and it is empty.  I
will try creating another contacts folder and try again.  Thanks.  Rose

> What folder are you importing into? It's wise to import into a new empty folder.
>
[quoted text clipped - 14 lines]
> >> > and all was fine until my husband syncronized with his new treo and wiped out
> >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 21:03 GMT
Success!!!! Thanks so much.  Do I delete the other contact folder - is there
a trick to that?  I can't tell you how many different ways I tried to import
- hours- I should have used this site a lot earlie.
Ros

> Do you mean to create a new contacts folder.  The contacts folder under
> Personal folders is the one I have trying to import to and it is empty.  I
[quoted text clipped - 18 lines]
> > >> > and all was fine until my husband syncronized with his new treo and wiped out
> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 21:21 GMT
No need to delete, just copy the imported items into it. If that goes OK, you can delete the import folder.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Success!!!! Thanks so much.  Do I delete the other contact folder - is there
> a trick to that?  I can't tell you how many different ways I tried to import
[quoted text clipped - 23 lines]
>> > >> > and all was fine until my husband syncronized with his new treo and wiped out
>> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 21:41 GMT
Something is wrong with the original contact folder.  Somehow it is full with
displaying anything.  When I open it there are are bunch of lines there as if
it is in the detailed address view but has no data.  I am unable to copy
anything into it.  It is like I need to reformat it in order to copy to it.  
Thanks, Rose

> No need to delete, just copy the imported items into it. If that goes OK, you can delete the import folder.
>
[quoted text clipped - 25 lines]
> >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
> >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 21:48 GMT
Have you tried using a different view of that folder?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Something is wrong with the original contact folder.  Somehow it is full with
> displaying anything.  When I open it there are are bunch of lines there as if
[quoted text clipped - 3 lines]
>
>> No need to delete, just copy the imported items into it. If that goes OK, you can delete the import folder.

>>    
>> > Success!!!! Thanks so much.  Do I delete the other contact folder - is there
[quoted text clipped - 24 lines]
>> >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
>> >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 10 Jun 2006 02:08 GMT
Yes, all views are blank except you can see that the formatting is there.  If
I try deleting part of the contacts it tells me the folder is full.  I am
confused as to why it says there are 65,000 items (only have 400 contacts).  
I did try importing many times so I assume it has added up -  still can't be
seen.  Isn't there some way to delete this folder and start over? My new
folder imported just fine except it is not recognized by the address book.  
Thanks,  Rose

> Have you tried using a different view of that folder?
>
[quoted text clipped - 34 lines]
> >> >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
> >> >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 16 Jun 2006 15:17 GMT
DId you try running Scanpst.exe as I suggested?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Yes, all views are blank except you can see that the formatting is there.  If
> I try deleting part of the contacts it tells me the folder is full.  I am
[quoted text clipped - 5 lines]
>
>> Have you tried using a different view of that folder?

>> > Something is wrong with the original contact folder.  Somehow it is full with
>> > displaying anything.  When I open it there are are bunch of lines there as if
[quoted text clipped - 32 lines]
>> >> >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
>> >> >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 22:29 GMT
Hi Sue,
I am not sure where you want me to click to show message etc but I think the
original contacts folder is full and the deleted contacts(wherever that may
be) is also full.  I tried to delete all the information and it says the
folder is full.  The only folder I see with deleted information is the one
that holds the deleted emails.  The contacts folder says it has 65,500 items
in it although I can't see anything.  When I change views it is still blank
but the design is there.  I can't seem to find anything relating to "show".
Thanks,  Rose

> Something is wrong with the original contact folder.  Somehow it is full with
> displaying anything.  When I open it there are are bunch of lines there as if
[quoted text clipped - 31 lines]
> > >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
> > >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 22:35 GMT
> The contacts folder says it has 65,500 items
> in it although I can't see anything.

That's undoubtedly the problem. It looks like you have hit the maximum number of items in a .pst file folder. You might want to see if Scanpst.exe can fix it -- see http://www.slipstick.com/problems/scanpst.htm 
Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Hi Sue,
> I am not sure where you want me to click to show message etc but I think the
[quoted text clipped - 41 lines]
>> > >> > >> > and all was fine until my husband syncronized with his new treo and wiped out
>> > >> > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Rose - 09 Jun 2006 21:25 GMT
I have one more problem here.  My outlook mail won't recognize the new folder
- how do I get the default changed to the new folder or transfer the
information back into the original contacts folder?  Rose

> Success!!!! Thanks so much.  Do I delete the other contact folder - is there
> a trick to that?  I can't tell you how many different ways I tried to import
[quoted text clipped - 23 lines]
> > > >> > and all was fine until my husband syncronized with his new treo and wiped out
> > > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Sue Mosher [MVP-Outlook] - 09 Jun 2006 21:35 GMT
Please provide details of the symptoms you're seeing. Where exactly did you create the new folder?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

>I have one more problem here.  My outlook mail won't recognize the new folder
> - how do I get the default changed to the new folder or transfer the
[quoted text clipped - 27 lines]
>> > > >> > and all was fine until my husband syncronized with his new treo and wiped out
>> > > >> > the contacts and left only his phone numbers behind. :) Thanks for any help.
Clueless in Connecticut - 25 Oct 2007 15:01 GMT
my name is Stella and I, too, am trying to export or import whichever is the
correct term....take my access contacts and transfer them/drop them/copy
them...what ever is needed to get them into my Outlook format....my boss
wants to merge all 6,000 contacts from Access into Outlook for our Christmas
2007 mailing and I cannot make it work although I'm following the printed
directions....it states start with a b lank access page and then press
import....but I don't see import only export...not to mention this new Vista
program isn't very user friendly...I'm also hav ing problems getting labels
to merge, even using the wizard...it is all new and too Greek for little ol
me....can someone out there help me before the night before Christmas....I'll
keep searching for tutorials but I need someone from Microsoft help
desk...and you people out there to help me out!!  my Christmas bonus depends
on it.....smiling and thanks, Clueless in Connecticut...Stella

> I am trying to import addresses from an access 2003 database into my contacts
> in outlook 2003. The database is information I exported from outlook before
[quoted text clipped - 5 lines]
> and all was fine until my husband syncronized with his new treo and wiped out
> the contacts and left only his phone numbers behind. :) Thanks for any help.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.