Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / October 2007

Tip: Looking for answers? Try searching our database.

How to input values to BusinessStreet2 and BusinessStreet3

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ac8812@yahoo.com - 25 Oct 2007 09:22 GMT
Hi experts,

Would you please advise me how to input values to BuesinessStreet2 and
BusinessStreet3.

I have exported the information of contacts of address book to Excel
file. I found that there are extra fields besides BusinessStreet2 and
BusinessStreet3 in Excel file but I cannot find separate fields in
Outlook - three fields BusinessStreet, BusinessStreet2 and
BusinessStreet3 are merged into one field.

I can sucessfully import the BusinessStreet2 and BusinessStreet3 into
Outlook but unable to export the same values to BusinessStreet2 and
BusinessStreet3. Would you please advise me whether it is a known
Symptom or advise me some ways to fix the problems.

Thanks and regards,
AC
Karl Timmermans - 26 Oct 2007 22:36 GMT
The street address is exported as a single "multi-line" field. There is no
way to export individual street lines from Outlook.

Your options are:

#1 - Split the streetaddress line within Excel into mutiple fields which
will give you the desired results.
#2 - If you are going to do this on a repeated basis - one of our Exporter
versions may be of interest to you which does suport split line export of
all street address fields - http://www.contactgenie.com/cgxfeatures.htm

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

> Hi experts,
>
[quoted text clipped - 14 lines]
> Thanks and regards,
> AC

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.