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

You might find something useful here:

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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:6JWwj.94307$(E-Mail Removed)...
> 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
>

On Feb 26, 9:15*pm, "Steve Yandl" <syandl_nos...@comcast.net> 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" <rjr1...@bellsouth.net> wrote in message
>
> news:6JWwj.94307$(E-Mail Removed)...
>
>
>
> > 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