Exporting User defined Contact Field

[Keith]

I created a user defined field under the Customize current field - fields -
new field in Outlook Contacts. The new field is a Yes / No type. When I try
to export the contacts to either MS Excel or MS Access that field is not
available for export. Is there anyway to export ALL Contact fields --
including user created fields. I also tried to change the existing USER
FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy
either. I'm using Outlook 2003 SP2

HELP Thanks
--
Keith

[Sue Mosher [MVP-Outlook]]

Outlook doesn't support exporting custom fields. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools

Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm .

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Keith" <Ke...@discussions.microsoft.com> wrote in message news:2E9146D2-911F-4C79...@microsoft.com...

[Keith]

Sue - Thank you -- you are a hugh help. I used the link you provided to
navigate to the Microsoft support site (support.microsoft) and implemented
the code for the article 290792 rev 6.0 The code imports my user defined
field perfectly using the format -> rst!AccessFieldName =
c.Userproperties("OutlookPropertyName")
Also imports all the other Contact fields defined in the example code that I
copied from the Microsoft website. I tried adding the pre-defined Contacts
Field called "Modified" ..the code bombs with the error -> Run time error
438 " Object doesnt support this property or method. I have the Microsoft
Office 11.0 object, Microsoft Outlook 11.0, DAO 3.6 Object, Access 11.0,
Visual Basic for Applications, OLE Automation and MS Active X data obj 2.1
Libraries references set.

That line of code that bombs is -> rst!Modified = c.Modified
I also tried rst!Modified = c.userProperties("Modified") which also bombed.

Any ideas?

thanks Keith
--
Keith

[Sue Mosher [MVP-Outlook]]

3 problems, any one of which would sink your boat:

1) The name of the property is not Modified, but LastModificationTime.

2) It's a built-in property, so you would not use UserProperties to work with it. See http://www.outlookcode.com/d/propsyntax.htm

3) It's a read-only property, so you can't set it.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Keith" <Ke...@discussions.microsoft.com> wrote in message news:81460E24-483F-40DF...@microsoft.com...

>>

[Keith]

OK Sue, you are amazing. The name was LastModificatonTime so that works now.
Where can I find a list of property names, as LastModificationTime is only
identified as Modified in Outlook 2003 SP2. The other property name that
does not work is

rst!User_1 = c.UserField1
rst!Children = c. Children

thanks again for your help

[Sue Mosher [MVP-Outlook]]

When in doubt, check the object browser: Press ALt+F11 to open the VBA environment in Outlook, then press F2. Switch from <All Libraries> to Outlook to browse all Outlook objects and their properties, methods, and events. Select any object or member, then press F1 to see its Help topic.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Keith" <Ke...@discussions.microsoft.com> wrote in message news:A1740415-11D1-4810...@microsoft.com...

> OK Sue, you are amazing. The name was LastModificatonTime so that works now.
> Where can I find a list of property names, as LastModificationTime is only
> identified as Modified in Outlook 2003 SP2. The other property name that
> does not work is
>
> rst!User_1 = c.UserField1
> rst!Children = c. Children
>
> thanks again for your help
> --
> Keith
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> 3 problems, any one of which would sink your boat:
>>
>> 1) The name of the property is not Modified, but LastModificationTime.
>>
>> 2) It's a built-in property, so you would not use UserProperties to work with it. See http://www.outlookcode.com/d/propsyntax.htm
>>
>> 3) It's a read-only property, so you can't set it.

>>

[Keith]

Sue - I don't know what they pay you, but it is not enough. Thanks a million.
This answers all my questions.

[Keith]

Sue OK... seems that I think all is well when ...alas something else goes
wrong... I used the Object Browser to find the properties/methods for all the
items that I needed to export, some would have not been easy to guess (User1
for the Contact Item "User Field 1". EXCEPT the field in Contacts called
Children, which according to the object browser is "Children" code in
rst!Children = c.Children and get error. Must be known by another name that
the object browser does not show???

Any Ideas?

[Sue Mosher [MVP-Outlook]]

What error? Break the statement apart to see whether it's on the Access side or the OUtlook side:

strChildren = c.Children
rst!Children = strChildren

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Keith" <Ke...@discussions.microsoft.com> wrote in message news:AA1A3CFA-B498-46B4...@microsoft.com...

[Keith]

I’m so embarrassed, the problem was not with Access or Outlook, it was with
ME, The Access default text field size (50) was too small to handle the one
instance of 7 kids. Set default size to 200 and presto. Thank you again,
you provide a wonderful service.--
Keith

[OneDave]

I'm trying to find Sue Mosher-MVP here...

Sorry to inject a new thread into an old one. I'm not good at using
newsgroups. I wonder whether Sue or anyone has any idea what happened to the
"Contacts" field (or its content on import) when OL 2003 is upgraded to OL
2007? My 2003 data had a lot of cross-links. Are they lost now?

Thanks, Dave
---------------

[Sue Mosher [MVP-Outlook]]

Importing contact information *always* breaks contact links in every version. Furthermore, upgrading on the same machine never requires a data import.

The way to maintain contact links is simply to continue to use the same Personal Folders .pst file, in the same location on the hard drive.

Next time, please start a new topic thread rather than piggybacking on an unrelated topic.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"OneDave" <One...@discussions.microsoft.com> wrote in message news:9C5B96CF-F33B-426B...@microsoft.com...

[Susan May]

Hi Sue:

I've been reading your string on how to export out user defined fields,
because I need these fields in Access for reporting purposes. When I use a
table view to display the fields, they are not in there. Why is it so hard
to get these fields exported out? This should be easy and it's not. Can you
help me?

[Karl Timmermans]

As Sue stated - neither importing/exporting of custom fields is support nor
are these accessible via the Access link.

Other alternative options to Sue's suggestion:

#1 - Use this free program (not related to us):
http://www.codetwo.com/pages/freeware/outlook_export.php

Or

you are always welcome to check our exporter products (not free) in case the
additional options/features are of interest - one of which would be to
schedule any export via the task scheduler to a new .mdb which could then be
used as a linked table or alternatively into your Access MDB directly
creating a new table on each export or updating an existing table (update
feature only available in CG Exporter Premium version).
http://www.contactgenie.com/cgxfeatures.htm

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

"Susan May" <Susa...@discussions.microsoft.com> wrote in message
news:58EE3976-48EC-4A24...@microsoft.com...

[Susan May]

Thanks Karl. I've sent both links to my IT Director to check out. Have a
great weekend and thanks for your response.

[Susan May]

Hi Karl:

I am trying an evaluation copy of the ContactGenie Pro version and I really
need help - I don't understand what I'm doing. I am trying to connect my
outlook contact folder to access so I can create reports based on user
defined fields I have created. I was told by my IT department that you must
create a database first, so I imported the contact list into Access, but the
user defined fields are not there. When I tried to map the user defined
fields, it moved them over to the source file, but the original file names
are the same. Should I first create another table that I can link to the
imported contact list which has all my user defined fields listed in it? It
wouldn't let me add all the new user defined fields to the bottom of the
field list. I don't know how to import these fields in my Access file. Are
we using the correct program, or should I be evaluating the Exporter Program
and set up a scheduled export via the task scheduler to a new .mdb which

could then be used as a linked table or alternatively into your Access MDB
directly creating a new table on each export or updating an existing table
(update feature only available in CG Exporter Premium version).

Can you explain that to me or call me at 800.326.1830?

[Karl Timmermans]

In reviewing our support messages - a detailed response from CG support
(related to the email you sent detailing much of the same questions) was
sent to you earlier today. If you haven't rec'd it - please reply to this
message privately and I'll follow-up but if that is the case - please first
check your spam folder and ensure that you can receive messages from
<contactgenie.com>).

Just to recap this for anyone else reading this thread:

#1 - CG DataPorter is an "import" product taking data from any source file
into an Outlook contact folder
(http://www.contactgenie.com/cg20features.htm)
#2 - CG Exporter is our "Export" product - data goes from Outlook folder to
output data file (http://www.contactgenie.com/cgxfeatures.htm)
#3 - No CG product acts as a "connector" between Outlook and any datafiles
for any purpose outside of the product's stated function.
#4 - You cannot import or export any user-defined fields using the Outlook
import/export wizard
#5 - "Linked" tables between Outlook/Access will not provide access to any
custom fields (not a CG issue - just the way the Outlook connector for
"linked" Outlook tables works in MS Access)
#6 - Both CG DataPorter and Exporter provide options to "update" any
pre-existing info for both importing and exporting and all CG products
support custom forms/user-defined fields. Currently DataPorter will only
import data using the default message class for the folder whereas Exporter
allows for specifying which message class is to be used. All CG products
will eventually be standardized to be "message class" specific (user
selectable) regardless of the default setting is for any folder.
#7 - CG specific questions should not be posed in this newsgroup (but rather
to "support AT contactgenie.com" - as was also done in this case). This
newsgroup is purely for questions related to MS Outlook and not vendor
specific products (at least not ours in any case).

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

"Susan May" <Susa...@discussions.microsoft.com> wrote in message

news:3C4DA58A-1688-404E...@microsoft.com...

[Susan May]

Hi Karl:

Yes, I did get this message and determined we downloaded the wrong program.
So my IT department just sent me the Exporter and it took me 2x of setting up
the conditions before it exported. It looks like it imported into Access ok.
But now my question is where do I go to set up the task scheduler so it will
replace the table every week for me? How do I find the template I just
created?

Thanks again for your help.

[Karl Timmermans]

2 answers / 1 request:

#1 - Task scheduler is a Windows task (any task scheduler will do - check
with your IT dept if they have standardized on one other than the Windows
task scheduler) - WTS found in --> Accessories / System Tools / Scheduled
tasks (see CG help file on how to obtain/test exact command line options)
#2 - If you didn't save your info as a template - no way to recall it
(complete info/description included in the CG Help file - "Step-By-Step
section")

Request

For any additional specific questions related to CG - please send those to
"support AT contactgenie.com". This newsgroup is NOT a support venue for CG.
You'll find that you'll get a much faster response along with us being able
to maintain a complete support history.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

"Susan May" <Susa...@discussions.microsoft.com> wrote in message

news:9C8376EF-FED4-45C9...@microsoft.com...

[Susan May]

Thanks for your help Karl.

[Michael Greenberg]

I've played around in this area a few times now...

This is what I have found about exporting your .pst:

Microsoft does include your custom fields on export.
Microsoft does include your custom fields on import.
Microsoft doesnt iterate the newly imported pst completely so outlook wont
display the imported custom fields and their data.

Workaround:
After you import the exported pst, re-make the field names using the EXACT
field names. As soon as your done making the field, it will automatically
re-populate the data.

go ahead try it 8)
--
HarlesG

[Russ Valentine [MVP-Outlook]]

Or don't. Importing and exporting are never the correct way to transfer
Outlook data and you will continuer to lose a lot more than custom fields.
--
Russ Valentine
[MVP-Outlook]
"Michael Greenberg" <MichaelG...@discussions.microsoft.com> wrote in
message news:64724E74-EC62-4B1F...@microsoft.com...

[Michael Greenberg]

if this import/export tool built into outlook isnt the correct way to
import/export data, then why, exactly is it included in the application and
secondly why include it's own application to choose to import/export to?
--
HarlesG

[Russ Valentine [MVP-Outlook]]

Why ask me? But do pay attention to what real users have discovered. No one
who has read the posts in this group would ever use import and export when
their data is already in Outlook format.

--
Russ Valentine
[MVP-Outlook]
"Michael Greenberg" <MichaelG...@discussions.microsoft.com> wrote in

message news:1B6F9A19-7A25-47F5...@microsoft.com...

[Michael Greenberg]

I'm sorry I thought this was about importing & exporting, and I hadnt seen
anyone who had the information I found when playing around with outlooks
import/export for use to backup my business' data, which I run all from
outlook using mail merge thru word.

I did a search for importing/exporting user defined fields, using outlook,
and this thread came up. I did read some of the threads briefly and assumed
this post might help someone going thru some of the limitations of this
import/export feature. I accidently found when I named the custom fields in
the same folder exactly what they were in the original pst, that the
re-populated the data within the fields, automatically.

Maybe this is the wrong group of posts for this information, but I know I
didnt find anything like this, and I know it's a pretty hot topic from the
research I've done.

[Thatch]

There is a product called Data Fields Manager
(http://www.datafieldsmanager.com) that lets you manage all the fields in
Outlook including copying/exchange/etc.. One of the functions is to export
all the fields and they are exported into a .csv file. Quite simple, really.

T