View Single Post
  #1  
Old January 11th 06, 01:22 PM posted to microsoft.public.outlook
David Tong
external usenet poster
 
Posts: 8
Default Exporting OL2k contacts so street number and name go into different fields?

Our local residents association has each subscriber listed as a separate
contact in Outlook 2k. We want to print labels for a mailing by volunteers
and it would be a big help to pre-sort the envelopes by street name first.
Problem is I can't see how to do it.

I tried exporting the contacts as a 'Windows csv' file and opened it in
Excel 2k hoping to sort on street name. But, although town and postcode
appear correctly in the fields 'Business City' and 'Business Postcode', all
of the rest, say '1 Acacia Gardens, Suburbia', goes into 'Business Street'
with the two other fields 'Business Street 2' and 'Business Street 3' empty.

Can anyone advise how we can get '1' to go into 'Business Street', 'Acacia
Gardens' into 'Business Street 2' and 'Suburbia' into 'Business Street 3'?

--
David Tong
[Please replace 'invalid' with 'com' to reply].




Ads