|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 23rd 06, 03:18 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Designing a form in contacts - noob question
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. 
|
|
#2
March 23rd 06, 05:14 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Designing a form in contacts - noob question
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.
|
|
#3
March 24th 06, 11:30 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Designing a form in contacts - noob question
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.
|
|
#4
March 24th 06, 02:07 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Designing a form in contacts - noob question
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.
|
|
#5
March 24th 06, 06:53 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Designing a form in contacts - noob question
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.
|
|
#6
March 24th 06, 08:36 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Designing a form in contacts - noob question
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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| (Noob) VB6 COM Addin Question | Mike K | Add-ins for Outlook | 2 | March 15th 06 04:33 PM |
| Complete Noob Here - Outlook Form - Concept | SFC Charlie Cox | Outlook - Using Forms | 9 | March 15th 06 01:44 PM |
| Another question about custom Meeting Request form | ML | Outlook - Using Forms | 0 | February 11th 06 04:17 PM |
| Question about Changing Default Outlook Form | ChrisB | Outlook - Using Forms | 1 | February 9th 06 08:47 PM |
| designing a form in Outlook and Then changing it | donald | Outlook - Using Forms | 0 | January 11th 06 04:48 PM |
Hybrid Mode
