Geiermann, Joe
2008-03-05T21:57:00Z
I have read the other FAQs about mapping the fields and have successfully mapped our
Street Address1 to BusinessAddressStreet
City to BusinessAddressCity and also the state country and postal-zip.
I still have StreetAddress2 and StreetAddress3. The outlook Street Address allows multi lines and when importing and exporting it makes those extra lines available as BusinessAddressStreet2 and BusinessAddressStreet3.
I can use a query to correct the data coming into my database with one street address with three lines and split it into three fields with one line each but then when I replicate back I am only going to have one line in outlook.

Any assistance would be appreciated


Joe
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2008-03-06T15:52:00Z
Hello,

Outlook has only BusinessAddressStreet column, you will have to write a insert/update stored procedure (see SQL Commands topic),
and split BusinessAddressStreet into 3 columns inside your stored procedure.
Geiermann, Joe
2008-03-06T16:40:00Z
Thanks that is what I thought.

Joe