how to export each contact address line to a separate field

D

Dan Dearing

I am trying to export my outlook contacts to an ACT! database but the same
applies to exporting them to an excel worksheet. I am having trouble with
successfully exporting business addresses
It seems that if a contact has a business address with more than one line
for the business street, this does not successfully export into the separate
fields "BusinessStreet", "BusinessStreet2" and "BusinessStreet3" as I would
expect.
It simply exports multiple lines to "BusinessStreet".

Example:
St David's House
120 Broad Street
Northampton
comes out as St David's House|120 Broad Street|Northampton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to input values to BusinessStreet2 and BusinessStreet3 1
Exporting Contacts 0
Parsing line breaks into separate cells 3
Export Contact Mailing Address to Excel 6
query to split data in a column into two separate columns 10
Creating a new contact with multiple line address 3
Using Contact List for Mail Merge - Address Format Issue 1
How can I easily export mailing addresses? 5

Top