| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 85220 | 2007-12-04 01:03:00 | Exporting contacts from Outlook 2003 | Tony (4941) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 617661 | 2007-12-04 01:03:00 | I want to be able to export contacts from Outlook, selecting by category. Outlook doesn't seem to let you do this as part of the normal export. (a) Am I missing something obvious or (b) can I do it with VBA (which I've never used in Outlook, although I have in Access) or (c) should I just think of some other way to assemble/filter this data - if so, what? I had a look at the first 3-4 pages of the 1,200,000 pages that Google returned, but couldn't find anything there. I notice that when I export, there are fields called User 1,2,3 and 4. presumably I could put my filter data in there - but how do I make those fields available for all my contacts - do I need to create a custom form or something? |
Tony (4941) | ||
| 617662 | 2007-12-04 02:15:00 | Ummmm, file>export>export to a file>csv, pst, access or excel. once exported then you can manipulate the data by category | SolMiester (139) | ||
| 617663 | 2007-12-04 02:17:00 | Well, yes, that is what I would like to do, but "category" doesn't seem to be one of the fields that is exported - unless, as I say, I am missing something obvious. | Tony (4941) | ||
| 617664 | 2007-12-04 02:38:00 | Use the pst folder option, then click on filter and more choices tab, you can select categories there! | SolMiester (139) | ||
| 617665 | 2007-12-04 02:53:00 | OK, I see what you are saying, but exporting to a PST file gives me a PST file - what I want is Access or Excel - or do I have to do it in two stages by then re-exporting the filtered PST file? :confused: |
Tony (4941) | ||
| 617666 | 2007-12-04 03:12:00 | As solmiester instructed inpost #2 file>export>Export to a file>(Select type/ Excel) Select the "Contacts" in the list, browse to the location you want to save it - call it something - then you can select Map Custom fields See Here (www.imagef1.net.nz) and sort out the details you want. | wainuitech (129) | ||
| 617667 | 2007-12-04 03:25:00 | Then you can select Map Custom fields See Here (www.imagef1.net.nz) and sort out the details you want.That's where it seems to be turning to custard for me - I don't see "categories" as an available field at that point. D'Oh!!! I just looked again and categories is an available field - why I missed it on my initial look I don't know. :o Of course that will then export all my contacts, but I guess I can then filter them to the categories I need from within Access/Excel. Thanks guys for your patience - put it down to a senior moment on my part. |
Tony (4941) | ||
| 617668 | 2007-12-04 04:31:00 | :thumbs: thats cool - all miss things sometimes. Like the Mrs car had it fixed last week - still playing up >>>Wainuitech not happy about it |
wainuitech (129) | ||
| 1 | |||||