Importing files from Excel

[Guest]

I am having trouble importing a database from excel into Outlook. When I Map
the fields, it gives me only one field per record to choose. The result is
the First Name, Last Name, Address, etc. end up in separate records.

 

[Sue Mosher [MVP-Outlook]]

Make sure that when you set up the named range in Excel, it covers all the data you want to import.

 

[Guest]

I have the same problem. I have checked that the range includes all the data
- have you any other suggestions?

Fat Doris

 

[Sue Mosher [MVP-Outlook]]

Exactly what symptoms are you seeing, and in what version of Outlook?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Thanks for your response.
Outlook 2003. Just thousands of files with nothing in them.

 

[Sue Mosher [MVP-Outlook]]

Files? Where are you seeing those? I can't imagine a scenario in which importing from an Excel worksheet would create thousands of files -- or even one file. Items, yes. Files, no.

When you perform the import, are you confirming the field mapping?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers