A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Exporting OL2k contacts so street number and name go into different fields?



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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].




 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
exporting contacts from Outlook 2000 to Outlook Express Inon Zukerman Outlook - General Queries 3 January 10th 06 08:15 PM
Custom Task Fields Milly Staples [MVP - Outlook] Outlook - General Queries 0 January 7th 06 06:07 PM


All times are GMT +1. The time now is 10:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.