Creating a new contact with multiple line address

[Jason]

I am trying to add contacts in outlook from excel who have 3 lines for their
business address. I can parse the city, state and zip from the last line but
am unsure how to add multi line street address.

 

[Michael Bauer [MVP - Outlook]]

Why would you need multiple lines for the street?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 9 Dec 2008 10:04:05 -0800 schrieb Jason:

 

[Jason]

In Excel I have 2 cells for street address. The first cell has the street
(123 Main St). The second cell can have office info like suite number, mail
stop, building number, etc... that does not belong on the first line.

There is a third cell that has city, state and zip info that I can parse,
but I was to know how to use the two cells to create two lines for the street
address when I create a new contact in Outlook.

 

[Michael Bauer [MVP - Outlook]]

I think, you can join the content of the two cells with vbCRLF and write
that into the *Street property of the contact.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 9 Dec 2008 13:10:00 -0800 schrieb Jason: