Re: Access and Outlook Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Pickering (jimp_at_mvps.invalid)
Date: 06/21/04


Date: Mon, 21 Jun 2004 09:54:31 -0700

Those fields will not import, but you can work around that by renaming the
field to one of the unused ones such as Business Phone, Business Fax, etc.

The listed fields are the only ones that will be successfully imported that
I'm aware of.

-- 
Jim Pickering, MVP-Outlook Express
Please reply only to newsgroup.
"scott" <anonymous@discussions.microsoft.com> wrote in message 
news:1f70c01c4578c$abd64200$a001280a@phx.gbl...
>I understand what you are saying but.....
>
> OE has 5 tabs in which it can store data, correct?  I can
> only impirt data into the first 2 tabs, the names of which
> you have listed.  Now, I need to import into the other 3
> tabs (spouse, children, etc).
>
> Any thoughts on those?
>
> Thanks!
>
> Scott
>>-----Original Message-----
>>If you edit the fields in your CSV file to agree with the
> following, you
>>should not have any difficulty importing it into Outlook
> Express.  The edit
>>can be done either in Notepad or in Access.
>>
>>First Name,Last Name,Middle Name,Name,Nickname,E-mail
> Address,Home
>>Street,Home City,Home Postal Code,Home State,Home
> Country/Region,Home
>>Phone,Home Fax,Mobile Phone,Personal Web Page,Business
> Street,Business
>>City,Business Postal Code,Business State,Business
> Country/Region,Business
>>Web Page,Business Phone,Business Fax,Pager,Company,Job
>>Title,Department,Office Location,Notes
>>-- 
>>Jim Pickering, MVP-Outlook Express
>>Please reply only to newsgroup.
>>
>>
>>
>>
>>"scott" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:1da7501c454a0$68f4a2e0$a601280a@phx.gbl...
>>>I dont get the ability to link the CSV file with Express.
>>> I know what the column names are (thanks for the
>>> suggestion though), Express wont let me link.....
>>>
>>>
>>>>-----Original Message-----
>>>><anonymous@discussions.microsoft.com> wrote in message
>>>>news:1de0701c4547e$11b084d0$a401280a@phx.gbl
>>>>> Frank,
>>>>> Actually, I am trying to go from Access to Outlook
>>>>> Express.  I can dump Access into a CSV file, but
> Express
>>>>> wont allow me to associate the CSV columns with its
> pre-
>>>>> defined categories...
>>>>>
>>>>> Thanks,
>>>>> Scott
>>>>>
>>>>>> -----Original Message-----
>>>>>> "Scott" <anonymous@discussions.microsoft.com> wrote
> in
>>> message
>>>>>> news:1dfa701c45471$2acc82a0$a001280a@phx.gbl
>>>>>>> Is there a way to export names and addresses from
>>> outlook
>>>>>>> express into an access data base?
>>>>>>>
>>>>>>> Or the reverse?
>>>>>>>
>>>>>>> THANKS
>>>>>>
>>>>>> You can export them as a CSV file and import that
> into
>>> Excel or
>>>>>> Access.
>>>>>>
>>>>>> --
>>>>>> Frank Saunders, MS-MVP, IE/OE
>>>>>> Please respond in Newsgroup.  Do not send email
>>>>>> http://www.fjsmjs.com
>>>>>> Protect your PC
>>>>>> http://www.microsoft.com/security/protect/
>>>>>>
>>>>>>
>>>>>> .
>>>>
>>>>Export the Address Book as a CSV file and examine it
> with
>>> Notepad to see
>>>>what the field names should be.
>>>>
>>>>-- 
>>>>Frank Saunders, MS-MVP, IE/OE
>>>>Please respond in Newsgroup.  Do not send email
>>>>http://www.fjsmjs.com
>>>>Protect your PC
>>>>http://www.microsoft.com/security/protect/
>>>>
>>>>
>>>>.
>>>>
>>
>>.
>> 


Relevant Pages

  • Re: Selecting recipients
    ... Then you aren't using the Outlook Address Book. ... You should always post your mail support mode to get an accurate answer for ... up if they have only the name and a business phone. ... tabs for the contact to ensure that there were no bits and pieces left but ...
    (microsoft.public.outlook.general)
  • Re: How To Export All Contact Fields?
    ... If you're suggesting that a "properly constructed" CSV file containing ... Easy enough to prove - simply save an Excel worksheet that contains ... multi-line address from Outlook and opening it up in Excel. ... of the primary mistakes people make when using the Outlook import/export ...
    (microsoft.public.outlook)
  • Re: How To Export All Contact Fields?
    ... eleven if 2003 can handle it) of Office to get Access to import a "properly constructed" CSV file ... Easy enough to prove - simply save an Excel worksheet that contains ... multi-line address from Outlook and opening it up in Excel. ... of the primary mistakes people make when using the Outlook import/export ...
    (microsoft.public.outlook)
  • Re: How To Export All Contact Fields?
    ... one form Outlook or Excel and try and bring it into Access and many errors occur. ... The xls format is a bit safer for moving between Office products unless ... that would mess anything up is if the program reading the CSV file is not ... of the primary mistakes people make when using the Outlook import/export ...
    (microsoft.public.outlook)
  • Re: Cannot import Excel file to MS Outlook - ODBC error, too many
    ... If your CSV file does not have extraneous commas at the end of each row ... Karl Timmermans - The Claxton Group ... >> "Power contact importers for MS Outlook '2000/2003" ... >>> I am attempting to load an Excel file of Names, ...
    (microsoft.public.outlook.contacts)