viewing values in source file for exporting

  • Thread starter Thread starter CF
  • Start date Start date
C

CF

Hi,
I'm using Outlook 2000. First time that I'm trying to
export to an Excel file. When I get to the "Map Custom
Fields" menu, not all values from the source file on the
left seem to be visible or accessible, i.e., Mailing
Address or others I may have defined. How do I make these
available to export?
 
As a follow up, I decided to do it another way -- copy and
paste. I had problems doing it this way at first because a
second line in an address field was throwing all the
following Excel cells down to the next row. Figured out
you need to keep an address to 1 line in Outlook for this
method to work.
I would still love to know the answer to my original
question though.
Also, is it possible to make the PO Box field show up in
the Contacts Dialog box address field?
Thanks for your help.
 
In answer to both of your questions:

Addresses in Outlook are composed as a sum of its parts (i.e. street, state,
country etc) and when exported are exported as a single field with line
breaks in the address field (which is valid when using an address for a mail
merge but may not be valid for other uses). Outlook does not export the
individual fields.

As for the mailing address - that is simply one of the address fields
(Business, Home, Other) that you have designated as the mailing address and
as such is not exported via Outlook under it's field names.

As for the PO Box - that's a separate field that doesn't form part of the
overall address field in Outlook in terms of the address dialog but can be
exported separately.

In terms of other fields you may want to export - all depends on which ones
and a FYI - custom fields are not exportable via the Outlook Export wizard.

Another FYI (and for anyone else reading this) - exporting contacts is not
as simplistic a process as most would think since a contact folder can
contain contacts using different custom forms (ergo - each of which
may/would have different fields) along with the fact that each contact may
have their own user-defined fields attached to them if using a standard
contact form making a universal export function less then a simplistic
process to create as a universal function. When exporting to a file - the
fields are generally defined at the outset and if additional fields are
encountered several hundreds or 000's of contacts into the export - the file
defintion needs to be changed to include these or the fields simply ignored
defeating the objective of the export.

Karl

PS - for what it's worth - we expect to have a universal export function
available that addresses the items above along with a host of other issues
sometime in the July/August timeframe based on current release estimates.

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Back
Top