Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Outlook files and importing data from within Excel
Hello,
I'm using both 2003 and 2007 Outlook and Windows XP Pro. I have a particular worksheet, in Excel, named DataSheet and I update this document daily to retrieve new information. It is organized in a database format and a friend is writing some code to select specific columns of data and import it into outlook Contacts so we can use it for journaling. My problem is this: Is there a way in Excel to trigger an operation in Outlook to open the contacts file and then run a macro to merge this data with the Outlook files. I've done some with code before in Excel/Word combination and it worked as expected. Any help would be appreciated. Thank you Bob Reynolds |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Outlook files and importing data from within Excel
You might find something useful he
http://www.rondebruin.nl/sendmail.htm "BobR" wrote: Hello, I'm using both 2003 and 2007 Outlook and Windows XP Pro. I have a particular worksheet, in Excel, named DataSheet and I update this document daily to retrieve new information. It is organized in a database format and a friend is writing some code to select specific columns of data and import it into outlook Contacts so we can use it for journaling. My problem is this: Is there a way in Excel to trigger an operation in Outlook to open the contacts file and then run a macro to merge this data with the Outlook files. I've done some with code before in Excel/Word combination and it worked as expected. Any help would be appreciated. Thank you Bob Reynolds |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Outlook files and importing data from within Excel
Bob,
You can automate the transfer of data from an Excel workbook to the contacts folder (or any other OL folder for that matter) to create new contacts or to add or edit information about existing contacts. It might help if you provide a more specific example of what you want to accomplish. Steve Yandl "BobR" wrote in message . .. Hello, I'm using both 2003 and 2007 Outlook and Windows XP Pro. I have a particular worksheet, in Excel, named DataSheet and I update this document daily to retrieve new information. It is organized in a database format and a friend is writing some code to select specific columns of data and import it into outlook Contacts so we can use it for journaling. My problem is this: Is there a way in Excel to trigger an operation in Outlook to open the contacts file and then run a macro to merge this data with the Outlook files. I've done some with code before in Excel/Word combination and it worked as expected. Any help would be appreciated. Thank you Bob Reynolds |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Outlook files and importing data from within Excel
On Feb 26, 9:15*pm, "Steve Yandl" wrote:
Bob, You can automate the transfer of data from an Excel workbook to the contacts folder (or any other OL folder for that matter) to create new contacts or to add or edit information about existing contacts. *It might help if you provide a more specific example of what you want to accomplish. Steve Yandl "BobR" wrote in message . .. Hello, I'm using both 2003 and 2007 Outlook and Windows XP Pro. I have a particular worksheet, in Excel, named DataSheet and I update this document daily to retrieve new information. It is organized in a database format and a friend is writing some code to select specific columns of data and import it into outlook Contacts so we can use it for journaling. My problem is this: Is there a way in Excel to trigger an operation in Outlook to open the contacts file and then run a macro to merge this data with the Outlook files. I've done some with code before in Excel/Word combination and it worked as expected. Any help would be appreciated. Thank you Bob Reynolds- Hide quoted text - - Show quoted text - Thanks to all. Our second option is probably what I need. I have a contact list in excel and want to merge it into my contacts list of outlook. From there I will use these contacts to journal various entries. Any additional info would be appreciated. Thanks Bob Reynolds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from multiple excel files | Excel Discussion (Misc queries) | |||
Importing data from Excel to Outlook | Excel Discussion (Misc queries) | |||
Translaton Error when importing Excel data into Outlook? | Excel Discussion (Misc queries) | |||
Activating Worksheets and Importing Data from them | Excel Programming | |||
importing Excell data into Outlook | Excel Programming |