![]() ![]() Body = "Please see the attached email for a service request assigned to you. What I would do as a matter of course when programming is turn on Option Explicit this stops misspelt variables from ruining your day. Receipients are a collection, so you have to add them, again you cant assign them like a propertyĪlso you have misspelt OutTsk at the end. Have a look at the sample here (v=office.15).aspxĪssign is a method and you are using it like a property. The first is to click on the ‘My Day’ option in Outlook and then add a task in the To Do section. Body = "Please see the attached email for a service request assigned to you." I have made a test on my side, Assigning a task to other users is not supported in Outlook tasks connector of Microsoft Flow currently. Subject = "Service Request" & Cells(2, "A") Align tasks from corporate to the frontline Plan centrally, manage regionally, and execute locallyall with one task management tool that provides real-time visibility across all your frontline locations. Set OutTask = OutApp.CreateItem(olTaskItem) Set OutApp = CreateObject("Outlook.Application") Does anyone have any ideas why not? This is the code that I have so far: Dim OutApp As Outlook.Application Assign doesn't seem to work, and neither does Recipient. Here are the steps to create a new task in the classic Outlook Tasks version: Open Outlook. However, I am trying to get the assigned to email address pre-filled from a value in the spreadsheet. You can also click the To button to open the Address Book, then select contacts there. Then they would drag and drop the email as an attachment. Enter the email address that you want to assign the task to in the To field. The admin person would receive the email, fill out a line in Excel, then click on a button to open a new task in Outlook, with fields pre-filled out. ![]() I am attempting to create a service desk tool in Excel, and the way I am thinking of making it easy for the admin to assign them would be to use the tasks in Outlook.
0 Comments
Leave a Reply. |