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

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

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

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