Create multiple to do list

I have data in XL that containing (more than this but important for now) date, name and status (active/non active that is changable).

I would like to create To do list in outlook (or meeting request, appointment...) or anything else that will import all dates and warn me month before expired.
(that will be enough but if there is option to warn me each day or every monday within month if it's non-active even better).

I have hundreds of inputs and they are spread over whole year.

What's best and/or easiest way to do this so I don't need to write in one by one?

I don't know what kind of example to create... if you need some let me know...

I've posted a few times re: importing tasks etc into OL and I'm pretty sure Leith has also - if you do a Search with either of myself / Leith as member and Outlook as topic you should find a few threads that may help... worth also checking out the link re: Outlook VBA in my sig.

Being the capable chap you are see how far you can get under your own steam and then post back perhaps with a sample of where you've got to - if needed we can help from there...

What happens when the Task has been completed ? ie Date3 is "Completed"

Are you looking to re-run this routine over-and-over and if so what happens to pre-existing Tasks ?

Still not clear to me what is meant to happen when the date fields are not dates ... in theory this will cause problems so in the below for the sake of demo I have ignored... as is this would take up too much of my time and I think you should enough to work from below....

Please Login or Register  to view this content.

Note line in red - this is to limit the amount of tasks being created initially -- else you OL is liable to overflow.. ie only run full blooded version once you know it's doing exactly what you want.

Re: formatting Body etc... you can use HTML format if you want (ie use HTML mark-up) and you can also make use of HEX codes in addition to standard vblf etc... you will find plenty of examples on line.

The above is designed solely for use with OL2007 given use of Categories.

The code utilises early binding and thus requires reference to OL Object Library (VBE - Tools - References: Microsoft Outlook 12.0 Object Library)
I had presumed you would be aware of that requirement.

zbor, as I stated earlier...

Originally Posted by DO

...as is this would take up too much of my time and I think you should enough to work from below....

I think you need to attempt to progress this with some effort on your own part - what you have presently is fairly extensive piece of work ...

Originally Posted by zbor

...just for the info: things with labels didn't work. All categories are red categories and every status is Waiting for someone else.

Regards Categories:

The Categories you apply will depend on what they're called in your OL ... for ex. I don't use Categories at all and so by default they are "Green Category", "Red Category" etc... if you have renamed your categories then you will most likely need to utilise those edited names.

HOWEVER - note point below...

Regards Status':

The fact that all are showing as "Waiting" would imply that the (upper case) contents of "E" are not matching any of: "IN PROGRESS", "COMPLETED", "NOT STARTED" ... you should check the cell contents against the Select Case statement options and revise accordingly
ie Red is applied to anything other than the above strings being in Col E
(note: Upper Case conversion - VBA unlike Native XL is by default Case-Sensitive - can be altered (add Option Compare Text at Head of Module) but enforcing common-case when required is sometimes a little safer IMO)

Originally Posted by zbor

I must have populated all dates (not empty cells, text etc.)

Agreed, this was a point I made early on in the piece I think.