| "body"> | | | | box next to SPACE (again you will see preview of |
| If you are in a business that attends a lot of | | | | data & now you will see that the first name |
| trade shows or you simply have kept all of your | | | | is separated from the last name) - NEXT |
| Contacts in Excel in the past. There is a quick and | | | | - Then it will come up with how do you want it |
| efficient way to import all contacts from Excel | | | | formatted, in this case since it was names I said |
| into Outlook so that you don't have to manually | | | | "TEXT" |
| re-type all of them. Maybe you have a Virtual | | | | - Finish |
| Assistant that is helping your life get more | | | | The wizard may ask you if you want to replace |
| organized so you can be more efficient! Why not | | | | the destination cells....but you've already inserted |
| hand these notes over to your VA? | | | | your three new columns so tell it yes! I had to do |
| Importing Contacts from Excel into Outlook. | | | | one modification because one person did have a |
| These instructions are written for Excel 2003 so | | | | middle initial and I didn't want that.....so I just put |
| be aware they may not work exactly as | | | | the last name into the correct field and then |
| instructed in other versions. | | | | deleted out the unnecessary "middle" initial column! |
| My instructions may tell you things you already | | | | If you can rename the header row using "fields" |
| know but I don't want to assume. If you need | | | | recognized by Outlook that's good but you will get |
| help feel free to contact me. Okay, first things | | | | a chance later on to tell Outlook what field goes |
| first.....may sure you have a header row in your | | | | with what field. |
| Excel Sheet. (A header row is a row that has | | | | Next in your Excel sheet: you have to highlight the |
| labels for each column indicating what is in that | | | | entire range of data you want to import into |
| column - e.g. First Name, Last Name, Address, | | | | Outlook. With the entire range of data highlighted |
| Phone Number, Email, Website, etc) | | | | go to: (Whatever name you chose make sure it's |
| Next: if the full contact name is in one cell you | | | | only ONE word) |
| have to tell Excel to break the name into | | | | - Insert (in your top toolbar) |
| separate cells....insert three new columns to the | | | | - Name |
| right of the full name column. (I say three | | | | - Define |
| columns because if a name has a middle initial or | | | | - Save the Excel file & exit |
| Jr./Sr. it will affect this process) | | | | Go to the import process in Outlook... (In Outlook |
| Then highlight the entire "full name" column (just | | | | - File-->Import/Export-->Import from |
| click the column heading) | | | | another program or file-->Excel |
| Next go to Data (top toolbar), Text to Columns - | | | | The last thing you want to do as you do the |
| it will bring up the Wizard. | | | | import is when you get to the screen that says |
| - Under: Original data type - select "delimited" (you | | | | "define mapped fields" (will be in upper right hand |
| will see a preview of your column contents at the | | | | corner of wizard) make sure that you follow the |
| bottom of the wizard screen) - NEXT | | | | instructions on that |
| - Then it will bring up: "delimiters" - tab will be | | | | Voila....it should work successfully. Again, if you |
| auto-selected but you want "space" so click the | | | | need any help, feel free to contact me. |