Can I convert a MS Excell list of names and email address to a contact list in MS Office Outlook?
I have a database of names emailed to me as an XL file. I would like to convert them to make a group mailing list for Outlook. Can I do this without plugging them in one at a time??
Yes. Use the Import/Export Wizard, under the File menu, in Outlook.
It is pretty easy to follow. You will choose "Import from another program or file", and navigate to that file.
It is pretty important that the data in your spreadsheet be structured properly for this to work. You should have things like the Name and Address in seperate columns, in the same row. If you have data scattered randomly throughout the sheet, you will either need to organize it properly or enter everything manually.
If that doesn't make sense, you will understand better when you go through the wizard.
powered by Yahoo Answers
No
References :
Comment by alansboy06 — February 25, 2009 @ 7:00 pm
Yes. Use the Import/Export Wizard, under the File menu, in Outlook.
It is pretty easy to follow. You will choose "Import from another program or file", and navigate to that file.
It is pretty important that the data in your spreadsheet be structured properly for this to work. You should have things like the Name and Address in seperate columns, in the same row. If you have data scattered randomly throughout the sheet, you will either need to organize it properly or enter everything manually.
If that doesn't make sense, you will understand better when you go through the wizard.
References :
Comment by pete h — February 25, 2009 @ 7:44 pm