Hi there,
I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a naive user to enter data into a new contact in outlook be able to push a button and insert that data into a quotation that exists as a excel file. The data that I am interested in moving includes.
Title
First name
Last Name
Company
Address Fields
Telephone Number
I have already created the spreadsheet based Quotation form in a file called Quote.xls. I have not named the individual cells at present just having the Name in Cell B1 The company in B2 and the address fields in B3 to B7.
I have done some macro and VBA programming in Excel, but have little or no experience in using Outlook macros.
Any help/suggestions/solutions gratefully received.
Regards
Michael
I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a naive user to enter data into a new contact in outlook be able to push a button and insert that data into a quotation that exists as a excel file. The data that I am interested in moving includes.
Title
First name
Last Name
Company
Address Fields
Telephone Number
I have already created the spreadsheet based Quotation form in a file called Quote.xls. I have not named the individual cells at present just having the Name in Cell B1 The company in B2 and the address fields in B3 to B7.
I have done some macro and VBA programming in Excel, but have little or no experience in using Outlook macros.
Any help/suggestions/solutions gratefully received.
Regards
Michael