![]() |
How do I export Contacts and ensure BusinessStreet fields map OK?
When I export to either an Excel or .CSV file, data from BusinessStreet;
BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only, with no spaces, leaving the other two fields empty. I have used the Clear Map and Default Map commands to clear any old mapping. Any suggestions? |
How do I export Contacts and ensure BusinessStreet fields map OK?
That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for?
-- 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 "Jemmeroni" wrote in message ... When I export to either an Excel or .CSV file, data from BusinessStreet; BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only, with no spaces, leaving the other two fields empty. I have used the Clear Map and Default Map commands to clear any old mapping. Any suggestions? |
How do I export Contacts and ensure BusinessStreet fields map
Because Outlook nests fields BusinessStreet2 and BusinessStreet3 in
BusinessStreet, I assumed that when it exported data, it would separate the fields as default: how do I achieve this behavior, then? "Sue Mosher [MVP-Outlook]" wrote: That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for? -- 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 "Jemmeroni" wrote in message ... When I export to either an Excel or .CSV file, data from BusinessStreet; BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only, with no spaces, leaving the other two fields empty. I have used the Clear Map and Default Map commands to clear any old mapping. Any suggestions? |
How do I export Contacts and ensure BusinessStreet fields map
Let me put it another way: The problem is that Outlook doesn't really have any BusinessStreet2 and BusinessStreet3 fields. I don't know why the Import/Export Wizard teases users with the suggestion that it does. But I've never seen it break Business Street into multiple fields in an export.
-- 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 "Jemmeroni" wrote in message ... Because Outlook nests fields BusinessStreet2 and BusinessStreet3 in BusinessStreet, I assumed that when it exported data, it would separate the fields as default: how do I achieve this behavior, then? "Sue Mosher [MVP-Outlook]" wrote: That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for? "Jemmeroni" wrote in message ... When I export to either an Excel or .CSV file, data from BusinessStreet; BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only, with no spaces, leaving the other two fields empty. I have used the Clear Map and Default Map commands to clear any old mapping. Any suggestions? |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com