I have a spreadsheet where I update the status of different projects I'm working on. I just want a macro that will open a new task box in Outlook, and maybe add the value of a cell as the subject.
I don't want to assign to anybody and I will finish setting it up in Outlook. I just need something that will open the new task box
The Structure of the sheet is basically as follows:
<tbody>
</tbody>
So when I click the button in the form control (Column E) it will open the new task in OUTLOOK with the Value of Column D as the subject.
Does this make sense?
If you have any other ideas of a easier solution I'm all eyes.
I don't want to assign to anybody and I will finish setting it up in Outlook. I just need something that will open the new task box
The Structure of the sheet is basically as follows:
| A | B | C | D | E | |
| 1 | Job Name | Job Complete (Y/N) | Date | Note (Subject of Task) | Create Task? |
| 2 | A1213 | N | 12/14/2016 | Double check if order has been processed | (FORM Control Button) |
| 3 | |||||
| 4 |
<tbody>
</tbody>
So when I click the button in the form control (Column E) it will open the new task in OUTLOOK with the Value of Column D as the subject.
Does this make sense?
If you have any other ideas of a easier solution I'm all eyes.
