Software

Ask something
Discussion Locked

MS 2007 Outlook Macro

0 helpful
1 reply

by sspies

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In the simplest of terms, I'm attempting to to eat an elephant in my opinion.

I am trying to have the office schedule feed to the oulook accounts that are set up for the office. The schedule is done in Excel, which I have fed in to a "breakdown" of the daily duties. This has been the easy part leading to my main question. What would the programming look like in VBA for Outlook for a macro that would 1) automatically import the information from the "breakdown" MS Excel 97-03 Spreadsheet in to the calendar of outlook & 2) delete any existing "events" in the calendar for the same day (not all events for the day, just events with the same subject/name as what is being imported).

Everything is working (except the deleting part mentioned above) by manually importing the information, but trying to teach the office how to import and having them do this any time a schedule change is made would be next to madness. Can anyone help with this?

1 reply

by charliespencer

Try reposting this using the 'Ask a Question' button. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution.

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the two forums, you'll find more of those members in 'Questions' than here in 'Discussions'.

Additional benefits to the membership include:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The TR search function makes it difficult to find a particular "Discussion" or "Question" if it has not had a recent post; the two types get mingled in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for

This discussion is closed to new replies.