Re: Access and Outlook Express

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: 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)
  • Re: Importing contacts with subfolders, and calendars from Outlook 20
    ... You can also import your contacts for free by exporting them as a CSV file ... from Outlook, then using Thunderbird to retrieve them. ... export from the PST into Entourage, and just do it all for me. ... >>> Thanks in advances for any help from the community. ...
    (microsoft.public.mac.office.entourage)
  • Re: Export Entourage contacts as CSV (windows)
    ... > has been to import the resulting text file into Excel, and SAVE AS a CSV file. ... Get my shareware scripts "Export-Import Entourage X". ... Outlook (I think you can safely choose Yahoo or Outlook Express from the ...
    (microsoft.public.mac.office.entourage)
  • Re: import .adr files
    ... Am not familar with what an ADR file structure is or what creates them other ... resulting CSV file into Outlook. ... "Power contact importers for MS Outlook '2000/2003" ... >>Karl Timmermans - The Claxton Group ...
    (microsoft.public.outlook.contacts)