 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / January 2006imported excel to outlook
I followed all the steps to a tee re: importing contact information from excel to outlook (xp 02). I named all columns, followed all the import wizard steps, halfway thru I recieved an error message & outlook closed. (this happened on 2 bus. computers). When I tried to manually enter a contact - I recieved the "folder is full" message. Also - when I pull up my contact folder - in catagories view - it is displayed like this: catagories: (none) (65535 items). I tried to right click and delete the items to which I recieve another error message and outlook again restarts. HELP!! You're only allowed in a Personal Folder file to have 65535 items in a folder. How many contacts were you trying to import? >I followed all the steps to a tee re: importing contact information from > excel to outlook (xp 02). I named all columns, followed all the import [quoted text clipped - 7 lines] > (65535 items). I tried to right click and delete the items to which I > recieve another error message and outlook again restarts. HELP!! 155 contacts with mgmt co, contact,address, etc. 10 headers all together > You're only allowed in a Personal Folder file to have 65535 items in a > folder. How many contacts were you trying to import? [quoted text clipped - 10 lines] > > (65535 items). I tried to right click and delete the items to which I > > recieve another error message and outlook again restarts. HELP!! Hmmm, how many contacts were in the folder to start with? > 155 contacts with mgmt co, contact,address, etc. 10 headers all together Zero!! We just started using/setting up outlook for a seperate part of our business. (We have a web site that users can ask for information) > Hmmm, how many contacts were in the folder to start with? > > > 155 contacts with mgmt co, contact,address, etc. 10 headers all together Odder & odder... You can't delete items can you? First you might want to try running ScanPST.EXE on your PST file to see if anything bad has happened to the file. Then from within the Contacts folder see if you can then remove the bad items. How many times did you try to import from the file? > Zero!! > We just started using/setting up outlook for a seperate part of our > business. (We have a web site that users can ask for information) I KNOW! No I could not delete files first. Ran SCANPST.EXE ~ 17 problems ~ did the repair. Went into Outlook, in contacts, it looked the same as before. I did try to right click on (65535 items) and delete which caused the "Outlook has encountered a problem and has to close" screen to pop up. I do not understand any of the jargon that was in the error report! I did try for the heck of it to manually enter a contact ~ still recieved the "folder is full" alert. I don't remember how many times that I tried to import ~ 4-5? Each time the dialog box would open and show the transfer-starting on "area" ( the first of the ten headers)- the green timer line would fill, the little letters would fly from folder to folder and within 5 minutes I would recieve the same error message as above. I just assumed that the data, or not very much of it had transfered. Can I just upgrade/Install Outlook 2003 Professional with Business COntact mgr? The computer currently has Windows 2000 operating system and XP 2002 small business for the program pkg. Whats confusing is I just 2 weeks ago did a complete install of everything (from operating-programs-network etc) and this is the first time we have tried to use Outlook. > Odder & odder... > [quoted text clipped - 8 lines] > > We just started using/setting up outlook for a seperate part of our > > business. (We have a web site that users can ask for information) Do you have any other data in this Personal Folder file or can we just create a new one and start from scratch to see what happens? >I KNOW! > No I could not delete files first. Ran SCANPST.EXE ~ 17 problems ~ did the [quoted text clipped - 36 lines] >> > We just started using/setting up outlook for a seperate part of our >> > business. (We have a web site that users can ask for information) Nothing that cant be sent to another account or is important. Can I just right click on "Personal Folders" and then right click and delete? > Do you have any other data in this Personal Folder file or can we just > create a new one and start from scratch to see what happens? [quoted text clipped - 39 lines] > >> > We just started using/setting up outlook for a seperate part of our > >> > business. (We have a web site that users can ask for information) Not so easy... Go to the Control Panel's Mail applet, click Email accounts, select View/Change existing email accounts > Click Next Click New Outlook Data File, create the file then set it in the Deliver new email to the following location dropdown Start Outlook and use the new folders. You might have to close the old ones but other than that you should be fine > Nothing that cant be sent to another account or is important. > Can I just right click on "Personal Folders" and then right click and > delete? Ok-I have the new personal folder ~ Thank You! I can manually insert contact info. I did try to import ~ It went all the way thru the first header and started (I dont know how far it got) thru the second header when I recieved the problem message and outlook restarted. I did double check the Excel spreadsheet and the only thing I can see different in those two columns is: the first column every cell has information in it, the second column does have blank spaces near the end of the column. Would that have anything to do with the import not finishing and if so how do I make it work without adding a character in each blank cell just to delete it in Outlook? (sorry about all the ?'s - outlook is new to me!) Thanks > Not so easy... Go to the Control Panel's Mail applet, click Email accounts, > select View/Change existing email accounts > Click Next [quoted text clipped - 8 lines] > > Can I just right click on "Personal Folders" and then right click and > > delete? > Ok-I have the new personal folder ~ Thank You! I can manually insert > contact info. I did try to import Don't import. Open the old PST as well and drag/drop everythin in it to the new PST. Close the old one when finished.  SignatureBrian Tillman I dont think that any of the contact information was imported into the old PST. I would like not to manually enter all the contact information. I have 3 different "mailing" lists that need entered. The largest is over 150 names, addresses, ph# etc. I tried an import after manual enter worked. The first header "area" which is the state column, worked. The second header, community, did not. the only difference i could see in the columns was the blank cells on the community header. could that have anything to do with the import failure? can I import without filling in the cells before import and then going into each contact after import and deleting that unnecessary info? With that many contacts, I want the easy way!!! > > Ok-I have the new personal folder ~ Thank You! I can manually insert > > contact info. I did try to import > > Don't import. Open the old PST as well and drag/drop everythin in it to the > new PST. Close the old one when finished. |
Reply to this Message |
 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.