Automated export from Excel to Outlook

M

MCorrea

Hello,

I have a simple Excel worksheet that I use as a form. In the sheet there
are various cells with different fields (client's name, phone, address, next
meeting). The meeting date cell is formated as mm/dd/yy h:min. Is there any
way that when I insert the information in this cell, it would be automaticly
exported to Outlook's calendar with the client information???

Thanks,

Marcio Correa
 
G

GJones

Hi MCorrea;

I'll take a three stabs at it.

(1) If I understand your question correctly you could us
then OnChange event for the cell and open Outlook as an
automation object and then tell VBA in Outlook to pull in
the line.

(2) A simpler way might be to make all the changes in
Excel and save and close the file out and then writting
the macro in Outlook to import the information from the
Excel file.

(3) You could have the excel file write directly to a
database and then have Outlook update from the database.
That would create a collaborative environment.

Hope that helps.

Greg
 
Top