Import fields from Excel go into different Outlook contacts

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Address Book has no contacts from contact list I understand Address book is suppose get addresses from contacts list automatically. But mine will not put any in there. Tag: Import fields from Excel go into different Outlook contacts Tag: 124658
  - 2
    - Select Names not working I had previously deleted all my Outlook Contacts on my home computer, exported Contacts to a pst from my work computer, then imported them at home. I just noticed that when I want to email from home, and Select Names nothing shows up in the box. When I go to the "Show Names from" box, nothing is in the drop down. I'm not sure if the two events are connected. How can I fix this? Tag: Import fields from Excel go into different Outlook contacts Tag: 124653
  - 3
    - autofill email addresses Outlook 2007 Have imported 500 names from Outlook Express OK. Have set options advanced email suggestions box (checked it) Autocomplete does not work. No suggestions are made. Am stuck. Need advice. Help. Tag: Import fields from Excel go into different Outlook contacts Tag: 124652
  - 4
    - Contacts Randomly Disappearing in Outlook. Hi everyone, One of my clients has contacts disappearing from their contact list. The contacts are disappearing randomly with no pattern I can identify. I've done a search, but I haven't found any satisfactory answers. The customer is in a hosted exchange environment (meaning the exchange server is hosted off-site along with a Blackberry Exchange Server service). Only one account is affected (that we can identify). Three other people have editor access (and they are not deleting these contacts). There are 7 other users, but they only have reviewer status. There is one more twist. The actual user does not actually add/remove anything from the list. Their office manager manages the list from her computer. I can't seem to replicate the problem anywhere else (and I don't have a Blackberry server to use either). So I'm hoping someone here can help me. Thanks. Tag: Import fields from Excel go into different Outlook contacts Tag: 124642
  - 5
    - Synch Outlook Contacts with Blackberry 8310 I am very familiar with Outlook (2003), but cannot for the life of me figure out how to sync my Outlook contacts with my new Blackberry 8310. Can anyone point me in the right direction? -- Thanks! Dee Tag: Import fields from Excel go into different Outlook contacts Tag: 124641
  - 6
    - Sorting Email Addresses in Address Book I use Outlook 2007. I want my contacts sorted by last name or -- if no last name -- business name. HOWEVER, I want my email addresses first name, last name so when I begin to type and email address to "John Smith" it comes out at "John Smith" and I don't have to remember to type "Smith, John" and I especially do not want it to appear in an email as "Smith, John." I have followed all sorts of instructions about changing the address book settings to first name, last name sorting and it does not have any impact on what I have. I change it and it still remaines "Last name, First name" . I have done this and restarted it and then done it again and restarted it. What am I missing? Tag: Import fields from Excel go into different Outlook contacts Tag: 124635
  - 7
    - Import my Contatcs from Palm to Outlook 2007 I exported my addresses from Palm Desktop to a .csv file in Excel. I tried one suggestion from online to insert a row a label each column from A-T, and save as in Comma Seperated (Windows). When I go into my Outlook to Import the .csv, it all loads into my contacts but only the first 3 columns? So all I get is First Name, Last Name & Company? Am I doing something wrong, I cant seem to get the addresses or phone numbers in there? I also tried doing a sample backwards, exporting from outlook to excel and then importing to Palm, and it all worked great everything was there. Do I need to go into my Outlook fields and change them? And if so , how and what?? Thank you in Advance..... Tag: Import fields from Excel go into different Outlook contacts Tag: 124633
  - 8
    - Outlook driving me mad! Hi, I am trying to import my contacts from an Excel spreadsheet into Outlook. I feel like I have tried EVERYTHING! I have saved my data as both an excel spreadsheet and in CSV format. I have made sure the columns AND the range of data is identified. I check and check again to make sure my fields are mapped correctly. I have tried eliminating symbols that might interfere (even though I don't see why they would). Every time I do the import, all of the data is imported EXCEPT for the address.... it gets the name, city, state, phone etc etc but ALWAYS leaves out the address! Does anyone know why this is happening and how I can fix it? If so, I would greatly appreciate some help. Thanks! JPorter Tag: Import fields from Excel go into different Outlook contacts Tag: 124627
  - 9
    - Distribution List from Excell spreadsheet I have a list of email addresses (hundreds) in a spreadsheet that I want to put in a distribution contact list called "all employees". When I create a new distribution list in outlook 07 it will not allow me to just copy and paste all the address from the sheet. I am guessing they have to be set up as contacts first? I don't really have time for that. I just want to dump them into a distribution list and be done with it so I can send emails to all employees. Tag: Import fields from Excel go into different Outlook contacts Tag: 124625
  - 10
    - save to a CD can i save all my contacts to a CD - in a readable format rather than a .pst file? Tag: Import fields from Excel go into different Outlook contacts Tag: 124624
  - 11
    - Why would the letter "G" appear after someone's name in the Cc ad. Someone has asked me why a "G" is after their name in the Cc address bar of an incoming message. We are using Outlook 2003. Tag: Import fields from Excel go into different Outlook contacts Tag: 124620
  - 12
    - Updating & moving to another contact list doesn't update email add If I update a contact with a new email address, then I move it to another user's contact list, the old email address remains and the new email address is added as email2. Is there a way to stop this from happening? Thanks. Tag: Import fields from Excel go into different Outlook contacts Tag: 124619
  - 13
    - how do i set up common contact list for users I work in a small company and want to set up a common list of contacts for each user Tag: Import fields from Excel go into different Outlook contacts Tag: 124618
  - 14
    - Cannot automatically detect contact when enailing Windows XP SP2. Just installed Outlook 2003. Have eight contact lists all linked under Contacts. When composing email, have to enter full email of contact each time - Outlook won't link to contacts to offer me "suggestions" after I start typing name of contact Tag: Import fields from Excel go into different Outlook contacts Tag: 124614
  - 15
    - How to intelligently and automatically merge duplicate contacts I imported 2500 old contacts and created about 90% duplicates. I'm using Office Outlook 2007 and I can't believe that there is no tool in this software to intelligently merge duplicates that have been created via the import tool. Does anyone out there know of a third party tool that will do this? It would be simple logic: If the contacts have the same modification date then delete one or the other. If they aren't identical, then ask the user which to keep or better, keep the conflicting fields from the newest record and delete the older content and merge the duplicate contacts into one contact record. Tag: Import fields from Excel go into different Outlook contacts Tag: 124611
  - 16
    - problem with address book Hi all I'm using Outlook Office 2007 on Vista. When I go to a contact, double click on it then select email the correct email address is entered. However if I select File > New > Mail Message, then from the blank message select the "To" button for contacts and then select the same contact, the name is entered in the "To" line but there is no the email address. When I "press" send the email does not leave the "outbox". I would like to be able to use the the "To " button so that I can send the same message to multiple recipients. Any help would be appreciated! Tia Pete Tag: Import fields from Excel go into different Outlook contacts Tag: 124604
  - 17
    - How do I insert a "wait" in Outlook 2007 Dialer (NOT a Pause). I need the dialer to wait for me to restart the dial sequence. The time varies so a timed pause will not work. -- James Tag: Import fields from Excel go into different Outlook contacts Tag: 124603
  - 18
    - activites listing I am trying to list conversations with contacts under the individual contact. Is it possible to set up the activities to enable the entry of a converesation with a date and time stamp? Tag: Import fields from Excel go into different Outlook contacts Tag: 124601
  - 19
    - Signature only attaches as VCF I can not insert my signature in my message. I click signature and choose the signature and it only attaches the VCF card as an attachment and does not appear in the message, does anyone know how to correct this? Tag: Import fields from Excel go into different Outlook contacts Tag: 124599
  - 20
    - HOW DO I ADD IFORMATION TO ACTIVITY What is the purpose of activity? And if it has a purpose, how to I add information to it? Tag: Import fields from Excel go into different Outlook contacts Tag: 124598
  - 21
    - How do I send my outlook address book to my laptop? How can i send my address book to another computer so i don't have to enter evyerything again? Tag: Import fields from Excel go into different Outlook contacts Tag: 124589
  - 22
    - Contact Lists Hi. I am a teacher and I have my students listed in my contacts catagorized according to class. I also have a distributions list per class. That all works great but I would like to be able to list them in a separate contact list as friends and families so that when I am writing an email and press the "to" button I don't have to go through my 200 students to find friends/family. I can't figure out how to do this! I have outlook 2007 and vista sp1 Thanks for your help! Tag: Import fields from Excel go into different Outlook contacts Tag: 124588
  - 23
    - Outlook group list I am running Windows XP and Office 2007. I have several group lists that I developed in Outlook. when I try to add a name and email address to any of the group lists (from my outlook address book), I keep getting a message"Distribution list contains contacts that have not been sent to server. Press f9 to synchronize new contacts then save the distribution list." I have tried F9 which seems to do nothing. I'm frustrated in not being able to add to my lists. Please help?! thankyou! Tag: Import fields from Excel go into different Outlook contacts Tag: 124579
  - 24
    - How to base Outlook Contacts on Vista Contacts folder Rather than use the contacts held in the .PST file, can I have outlook 2007 use the same folder as Vista uses for Windows Mail ? (I need to share the contacts with a non-Outlook user on the same LAN) Thanks. Tag: Import fields from Excel go into different Outlook contacts Tag: 124573
  - 25
    - Share contacts with Windows Live & Outlook Is it possible to share contacts between Windows Live and Outlook? I do not want to integrate my Hotmail account within Outlook using the Office Connector, as suggested by Microsoft. All I want is to run Windows Live for my Hotmail personal email account only and Outlook for my business email account only, using just one Address Book. If I update an address in Outlook, I would like Windows Live to be able to immediately use that address, and vice versa. I currently use Outlook Express for my current Hotmail account. Up to now, I have been able to use the same address book using the registry fix where Outlook Express uses the Outlook Address Book. How can I continue that functionality after I am forced to switch from Outlook Express to Windows Live? Thanks Tag: Import fields from Excel go into different Outlook contacts Tag: 124569
- Next
  - 1
    - Activities Search List for Contact Folders in Exchange I have created a contact folder in Exchange and I am trying to setup the Activities search list for that folder. However, it will only allow me to select 1 folder, not multiple folders (like on a .pst) and it won't allow me to select the "search subfolders" option. When I click on other folders to search, it gives me a message stating that the Contacts folder only allows activities search in 1 folder. Basically, I want to be able to do an Activities search like in a .pst where I can select any number of folder for the Activities search to process. However, I am using an Exchange 2003 and Outlook 2007. Is this a known bug or do I have to create the Contacts folder on the Exchange differently? Thanx for any hints/replies. Tag: Import fields from Excel go into different Outlook contacts Tag: 124565
  - 2
    - Is there a way to list two contacts per business card in Outlook? Hi - I would like to be able to list two contacts per agency on a business card. One contact would be a primary contact, and one would be a secondary contact in case the first person did not reply. Please advise as to if this can be done. Thank you! Tag: Import fields from Excel go into different Outlook contacts Tag: 124564
  - 3
    - how can i avoid syncing OAB, as i wan to syn only MAB HI, I have sync my nokia 9300i with my outlook 2007. In my outlook it has created two address books, namely OAB & MAB (mobile address book). So whenever i sync my phone it updates the contacts in MAB only. Now i have changed my phone and when i want to sync my new phone with outlook 2007, it copies OAB & MAB both. I would like to know how I can only sync the MAB avoiding the OAB. Tag: Import fields from Excel go into different Outlook contacts Tag: 124561
  - 4
    - Contacts Not Working - Corrupt?? Outlook 07 - The inbox works correctly but when I click on the folder of contacts the computer freezes and I have to alt, cont, del and reset. Same happens when I click on notes or calendar. Is this due to a corrupt file? If so, how do I fix it? Thanks Tag: Import fields from Excel go into different Outlook contacts Tag: 124554
  - 5
    - how do I get dates (birthdays, etc...) to transfer to calendar Sometimes the dates seem to transfer and sometimes they don't . Transferring from contacts to calendar doesn't happen. Tag: Import fields from Excel go into different Outlook contacts Tag: 124553
  - 6
    - dumping deleted items in Outlook I have a contact that I deleted in Outlook that is stuck in the deleted file. It won't delete. It says it cannot be displayed in the reading pane. When I try to delete it, I get a message that says errors have been detected and to use the inbox repair tool but it won't download anything. All other items in the deleted file have to then be manually one by one deleted around this file. Tag: Import fields from Excel go into different Outlook contacts Tag: 124545
  - 7
    - how do I stop business card from also appearing as an attachment? I created an electronic business card in Outlook to add to my emails. But now when I send an email out, it appears not only as an image in the body of the message, but also as an attachment to the email. How do I stop it from sending out twice within an email? I have been deleting the attachment with every email I send. Tag: Import fields from Excel go into different Outlook contacts Tag: 124544
  - 8
    - how can I reinitalise the indexing on contacts DB? (is now hung!) My outlook is b*&&ered. It hasn't added any new contacts for weeks! It still ays it is indexing..... but it never gets anywhere - it's always the same number of records. It's plainly hung. How do I reinitialise the indexing of the contact db please? Tag: Import fields from Excel go into different Outlook contacts Tag: 124541
  - 9
    - Force Outlook to use only one contacts folder (2003) XP Pro, Outlook (Office) 2003 SP3 (SMTP / POP3 mail, no Exchange Server, LAN) I must not have something configured correctly, and I'm getting lost trying to find help in the knowledgebase so I'm turning to this group. On my desktop at work I have two different logins that I use. The old, local, login is not used much any more but is where everything began. The new, network domain, login is now where I spend most of my time. This morning I discovered that Outlook is putting new addresses into the 'new' addressbook instead of the 'old' one which has all my contacts. What are my options? I really only need one contacts folder instead of two, but at this point I don't know 1) how to synchronize the two books or 2) how to tell Outlook to only use one of them. In fact, I was not even able to determine how to rename them so I can tell which one I'm looking at ... Outlook shows me two choices, both named "Contacts." Suggestions, please! -- Clif Still learning Access 2003 Tag: Import fields from Excel go into different Outlook contacts Tag: 124540
  - 10
    - Highlight contact? How to highlight a contact after getting the entry Id of a contact Tag: Import fields from Excel go into different Outlook contacts Tag: 124536
  - 11
    - Stop syncing of Contacts Folder I'm on a corporate Outlook server that has been configured to sync with blackberries. I'd like to create a folder of contacts that do not sync with the blackberry. Is there a way to tag/filter/catagorize contacts so that some are not synced? Tag: Import fields from Excel go into different Outlook contacts Tag: 124530
  - 12
    - Intigrating 2 domains in one Forest. I am trying to intigrate two domains intom one forest. I would like to be able to have both Global Conacts to be intigrated into one, so both Domains can see each other. How can this be done. I am running Exchange 2003 Standard on both Domains. Tag: Import fields from Excel go into different Outlook contacts Tag: 124529
  - 13
    - synchronizing contacts I have outlook 2007 on both my home and work computer. Neither computer is networked with another computer. Is there a way to synchronize my contact list between the two computers? Tag: Import fields from Excel go into different Outlook contacts Tag: 124516
  - 14
    - Add map to contact How do I add a map (Google, or Yahoo or MSN) to a contact in Office 2007? What I want is to add directions to a location within the Office 2007 contact. thanks Tag: Import fields from Excel go into different Outlook contacts Tag: 124512
  - 15
    - Upgrade to Outlook 2007, NO address book , Contact OK Upgraded to Outlook 2007 from Outlook 2000. Imported all contact files but have no address book entries. When I send a New Message, and press the "to" - Outlook 2007 brings up an empty address book. I can't seem to direct it to my contacts. If I begin to enter a name, it completes the name, but I can't pull up a list and "choose" the sendees like I did in my previous version of Outlook. I know the Adress Book is pasee, so why do they still have it as an icon on "names" section of the toolbar.?? J~~ Tag: Import fields from Excel go into different Outlook contacts Tag: 124511
  - 16
    - Export contacts from Windows Contacts (Vista) to Office Outlook Can I export contacts from Windows Contact in Vista to Office Outlook contacts on the same computer, or import them to Outlook from Windows contact? Tag: Import fields from Excel go into different Outlook contacts Tag: 124492
  - 17
    - Empty Address text box Field on Contact Form Hi, Windows XP, Outlook 2003 When I view Contacts as Address Cards, if a person has an address, the address shows on the Address Card. However, if you double-click to open the contact, there is no information showing in the Address text field on the form, whether you choose Home, Business, or Other. If you click the "Business..." button by the Address text box, the business address DOES show up in the Check Address dialog box. If you click the All Fields tab, and choose Address Fields, you can see the Business Address, etc. in that list. How do I make the address appear correctly in the Address text box on the form when the Contact is opened? TIA MarieJ Tag: Import fields from Excel go into different Outlook contacts Tag: 124491
  - 18
    - OAB Service in Outlook 2007 on Vista I can't click the 'add this contacts list as an address book' option and when I look it up on the web I keep being told to 'start the OAB Service in Outlook' by using tools/services. But htis doesn't exist. I have an Exchange Mailbox (from which I can see the address book no problem) and an Oultook (POP3) address book which I can't add to the list. I have checked my profile to make sure I am an administrator. Help -- Graeme Tag: Import fields from Excel go into different Outlook contacts Tag: 124485
  - 19
    - display contacts picture in Contancts list Is it possible to display also contacts picture in one of the views of contacts (maybe Detailed Address Cards..) Tag: Import fields from Excel go into different Outlook contacts Tag: 124482
  - 20
    - How do I had fields to the contact details form eg. partners mobil I would like to adjust the contact details form to include partners mobile, email, birthday etc. etc. Can anyone tell me how this may be accomplished? I appreciate any assistance you are able to give me on this matter. Kind regards Donna Tag: Import fields from Excel go into different Outlook contacts Tag: 124481
  - 21
    - Restoring backed up contacts from an external hard drive I back up my computer on a seagate hard drive. My contacts show up as a file on the seagate hard drive. Recently, I restored the file back on my computer but I can't import the data back into my contacts on Outlook. -- Jeff Tag: Import fields from Excel go into different Outlook contacts Tag: 124478
  - 22
    - Changing Destination of "backup.pst" Changes File Size ! I have XP Pro SP2 installed on my laptop with MS Outlook2003. I only use Outlook as a Contacts list and , until today , this data was saved as the file "backup.pst" in the path ;- C:\D&S\User Name\Local Settings\Application Data\Microsoft \Outlook and was 3241KB in size. As I now wish to keep all data out of the C;\ drive I have now saved this file to the E;\ drive and the file now has the path :- E:\Outlook\backup.pst. To my surprise this file is now only 1735 KB in size ! No Outlook contact data has been added or removed . Can anyone explain this discrepancy ? B.N. Tag: Import fields from Excel go into different Outlook contacts Tag: 124476
  - 23
    - Cannot import Excell to Outlook contacts - 'no translater' OUTLOOK 2003 - Excell 2003. Trying to import data (names e mail addresses) from Excel work sheet to Outlook Contacts - get to the fianl stage when 'outlook translater is not installed, do you want to install it?' box is displayed. Answer Yes, system attempts to install a programme (green download line starts then stops), then boots out with the following message 'MS Office Outlook cannot install the translator. The feature is not available'. Have searched all the web sites I can find to get the translator - can anyone put me right. Thanksi-- David Tag: Import fields from Excel go into different Outlook contacts Tag: 124474
  - 24
    - Problem with the Contacts Folder - Error Msg when using While using the Outlook Contacts Folder I keep getting a window pop up that says "A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?" I checked No and it won't go away. I chose 5 minutes and it went away and came back. Any idea what's happening and how to repair it ? Tag: Import fields from Excel go into different Outlook contacts Tag: 124470
  - 25
    - What is 'an internal support function returned an error' emailing Outlook XP and I keep getting the above message when I send out a group email. It worked last week. Any help would be appreciated. Tag: Import fields from Excel go into different Outlook contacts Tag: 124468

I have defined Names in Excel (Name, Title, Number, Email). When I import
into Outlook, it puts each item into a different Contact. It puts them into
the correct category (Name, Title, Number, Email) but rather than putting the
4 items into one contact, it creates 4 different contacts.

Top

Re: Import fields from Excel go into different Outlook contacts by Karl

Karl
Sat May 03 18:48:38 PDT 2008

Clear all of your "named ranges" in your Excel worksheet and create only one
that encompasses both the header row (first row with column names) and all
rows that you want to import - no more - no less.

Alternative to dealing with named ranges is save your Excel worksheet as a
CSV file and import that into Outlook instead.

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

"Bob in Norman" <Bob in Norman@discussions.microsoft.com> wrote in message
news:8155C284-3CC3-446F-9D1F-CFB31AE8991C@microsoft.com...
>I have defined Names in Excel (Name, Title, Number, Email). When I import
> into Outlook, it puts each item into a different Contact. It puts them
> into
> the correct category (Name, Title, Number, Email) but rather than putting
> the
> 4 items into one contact, it creates 4 different contacts.

Top