![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I have entered names, addresses, etc into an access database. I'd like to
transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
Ads |
#2
|
|||
|
|||
![]()
Did you use the FIle | Import and Export command in Outlook and click the Custom Field Mapping button to make sure Outlook knows how to store your data?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... I have entered names, addresses, etc into an access database. I'd like to transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
#3
|
|||
|
|||
![]()
Sue,
Thanks for the response. I wasn't sure what to do tiwh the custom field mapping button...how do they work to tell outlook how to store data? i.e.what do I do with them? Kevin Dew "Sue Mosher [MVP-Outlook]" wrote: Did you use the FIle | Import and Export command in Outlook and click the Custom Field Mapping button to make sure Outlook knows how to store your data? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... I have entered names, addresses, etc into an access database. I'd like to transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
#4
|
|||
|
|||
![]()
Click it and you'll see a dialog that lets you associate a column in your named range (for best results, include the column header row in the range) with an Outlook property.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... Sue, Thanks for the response. I wasn't sure what to do tiwh the custom field mapping button...how do they work to tell outlook how to store data? i.e.what do I do with them? Kevin Dew "Sue Mosher [MVP-Outlook]" wrote: Did you use the FIle | Import and Export command in Outlook and click the Custom Field Mapping button to make sure Outlook knows how to store your data? "Ghiadoc" wrote in message ... I have entered names, addresses, etc into an access database. I'd like to transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
#5
|
|||
|
|||
![]()
I guess I'm a total idiot, I have no idea what you mean by column header row
in the range this is the path I'm following contacts-import and export-import from another file-next-microsoft access-next-replace duplicates with items imported-next-select contacts as destination folder-next-then I get a dialog box titled "import a file" with boxes to check the following, Import calls/import contac types/import contacts/import switchboard items into the contact folder Now what do I do? I'm not sure what to do from here. "Sue Mosher [MVP-Outlook]" wrote: Click it and you'll see a dialog that lets you associate a column in your named range (for best results, include the column header row in the range) with an Outlook property. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... Sue, Thanks for the response. I wasn't sure what to do tiwh the custom field mapping button...how do they work to tell outlook how to store data? i.e.what do I do with them? Kevin Dew "Sue Mosher [MVP-Outlook]" wrote: Did you use the FIle | Import and Export command in Outlook and click the Custom Field Mapping button to make sure Outlook knows how to store your data? "Ghiadoc" wrote in message ... I have entered names, addresses, etc into an access database. I'd like to transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
#6
|
|||
|
|||
![]()
I have no idea what you mean by column header row
in the range Sorry, for some reason I read Excel instead of Access. The same principle applies, though. Your database has fields defined for each table. Those field names will be available in the Map Custom Fields dialog. I get a dialog box titled "import a file" with boxes to check the following, Import calls/import contac types/import contacts/import switchboard items into the contact folder You must choose which table you want to import. You know your database structure. We don't. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... I guess I'm a total idiot, I have no idea what you mean by column header row in the range this is the path I'm following contacts-import and export-import from another file-next-microsoft access-next-replace duplicates with items imported-next-select contacts as destination folder-next-then I get a dialog box titled "import a file" with boxes to check the following, Import calls/import contac types/import contacts/import switchboard items into the contact folder Now what do I do? I'm not sure what to do from here. "Sue Mosher [MVP-Outlook]" wrote: Click it and you'll see a dialog that lets you associate a column in your named range (for best results, include the column header row in the range) with an Outlook property. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ghiadoc" wrote in message ... Sue, Thanks for the response. I wasn't sure what to do tiwh the custom field mapping button...how do they work to tell outlook how to store data? i.e.what do I do with them? Kevin Dew "Sue Mosher [MVP-Outlook]" wrote: Did you use the FIle | Import and Export command in Outlook and click the Custom Field Mapping button to make sure Outlook knows how to store your data? "Ghiadoc" wrote in message ... I have entered names, addresses, etc into an access database. I'd like to transfer all of this information in to Outlook contacts. Only the names transferred, not the addresses. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get access to my contact list easily? | Joel | Outlook - Using Contacts | 3 | May 12th 06 11:25 AM |
How do I transfer my Outlook contact list to a new computer? | lee | Outlook - Using Contacts | 1 | April 27th 06 02:04 PM |
Can you transfer outlook contact information from computers? | ar_tyler | Outlook - Using Contacts | 1 | March 27th 06 03:53 AM |
Can't created groups or use addresses in contact list ... | Air | Outlook - Using Contacts | 9 | March 16th 06 03:21 AM |
How do I transfer my Palm addresses in to Office 2000? | Bob907 | Outlook - Using Contacts | 1 | February 15th 06 04:33 PM |