See Create a Series of Tasks Leading up to an Appointment for an example. With some minor tweaking, it could base the start and end times off of the original task date. For example, Task # 3 (created by the Case 2 statements) starts 4 days after the previous task, which started 2 days after the first task. Each subsequent task is based on the task before it. Updated Decemto handle a large number of tasks more efficiently. Create a series of tasks based on one task To make it easier to use, assign a toolbar or QAT button to the macro. To use, select the master task (or appointment) and run the macro. Once you are satisfied with the code, you can change the subject field as necessary. The subject in my example includes the date of the task because it makes it easier to see that it is working. If you need to create a large number of tasks or skip weekends and holidays, it will be easier to create the tasks (or appointments) in Excel and Import them into Outlook or use a utility from the Tools section below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |