Designing a form in contacts - noob question

[Guest]

I have created a new contacts form in Outlook. It was created a couple of
years back by me and I created some custom fields.
Now I realize custom fields don't export into Excel. However I noticed the
"User1" field does, so I was wondering if I add this "user1" filed to the
custom form, is there a way I can set it to copy the info from this custom
box I created to this "user1" box, what I mean is it mirror any info put into
the custom box I created. That way I will see it in the Excel export.

Hope this made sense I really need some help on this to keep the bosses happy.

 

[Sue Mosher [MVP-Outlook]]

The code sample at http://www.outlookcode.com/d/convertfields.htm does almost exactly what you want. It copies data from a custom field to User1, etc. You should be able to reverse that for existing data. Then for the long term, you can redesign your form to set the value of the User1 field either by binding it to the control you're currently using or by putting a little code in the Iem_Write event handler that sets the value of User1.

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/com...spx?dg=microsoft.public.outlook.program_forms


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Hi Sue, for some reason your link doesn't work for me. I'll try again later,
maybe the site is just down for maintenance?

 

[Sue Mosher [MVP-Outlook]]

Sorry, it should be http://www.outlookcode.com/d/code/convertfields.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers