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 called "owner" 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.

I was kindly put in the direction of this link
(http://www.outlookcode.com/d/code/convertfields.htm) with some VB code
displayed, but am not sure what or where to put it or what to edit on it. I
hope you can help and thank sin advance for your time.

 

[Sue Mosher [MVP-Outlook]]

It's not wise to run code that you don't understand. What about the code sample do you need to know more about? The part that's important to you are the Item.<property> statements.

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

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

 

[Guest]

I'm not really sure where to start on this. I opened up my contacts form I
designed ages ago. I can see my drop down box called "owner" there. I have
just added a second box which is "user1" and now I just don't know where to
start on mirroring everthing from the "owner" box to the "user1" box.. Any
chance of a small step by step? Once I do this I think everthing will click
into place for me. Thanks again.

 

[Sue Mosher [MVP-Outlook]]

Change:

objItem.UserProperties("Custom1") = objItem.User1

to

objItem.User1 = objItem.UserProperties("Owner")

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

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

 

[Guest]

Thanks, but where do I put objItem.User1 = objItem.UserProperties("Owner")

 

[Sue Mosher [MVP-Outlook]]

As I said, you need to replace one of the existing statements in the code sample that you're using with that new statement. Also take out any statements that pertain to properties you're not changing. The code is VBA code, not Outlook form code. You run it in the VBA environment.

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

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

 

[Guest]

That could be the problem I don't have a VBA program and can't afford one at
the moment, I just use the "design form" option for everything, just thought
it was an option in there....

i take it there aren't any free tools I could use?

 

[Sue Mosher [MVP-Outlook]]

VBA is built into almost every Office program, including Outlook.

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

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

 

[Guest]

Sue, sorry for the basic questions, I just don't know where to start on this,
does you book explain where I go to do this (VBA)? etc

 

[Sue Mosher [MVP-Outlook]]

Yes, my book explains that, but you don't need a book to find out what's probably already in Outlook help and on the menus. Start with Tools | Macros | Security to change the security level from High, then restart Outlook and press Alt+F11 to enter the VBA code environment. You will find that Oulook already has created a ThisOutlookSession module for you where you can write and run code.

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

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

 

[Guest]

Great, got that VB screen up and running. Would the next step to be pasting
your script into it with the amendments. How would I associate the script
with may contacts form etc?

 

[Sue Mosher [MVP-Outlook]]

Yes, you can copy and paste.

However, the code you're working with is not intended to be associated with a particular form (and you can't use VBA code that way anyway). That code sample is intended to be run once to process all the items in a folder.

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

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