|
|
Linking a custom form field to an Excel or SharePoint List
Is there any way to create a lookup field within Outlook that uses for its
content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
I forgot to mention I have Outlook 2003 SP2 Professional Edition.
-- DougD "DougD" wrote: Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source.
-- 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 "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
Can you provide any guidance on how to do this or references/examples I can
use to get me started? -- DougD "Sue Mosher [MVP-Outlook]" wrote: Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source. -- 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 "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
The basics of filling a list on a custom form are covered at http://www.outlookcode.com/d/formcontrols.htm#listcombo . Getting data from Excel is a simple matter of opening the worksheet and iterating the right rows; some of the import samples at http://www.outlookcode.com/d/customimport.htm should give you those basics.
Retrieving data from SharePoint is something I don't have a good VBScript sample for, but I'm sure Google can turn up one for you. BTW, Microsoft InfoPath does a lot of this out of the box and is definitely the future of intra-organization forms. -- 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 "DougD" wrote in message ... Can you provide any guidance on how to do this or references/examples I can use to get me started? -- DougD "Sue Mosher [MVP-Outlook]" wrote: Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source. "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
Thanks much Sue. That provides me with a wealth of information.
However, unless I missed it, it seems like these references are all talking about importing data into (or exporting data out of) Outlook from (or to) an Excel spreadsheet. That isn't exactly what I'm interested in. I want to permanently link an Outlook custom form field to a specific column in an existing spreadsheet and create a lookup field (drop down menu) in Outlook that uses the values from that spreadsheet column. Is that included here and I just missed it? What custom form field type would be the basis to create the drop down menu? -- DougD "Sue Mosher [MVP-Outlook]" wrote: The basics of filling a list on a custom form are covered at http://www.outlookcode.com/d/formcontrols.htm#listcombo . Getting data from Excel is a simple matter of opening the worksheet and iterating the right rows; some of the import samples at http://www.outlookcode.com/d/customimport.htm should give you those basics. Retrieving data from SharePoint is something I don't have a good VBScript sample for, but I'm sure Google can turn up one for you. BTW, Microsoft InfoPath does a lot of this out of the box and is definitely the future of intra-organization forms. -- 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 "DougD" wrote in message ... Can you provide any guidance on how to do this or references/examples I can use to get me started? -- DougD "Sue Mosher [MVP-Outlook]" wrote: Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source. "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
You missed it: The only way to have such a permanent link is to build in that functionality with your own custom code.
I suggested the Excel samples as a way of getting you up to speed on writing Excel code in case you hadn't done that before. Nowhere did I suggest that export/import itself would be part of your solution. -- 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 "DougD" wrote in message ... Thanks much Sue. That provides me with a wealth of information. However, unless I missed it, it seems like these references are all talking about importing data into (or exporting data out of) Outlook from (or to) an Excel spreadsheet. That isn't exactly what I'm interested in. I want to permanently link an Outlook custom form field to a specific column in an existing spreadsheet and create a lookup field (drop down menu) in Outlook that uses the values from that spreadsheet column. Is that included here and I just missed it? What custom form field type would be the basis to create the drop down menu? -- DougD "Sue Mosher [MVP-Outlook]" wrote: The basics of filling a list on a custom form are covered at http://www.outlookcode.com/d/formcontrols.htm#listcombo . Getting data from Excel is a simple matter of opening the worksheet and iterating the right rows; some of the import samples at http://www.outlookcode.com/d/customimport.htm should give you those basics. Retrieving data from SharePoint is something I don't have a good VBScript sample for, but I'm sure Google can turn up one for you. BTW, Microsoft InfoPath does a lot of this out of the box and is definitely the future of intra-organization forms. "DougD" wrote in message ... Can you provide any guidance on how to do this or references/examples I can use to get me started? -- DougD "Sue Mosher [MVP-Outlook]" wrote: Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source. "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
Linking a custom form field to an Excel or SharePoint List
Ok, thanks again, I'm with you now. As a relative novice to writing code,
this seems a bit overwhelming. I'm stuggling with where to start. -- DougD "Sue Mosher [MVP-Outlook]" wrote: You missed it: The only way to have such a permanent link is to build in that functionality with your own custom code. I suggested the Excel samples as a way of getting you up to speed on writing Excel code in case you hadn't done that before. Nowhere did I suggest that export/import itself would be part of your solution. -- 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 "DougD" wrote in message ... Thanks much Sue. That provides me with a wealth of information. However, unless I missed it, it seems like these references are all talking about importing data into (or exporting data out of) Outlook from (or to) an Excel spreadsheet. That isn't exactly what I'm interested in. I want to permanently link an Outlook custom form field to a specific column in an existing spreadsheet and create a lookup field (drop down menu) in Outlook that uses the values from that spreadsheet column. Is that included here and I just missed it? What custom form field type would be the basis to create the drop down menu? -- DougD "Sue Mosher [MVP-Outlook]" wrote: The basics of filling a list on a custom form are covered at http://www.outlookcode.com/d/formcontrols.htm#listcombo . Getting data from Excel is a simple matter of opening the worksheet and iterating the right rows; some of the import samples at http://www.outlookcode.com/d/customimport.htm should give you those basics. Retrieving data from SharePoint is something I don't have a good VBScript sample for, but I'm sure Google can turn up one for you. BTW, Microsoft InfoPath does a lot of this out of the box and is definitely the future of intra-organization forms. "DougD" wrote in message ... Can you provide any guidance on how to do this or references/examples I can use to get me started? -- DougD "Sue Mosher [MVP-Outlook]" wrote: Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source. "DougD" wrote in message ... Is there any way to create a lookup field within Outlook that uses for its content an Excel spreadsheat or SharePoint list? I have a SharePoint list that contains a "Client Account Field" to which many of the contacts within Outlook are associated. It would be much easier for the user to have lookup field from which they can select the proper Client Account. This could be built as a choice field but that would have to be updated each time a new client account is added or amended. A link would be a much better solution if that is possible. -- DougD |
| All times are GMT +1. The time now is 07:55 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com