Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   How do I export Contacts and ensure BusinessStreet fields map OK? (http://www.outlookbanter.com/outlook-using-contacts/3370-how-do-i-export-contacts.html)

Jemmeroni February 3rd 06 08:22 PM

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?

Sue Mosher [MVP-Outlook] February 27th 06 08:22 PM

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?


Jemmeroni February 27th 06 09:55 PM

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?



Sue Mosher [MVP-Outlook] February 27th 06 10:16 PM

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