myitem

Hello ~ Hello I'm using the following to try and open a saved Outlook Email Template - But I can't escape RunTime 438: "Object Doesn't support this property or method" Dim MyItem As Outlook.MailItem Set MyItem = Application.CreateItemFromTemplate("C:\Users\ABC1234\Desktop\Untitled\*.msg") Set...

Hello Everyone, I'm trying to create a task in Outlook from Excel. I've gotten pretty far in this code but I'm stuck with the start date. Let me know your thoughts Sub tasks() Dim OutApp As Object Dim myItem As Object Dim Body1 As String Const myTitle = "Enter data" myPrompt =...

Hello, I'm trying to write a code which would add files from a specific folder to currently opened email via file dialog box. Could someone help me with this? Sub test() Dim objOutApp As Object, objMail As Object Dim myItem As Outlook.MailItem Dim myAttachments As Outlook.Attachments...

I have a Maco that will open a specific Worksheet. The Save As Dialog Box then appears so the Employee can save the file. Once finished, a two saved .msg Email Templates are opened from a Server that already includes the Address, Subject Line and Body for each Template. Is there a way, within...

I am trying to get rid of some Outlook templates and want Excel to read my Sheet and create the email. A compiler error generates on the Add Recipients line. This worked with a meeting for some reason, it let me just refer to the cell. But the olMailItem does not. I don't want to hard code the...

I wrote this simple script to auto populate info that i do several times a day. When i runt he script I want to be able to add additional information on the subject line. Right now the typing focus is after the to: email, how can i get it to be at the end of the subject line? Sub actupd8() 'Add...