With the help and refinement of several posters on this forum, I created a macro, run from the Outlook vba environment, for inserting a date and time stamp on the front end of an e-mails subject, see below for code. The purpose of the macro is to time stamp the subject of each individual email...
Thanks for responding, yes it is run in the Outlook VBA environment. The purpose of the macro is to time stamp the subject of each individual email in a folder (eg. the Inbox), so that they can be dragged and dropped into a hard drive / server / dvd folder and will then be listed in...
The problem seems to be that Outlook 2010, unlike the 2003 version, will not accept the .save command to update a message subject, hence the error message. Is anybody aware of a method of changing a message subject in VBA that is accepted by Outlook 2010?
With the help and refinement of several posters on this forum, I created a macro in Outlook for inserting a date and time stamp on the front end of an e-mails subject, see below for code.
After updating to Outlook 2010 from 2003, the code which used to operate flawlessly now falls over on the...
I am using data in an Excel sheet to populate bookmarks in a Word document template, see code below for details. To this point, the macro operates perfectly but I am now struggling to place data against an additional bookmark located in the header of the Word template and would appreciate some...
I have numerous rows of data in date headed columns (See A1:D4 below for example).
[tab][tab] A[tab][tab][tab]B[tab][tab][tab]C[tab][tab][tab]D[tab][tab][tab]E[tab][tab][tab]F
1 25/01[tab] 01/02[tab] 08/02[tab] 15/02[tab]<Today >Today...
Tony,
I realise that you are here to help and that is all I'm asking for, not to do it for me, hence if you look at my first response to Skip, you will see that I had tried your MSProject.Project idea, aswell as .Projects.
I appreciate both of you taking the time to respond.
Hi Skip,
I got a compile error "User-defined type not defined" with the second line highlighted, so I changed MSProject.Document to MSProject.Project
The code now terminates at the fourth line:
Set aProj = appProj.Documents.Open(Filename:="C: \MS Project.mpt")
with a Runtime error 438, Object...
I am trying to create a Microsoft Project document from a template, input two pieces of data gathered from an Excel spreadsheet, name the document with the same two pieces of data, save the MS Project file and exit the application.
I have no idea how to open the MS Project application but based...
I use the following VBA code to incorporate the date at the beginning of each e-mail's subject in the Inbox. Is it possible to run the macro on the current folder (Inbox, Sent Items, Whatever), rather than naming a specific location?
Sub AddDateToSubject()
Dim mItem As Object
Dim oFolder As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.