Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / May 2006

Tip: Looking for answers? Try searching our database.

Problem importing e-mail from tab delimited file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jabeinji - 22 May 2006 18:44 GMT
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 "david@napia.com SMTP David
Barrack (david@napia.com)" which is not something that I can easily duplicate
from my database. I would appreciate any help you can give.
Karl Timmermans - 23 May 2006 01:56 GMT
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
Signature

_____________________________________________________________
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

> I'm exporting data from a database into excel and saving as a .txt file
> and
[quoted text clipped - 7 lines]
> duplicate
> from my database. I would appreciate any help you can give.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.