Open a new task in Outlook with a Macro

[Debuella]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Job Name[/TD]
[TD]Job Complete (Y/N)[/TD]
[TD]Date[/TD]
[TD]Note (Subject of Task)[/TD]
[TD]Create Task?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A1213[/TD]
[TD]N[/TD]
[TD]12/14/2016[/TD]
[TD]Double check if order has been processed[/TD]
[TD](FORM Control Button)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.