Re: Access and Outlook Express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 06/22/04 

Date: Tue, 22 Jun 2004 05:36:02 -0700

Thats what I was afraid of. Thanks for the help.

>-----Original Message-----
>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/
>>>>>
>>>>>
>>>>>.
>>>>>
>>>
>>>.
>>>
>
>.
>