Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    NJ
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filtering during export (ol2k)

    I've read that a filter button is supposed to appear in the dialog box after i've selected export contacts to an excel file. It doesn't appear for me.
    Is there any way I can selectively export specific contacts?

  2. #2
    Star Lounger
    Join Date
    Jul 2001
    Location
    Perth, Western Australia, Australia
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering during export (ol2k)

    Sorry, I can't recall ever seeing a filter button on any version of Outlook that I have used when exporting any type of data. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    What may be a workable solution for you is to filter the contacts before you try to export them. Create a filter within your contacts folder which will give you just the contacts you are after, then create a new Contacts folder and copy those contacts to it. Use the new contacts folder when you do the export.

    Not exactly what you are after <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>, but the best I can think of to solve your problem. Perhaps someone more knowledgeable than me knows of a better way, or knows if there should be a filter button somewhere in the export process <img src=/S/question.gif border=0 alt=question width=15 height=15>

    Hope this helps.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Location
    NJ
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering during export (ol2k)

    barry,

    Thanks, This idea might solve some other problems. For example, my main contacts folder is too large to export to a floppy. If i break it up into chunks (by copying, say the first 500 to another folder), I might be able to fit each chunk on multiple floppies.

    thanx again

    art

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering during export (ol2k)

    Or just include the field(s) you want to use to define whether or not you want to keep as an exported copy, export to csv and do a sort in Excel on the field.
    It would then simply be a matter of deleting the rows with the unwanted contacts.

    I only suggest this as I personally would be able to achieve faster results in Excel rather than with multiple copies and exports.

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering during export (ol2k)

    Excel? Integration? Who would have thunk it! Excel's a good idea. Or, if you have Access 2000 and a reasonable comfort level with it, you can link a table to Outlook objects and manipulate them that way. This gives some powerful query capability. It can be confusing because you're looking at the raw data. And you probably don't want to write back into Outlook. But it is an option.

  6. #6
    Lounger
    Join Date
    Sep 2001
    Location
    NJ
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering during export (ol2k)

    Thanx for reminding me, that although I can't filter on rows, I can filter on fields (columns) using the field mapping - I just tried it
    excel is mostly fine and I have a fair comfort level with it.
    I do have one major problem with excel and the way it interacts with contacts: two fields: (1) business address, and (2) business street address. These fields have embedded carriage returns and/or line feeds and these drive me crazy when using them in excel. They do not "copy and paste" intuitively and they do not export to excel intuitively. I find that exporting to a <img src=/S/alien.gif border=0 alt=alien width=14 height=15> csv field and then converting the csv to an excel file works better, but this is a pain in the neck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •