I am designing a database with VBA user forms to input the data. This is all designed in an Excel spreadsheet. One of the options is to place a corrective action item in the database. THis item is paired with a responsible party and a due date.
I have not been able to figure out the syntax to create and send a MS Outlook task to the responsible party. I have code working that can send an email (thanks to TommyGun), but I cannot create the task or attach it to the email.
Any help would be appreciated.
Thanks!!
I have not been able to figure out the syntax to create and send a MS Outlook task to the responsible party. I have code working that can send an email (thanks to TommyGun), but I cannot create the task or attach it to the email.
Any help would be appreciated.
Thanks!!