Problem importing e-mail from tab delimited file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm exporting data from a database into excel and saving as a .txt file and
when I import it into outlook it shows up looking okay, but when I select a
contact to mail to in the "To" box ".;" is all that shows up. I tried
creating a listing in outlook, exporting it so that I could populate the file
but in excel the email format looks like this "(e-mail address removed) SMTP David
Barrack ([email protected])" which is not something that I can easily duplicate
from my database. I would appreciate any help you can give.
 
Little confused about your process so to summarize to make sure I'm
understanding this:

#1 - Export your data to Excel from the DB (which database? - Outlook
supports Access directly just as a FYI)
#2 - Save the Excel worksheet as a tab delim text file (any reason you're
using Tab Delim instead of CSV?)
#3 - Importing the text file created in step#2 into Outlook (why not
directly import from the worksheet?)

Questions:
#1 - Are you sure that there are no extraneous "tabs" in any of your fields
causing the resulting rows to be incorrectly structured?
#2 - Are you explicitly mapping the email field when you're importing the
data?

Suggestion:

If you can't import directly from the DB file, and you don't want to import
from the Excel file, save the Excel data as a CSV file and import that file
explicitly mapping each of the fields. If you're just importing standard
fields and there are no issues with the raw data, Outlook's import wizard
works exactly as advertised.

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