Outlook 2003/2007 importing data from an excel spreadsheet into contacts

  • Thread starter Thread starter BobR
  • Start date Start date
B

BobR

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
 
If you want to initiate this from within Excel, an Excel newsgroup would be
more appropriate. More specific you want to ask it in an Excel developer
newsgroup.
 
Back
Top