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.

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"SW" wrote in message ...
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.

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]" wrote:

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"SW" wrote in message ...
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.

Change:

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

to

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

--
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

"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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

--
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

"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"SW" wrote in message ...

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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


"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.

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]" wrote:

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"SW" wrote in message ...

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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


"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.

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

--
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

"SW" wrote in message ...
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]" wrote:

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.


"SW" wrote in message ...

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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


"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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, 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]" wrote:

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

--
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

"SW" wrote in message ...
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]" wrote:

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.


"SW" wrote in message ...

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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


"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"SW" wrote in message ...
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]" wrote:

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

"SW" wrote in message ...
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]" wrote:

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.


"SW" wrote in message ...

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

"Sue Mosher [MVP-Outlook]" wrote:

Change:

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

to

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


"SW" wrote in message ...
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]" wrote:

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.

"SW" wrote in message ...
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.