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

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
 
R

Roady [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activating Outlook files and importing data from within Excel 3
Problem Importing data from excel to Outlook 2007 with Business Contact 2
Import contacts 2
synchronising Outlook 2007 contacts data with backed up version 4
Getting address book for email populated from Contacts List 3
Contacts forwarded or attached from Outlook 2003 to Outlook 2007 are blank 2
Importing excel spreadsheet into contacts 1
Hyperlinking to Outlook contacts in office 2007 4

Top