Macro - Setting Outlook Tasks from excel

[larzep]

I have been trolling all over numerous forums to get some idea on a coding that will allow me to create an outlook task with reminders based on some of the cell values within the worksheet. I have been hitting dead ends and been pulling my hair out. If anyone could help that would be greatly appreciated.

The objective of the tasks consist of:

Subject = "Follow up on quotation" & range("G7").value & " " & range("B13").value
Start Date = range("G8").value
Due Date = range("G8").value plus 7 working days from start date
Status = "In Progress"
Priority = "High"
Reminder date: = Due date at 10:00am

Hopefully i can incorporate this into my 'Email' button macro but if it is too difficult then having it as a separate macro will be fine.

My coding for the PDF macro so far is:

Please Login or Register  to view this content.

[larzep]

Does anyone have any idea how i can do this?

[snb]

I don't think the thread title matches your question.