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. Body = "Please see the attached email for a service request assigned to you." Subject = "Service Request" & Cells(2, "A") 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. However, I am trying to get the assigned to email address pre-filled from a value in the spreadsheet. Then they would drag and drop the email as an attachment. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |