Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing email addresses from Excel into Outlook (Office 2000)

    When trying to import names and email addresses entered in Excel into Outlook so as to do a mass emailing we get the following message:
    "An ODBC error had occurred in the MSE translator while opening a file
    to build a field map. [Microsoft] [ODBC Excel Driver] too many fields
    defined."
    Apparently the fields have been defined in Excel but we must be doing this incorrectly. Does anyone know why we get this message and how we can avoid it? To get around this for now we have saved the Excel file as a comma delimited file and then imported into Outlook and that seems to work. Thank you.
    Dorothy

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing email addresses from Excel into Outlook (Office 2000)

    I did this some time ago and had to define *one* name (in XL, Insert, name, define)) that spanned all the cells with information to be imported. Outlook then picked up this range and gave possibility to assign the various columns in that range to various fiels of the contact list.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •