How do I export Contacts and ensure BusinessStreet fields map OK?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jemmeroni - 03 Feb 2006 19:22 GMT

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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Feb 2006 19:22 GMT

That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for?

Signature

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

> When I export to either an Excel or .CSV file, data from BusinessStreet;
> BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only,
[quoted text clipped - 3 lines]
>
> Any suggestions?

Reply to this Message

Jemmeroni - 27 Feb 2006 20:55 GMT

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?

> That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for?
>
[quoted text clipped - 5 lines]
> >
> > Any suggestions?

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Feb 2006 21:16 GMT

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.

Signature

> Because Outlook nests fields BusinessStreet2 and BusinessStreet3 in
> BusinessStreet, I assumed that when it exported data, it would separate the
[quoted text clipped - 9 lines]
>> >
>> > Any suggestions?

Reply to this Message