I will break this “Tutorial” in 3 steps 1) Writing your Excel Macro 2) Preparing your vbscript file 3) Setting the task in Windows Task Scheduler WRITING THE EXCEL MACRO Open a new File in Excel and in the module, paste this code Option Explicit Const strTo As String = “[email protected]” Const strCC As String … Read more
I did a little research and was able to write this code: strbody = “<BODY style=font-size:11pt;font-family:Calibri>Good Morning;<p>We have completed our main aliasing process for today. All assigned firms are complete. Please feel free to respond with any questions.<p>Thank you.</BODY>” apparently by setting the “font-size=11pt” instead of setting the font size <font size=5>, It allows you … Read more
Well this is something I have never come across before, however, I have found a solution. The error message itself got me wondering why the send command wasn’t recognising the defined application. I questioned whether the code was running too fast. (I don’t know where this light bulb moment came from but it has fixed … Read more
You need to consider three points in order to add events automatically: Email Header iCalendar Method ATTENDEE information the “VEVENT” calendar component Email Header In order to get the email client to parse correctly the attached .ics file, you should add the scheduling method and MIME information to the email headers. This is specified by … Read more
This error is because you cannot dim variables as something in particular in VBS. Said more explicitly the “Dim” statement is used without defining the variable type in VBScript because all variables in VBScript are automatically of type Variant. If you attempt to Dim a variable as anything, it will throw an error. Instead, you … Read more
I think you may not be doing anything wrong, because I have experienced exactly the same behaviour. However, in order to debug your VBA, I suggest that you create a macro (via the Tools|Macro|Macros menu) that calls your script function with a test e-mail item that you create in the macro. Maybe something like this: … Read more
I don’t know exactly what’s wrong with your code. For one thing, though, you are not validating that a new, editable email is even open. The following proof-of-concept does exactly what I think you’re looking to do: insert some text into the active email being composed. If this is not possible it displays a message … Read more
There is code avaliable on CodeProject for reading .msg files without COM. See here.
This page has some really good insight on where Outlook keeps all its stuff. It suggests the following: All Outlook macros are stored in a single file named VbaProject.otm in the user’s %appdata%\Microsoft\Outlook folder, which will be a hidden folder on most systems. Now, the problem is that if you do not see them now, … Read more
replace the line Outlook.MailItem mailItem = (Outlook.MailItem) this.Application.CreateItem(Outlook.OlItemType.olMailItem); with Microsoft.Office.Interop.Outlook.Application app = new Microsoft.Office.Interop.Outlook.Application(); Microsoft.Office.Interop.Outlook.MailItem mailItem = app.CreateItem(Microsoft.Office.Interop.Outlook.OlItemType.olMailItem); Hope this helps,