Interaction between Excel and Outlook.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a date from a text file or excel spread sheet entered
into an Outlook calendar via VBA code? Does anyone have an example of such a
macro or code bit?
 
Hi Eric,

my answer is as general as your question: yes, it is possible. :-)

What do you want to do? E.g.:

macro in OL:
- open a text file and read a value
- open an excel file and read a value
- get an event in OL if a user types in a value in an excel file

macro in Excel:
- get an event in XL if a user types in a value and than open OL
- ...
 
Michael,
I want to take a date from excel or a text file along with some other text
that we can call the subject and use that information to schedule an
appointment in Outlook. I guess what I am really asking is can you add
appointments to your outlook calendar using a macro or VBA code to process
text information from a text file or excel spread sheet?
 
I guess what I am really asking is can you add
appointments to your outlook calendar using a macro or VBA code
Click to expand...

Please open your OL VBA environment and take a look at the object
browser (F2).

Application.CreateItem(olAppointmentItem) creates a new AppointmentItem
and returns a reference on it.

If you select "AppointmentItem" in the left pane of the object browser
than you can see all available properties and methods on the right site.
 
Back
Top